OAE Agent is stuck in Unavailable status

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After installing and configuring the OAE Agent, it fails to start and stays in an Unavailable status.

While there could be a number of reasons this may occur, and a review of the Agent logs needs to be reviewed for more information, a common error seen is:

ErrorMsg: AwE-9999 Internal error (2/12/25 1:44 PM) 
Details: oracle.jdbc.driver.OracleDriver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at com.appworx.server.sql.AxConnectionPool.<init>(AxConnectionPool.java:106)
    at com.appworx.server.sql.DBAccess.A(DBAccess.java:1971)
    at com.appworx.server.sql.DBAccess.getNamedConnection(DBAccess.java:1640)
    at com.appworx.server.sql.CommonDB.B(CommonDB.java:559)
    at com.appworx.server.sql.CommonDB.A(CommonDB.java:546)
    at com.appworx.server.sql.CommonDB.setNamedConnection(CommonDB.java:649)
    at com.appworx.agent.generic.B.updateAgent(GenericAgent.java:774)
    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:122)
    at com.appworx.util.InvokeRequest.invokeMethod(InvokeRequest.java:47)
    at com.appworx.agent.AbstractAgent.invoke(AbstractAgent.java:590)
    at com.appworx.agent.AgentService.invoke(AgentService.java:1312)
    at com.appworx.agent.AgentSocketManager$_A.doRun(AgentSocketManager.java:481)
    at com.uc4.be.threading.AbstractWorker.run(AbstractWorker.java:367)
    at java.lang.Thread.run(Unknown Source)

Cause

Missing ojdbc*.jar in the Agent's $AW_HOME/web/classes directory or %AW_HOME%\web\classes (Windows OS) directory.

Resolution

Move a copy of the recommended ojdbc*.jar from Oracle's $ORACLE_HOME/jdbc/lib or %ORACLE_HOME%\jdbc\lib (Windows OS) to the OAE Agent's $AW_HOME/web/classes or %AW_HOME%\web\classes directory, and restart the OAE Agent.