ORA-28575/ORA-32830 On Starting the 10.2 Messaging Gateway Agent On Solaris Intel (Doc ID 468957.1)

Last updated on SEPTEMBER 06, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.3 - Release: 10.2 to 10.2
Oracle Solaris on x86-64 (64-bit)
Checked for currency 06-Sep-10

Symptoms

Multiple symptoms and issues reported on Solaris Intel when starting the Messaging Gateway Agent

1. ORA-28575 on initially starting the agent.

2. The agent then reports an ORA-32830: RESULT CODE -8.

3.
a) On 10.2.0.2 the agent then fails on connecting back into the database with the following error

>>2007-11-02 13:46:15 MGW Engine 0 EXCEPTION main
oracle.mgw.admin.MgwAdminException: [241] Failed to connect to database. SQL error: 12154, connect string: jdbc:oracle:oci8:@
at oracle.mgw.admin.AdminUtil.packageSQLError(AdminUtil.java:640)
at oracle.mgw.admin.AdminMgr.<init>(AdminMgr.java:150)
at oracle.mgw.engine.Agent.start(Agent.java:98)
at oracle.mgw.engine.Agent.agentMain(Agent.java:698)

[Linked-exception]
java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:676)
at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:350)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at oracle.mgw.admin.AdminUtil.getJdbcConnection(AdminUtil.java:207)
at oracle.mgw.admin.AdminMgr.checkAndResetConnection(AdminMgr.java:1219)
at oracle.mgw.admin.AdminMgr.<init>(AdminMgr.java:138)
at oracle.mgw.engine.Agent.start(Agent.java:98)
at oracle.mgw.engine.Agent.agentMain(Agent.java:698)

b) In 10.2.0.3 no error is reported but a core dump is produced while attempting to connect to the database.

>>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms