Recieve ORA-12543 error in RMI log

Document ID : KB000089390
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Recieve ORA-12543 error in RMI log
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.