ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Java Error when running SQL Job

book

Article ID: 88442

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Detailed Description and Symptoms

The following error might appear when trying to run a SQL job or viewing the database from the SQL tab of the job.

U2012031 The database driver returned the following error message:

 java.lang.UnsatisfiedLinkError: /opt/oracle/product/10.2.0/4.0_client/lib/libocijdbc10.so: /opt/oracle/product/10.2.0/4.0_client/lib/libocijdbc10.so: wrong ELF class: ELFCLASS64 (Possible cause: architecture word width mismatch)

The message above points to a Bit mismatch between what is used and what is expected.
Investigation

Check the Bit of the database 64 vs 32. Check this by logging into SQLPlus from the command line:

What version of Java is used to start the Agent?

Check using the command:

Java -version

[[email protected] v9]$ java -version
java version "1.6.0_27"
Java(TM) SE Runtime Environment (build 1.6.0_27-b07)
Java HotSpot(TM) 64-Bit Server VM (build 20.2-b06, mixed mode)

Unless it says 64-Bit, it's 32-Bit.

  

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

The Java used to start the Agent needs to match the Bit of the database. The JDBC connection uses the Java used to start the Agent.