Problems with JWP while trying to change the Oracle Full Client from 12.2 to 19.3 for AE 12.3.1

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

After an update of the underlying Oracle Database from 12.2 to 9.3 the JWPs can no longer start.

At command line interface level the following error is thrown when a startup is attempted:

U00045014 Exception 'java.lang.UnsatisfiedLinkError: "no ocijdbc12 in java.library.path: [/opt/oracle/base/product/client_193000/lib, /usr/lib, /lib, /usr/java/packages/lib, /usr/lib64, /lib64, /lib, /usr/lib]"' at java.lang.ClassLoader.loadLibrary():2670'

All main Oracle System Variables are configured as required: LD_LIBRARY_PATH, TNS_ADMIN, ORACLE_HOME, ORACLE_SID...

 

 

Environment

AE 12.3.1

Oracle DBMS 19.3

Cause

The problem may come from the JDBC driver that is not up to date.

Download the most recent JDBC driver from that link:

https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html

Installing the ojdbc10.jar helps to fix the problem in this particular case.

Resolution

Donwload the most recent JDBC driver accepted by this Oracle version from that link:

https://www.oracle.com/database/technologies/appdev/jdbc-ucp-19c-downloads.html

Installing the ojdbc10.jar helps to fix the problem in this particular case.