Recieve ORA-12543 error in RMI log

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Recieve ORA-12543 error in RMI log

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Symptoms

Error code: ORA-12543: TNS:destination host unreachable shows in RMIServer debug log after AwE-5001 Database Query Error is thrown.

---

Cause

This is an Oracle error that is outside of the AM product that means that the database is unreachable.

Here is the full wording of the error within the RMIServer debug log:

java.sql.SQLException: ORA-12543: TNS:destination host unreachable

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:589)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1957)
 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:850)
 at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2555)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2896)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:644)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:570)
 at com.appworx.server.sql.DBAccess.getSqlData(DBAccess.java:487)
 at com.appworx.server.sql.CommonDB.getSqlData(CommonDB.java:186)
 at com.appworx.server.data.MasterDB.getSqlData(MasterDB.java:307)
 at com.appworx.server.data.MasterDB.getSqlData(MasterDB.java:261)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at com.uc4.be.util.InvokeUtil.invoke(InvokeUtil.java:105)
 at com.appworx.util.InvokeRequest.invokeMethod(InvokeRequest.java:47)
 at com.appworx.server.data.C.A(ClientServices.java:146)
 at com.appworx.server.data.C.A(ClientServices.java:132)
 at com.appworx.server.data.D$_A.doRun(RemoteClientSocketManager.java:175)
 at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:390)
 at java.lang.Thread.run(Unknown Source)

---

Resolution

Make sure your database is up and that your TNS listener is functioning properly.