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.