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:
The message above points to a Bit mismatch between what is used and what is expected.
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:
[[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.
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.