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...

 

 

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.

Environment

AE 12.3.1

Oracle DBMS 19.3

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.