Oracle Database Errors or Warnings from Error ORA-28536 to ORA-28545


ORA-28536: error in processing Heterogeneous Services initialization parameters
Cause: An error described by a subsequent error message prevented successful processing of Heterogeneous Services initialization parameters from the ORACLE server data dictionary.
Action: Check server data dictionary views HS_CLASS_INIT, HS_INST_INIT, and HS_ALL_INITS. Look for conditions which could produce the error identified in the error message immediately following this one.
ORA-28537: no more result sets
Cause: This error code was used internally within Oracle Database Gateway and Heterogeneous Services code and should not be reported to a client program.
Action: Contact Oracle customer support.
ORA-28538: result set not found
Cause: The client program tried fetching from a result set that is not open anymore. Many gateways will, on execution of a stored procedure, automatically close all result sets that were returned by any previously executed stored procedure.
Action: Check the documentation for the gateway that you are using and see if it will automatically close currently open result sets each time a stored procedure is executed. Then check if your client program is doing anything that violates this rule. If it is, fix your program. If it is not then contact Oracle customer support.

ORA-28539: gateway does not support result sets
Cause: The client program tried executing a stored procedure that returns one or more result sets through a gateway that does not have result set support.
Action: Check the documentation for the gateway that you are using and see if it supports result sets returned from stored procedures. If it does not, then the only way of accessing such stored procedures is to upgrade to a version of the gateway that does support result sets (if such a version exists). If the gateway does have result set support and you are still seeing this error then contact Oracle customer support.
ORA-28540: internal result set error
Cause: A protocol error internal to Heterogeneous Services or Oracle Database Gateway code has occurred.
Action: Contact Oracle customer support.
ORA-28541: Error in HS init file on line number.
Cause: A syntax error occurred in the gateway initialization file.
Action: Check gateway init file to correct the syntax error. For further information, check the error message in the gateway trace file.

ORA-28542: Error in reading HS init file
Cause: Reading the gateway init file generated an error.
Action: Check the gateway initialization file name to see that the gateway initialization file acctually exists. Check the ifile parameter to see that it points to the correct location.
ORA-28543: Error initializing apply connection to non-Oracle system
Cause: Attempt to initialize connection to non-Oracle for heterogeneous replication failed.
Action: Check if the listener used to connect to the gateway is up and is correctly configured. Make sure that the database link used has been configured correctly and, if a tnsnames alias has been used in the database link definition, make sure that the configuration of the entry in tnsnames.ora has been done correctly.
ORA-28544: connect to agent failed, probable Net8 administration error
Cause: Net8 reported a failure to make a RSLV connection or a protocol mode error when the Oracle server attempted to establish communication with a Heterogeneous Services agent or an external procedure agent. This usually is due to an administration error in setting up Net8 service definitions in TNSNAMES.ORA or LISTENER.ORA: A basic network connection is opened, but it connects to a program which does not use the appropriate protocol. This often is a sign that the connection goes to the wrong program.
Action: Check Net8 administration in the following ways: — When using TNSNAMES.ORA or an Oracle Names server, make sure that the connection from the ORACLE server uses the correct service name or SID. — Check LISTENER.ORA on the agent’s host machine to assure that the service name or SID refers to the correct agent executable in its (PROGRAM=…) clause. — Confirm in TNSNAMES.ORA or the equivalent service definition that sevice ‘extproc_connection_data’ does NOT contain (HS=), or that the service definition used by a Heterogeneous Services database link DOES contain (HS=).
ORA-28545: error diagnosed by Net8 when connecting to an agent
Cause: An attempt to call an external procedure or to issue SQL to a non-Oracle system on a Heterogeneous Services database link failed at connection initialization. The error diagnosed by Net8 NCR software is reported separately.
Action: Refer to the Net8 NCRO error message. If this isn’t clear, check connection administrative setup in tnsnames.ora and listener.ora for the service associated with the Heterogeneous Services database link being used, or with ‘extproc_connection_data’ for an external procedure call.

Above are list of Oracle Database Errors or Warnings from Error ORA-28536 to ORA-28545 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *