Java Error when running SQL Job

Document ID : KB000088442
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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

[qa4@vwasup05 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.

  
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.