search cancel

Unable to start RA Oracle Retail Agent

book

Article ID: 253534

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

RA Oracle Retail Agent fails to start and shuts down with the below error in the agent log file 

 Error connecting to database

U02013310 Failed to load RA Agent.

U00003620 Routine 'UCEX_R' forces trace because of error.

U02000048 TRACE file opened with flags '0000000000000001', max.trace: '9', memory trace: '0', search type: 'S', search string: ''.

U00003449 Output to the TRACE file is finished.

U07001001 Charset used by the Agent: 'ISO-8859-15'

U02000041 Shutdown Agent 'RA_ORACLE_RETAIL'.

Error in the Trace file

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
 at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)
 at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:589)

Environment

Release : 12.x

                21.x

Component: Automation Engine

Sub-Component: RA Oracle Retail agent

Cause

As seen in the Trace file this is due to the missing JDBC driver 

Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Resolution

Configuring the RA Oracle Retail Agent to connect to an Oracle 12c Application Database requires the ojdbc6.jar JDBC driver file. To put the ojdbc6.jar file in place:

    1. Stop the Agent.
    2. Copy the JDBC driver ojdbc6.jar file from the Oracle database client installation to the lib directory.

The file is located at ORACLE_HOME/jdbc/lib/.

For On Directory
Automation Engine v11 or above UNIX bin/lib
Windows bin\lib
Automation Engine v9 or 10 UNIX bin/shared
Windows bin\shared

If you want to save the old file, you can copy it to a backup location outside the path of the Agent.

  1. Remove the old ojdbc14.jar file from the Agent directory, if there is one there.
  2. Unpack the ojdbc6.zip file, and copy the new ojdbc6.jar file to the Agent directory as follows:
    On Directory
    UNIX bin/lib
    Windows bin\lib
  3. Restart the Agent.

 

Additional Information

https://docs.automic.com/documentation/webhelp/english/ALL/components/RA_ORACLE_RETAIL/latest/Agent%20Guide/Content/RA/OracleRetail/AWI/Creating_an_Oracle_Retail_JDBC_and_Program_Connection_Objects.htm