Autosys Webserver failed to launch using JDBC OCI connection link

Products

• Autosys Workload Automation

Issue/Introduction

Autosys webserver failed to launch after changing the "oracle.tns.connection.string=" in the $AUTOSYS/config/connection.properties to use the "oci" to "thin" connection.

# oracle.tns.connection.string=jdbc:oracle:thin:@${dbname}
oracle.tns.connection.string=jdbc:oracle:oci:@${dbname}

The following error message has been captured in the web server logs under $AUTOUSER/out directory (waae_webservices.log and waae_webservices_wrapper.log).

INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.144--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)
INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.145--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)
INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.147--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)
INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.148--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)
INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.149--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)
INFO   | jvm 1    | 2022/04/20 08:47:10 | [EL Severe]: ejb: 2022-04-20 08:47:10.15--ServerSession(1035840498)--java.lang.UnsatisfiedLinkError: ocijdbc19 (Not found in java.library.path)

Environment

Release : 12.0 and higher

Component :

Cause

The required libraries do not exist in the "java.library.path" provided.

Resolution

Renew the ojdbc8.jar

Copy ojdbc8.jar file from oracle 19c 64bit client's $ORACLE_HOME/lib to $AUTOSYS/lib and $AUTOUSER/webserver/webapps/AEWS/WEB-INF/lib/.

Replace the existing and update the ownership and permissions to match with other libraries in the directory.

Update the webserver's tomcat wrapper.conf file ($AUTOUSER/webserver/conf/wrapper.conf)

wrapper.java.library.path.1=<oracle_client_install_location>/lib
wrapper.java.library.path.2=%AUTOSYS%/lib

Update the webserver startup script (waae_webserver.$AUTOSERV) under $AUTOUSER/webserver/bin to set the LD_LIBRARY_PATH variable pointing to <oracle_client_install_location>/lib 

export LD_LIBRARY_PATH=<oracle_client_install_location>/lib:$LD_LIBRARY_PATH

Restart the Webserver service.

# unisrvcntr restart waae_webservices.$AUTOSERV

Additional Information

Configure the Java Database Connectivity Driver to Use Oracle Call Interface

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/Before-You-Begin/environment-and-database-connection/configure-the-java-database-connectivity-driver-to-use-oracle-call-interface.html