Unable to start RA Oracle Retail Agent
Article ID: 253534
Updated On:
Products
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:
- Stop the Agent.
- 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.
- Remove the old ojdbc14.jar file from the Agent directory, if there is one there.
- 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 - Restart the Agent.
Additional Information
Feedback
