Troubleshooting
Problem
In some cases, you might have to perform some setup before you can connect to an Oracle database by using the Oracle OCI Default driver.
Symptom
You might see the following error: java.lang.UnsatisfiedLinkError: ocijdbc10 (Library is already loaded in another ClassLoader).
Cause
The PATH environment variable and jar list are not set up correctly.
Resolving The Problem
Ensure that the PATH environment variable is set as indicated below. Set the JAR list as indicated when you create the connection to the Oracle database.
Oracle 11 - Oracle 11 OCI Driver Default:
- PATH contains
$ORACLE_HOME\bin - Jar list contains
$ORACLE_HOME\jdbc\lib\ojdbc6.jaror$ORACLE_HOME\jdbc\lib\ojdbc5.jar
Oracle 10 - Oracle 10 OCI Driver Default:
- PATH contains
$ORACLE_HOME - Jar list contains
$ORACLE_HOME\classes12.jaror$ORACLE_HOME\ojdbc14.jar
Be sure to remove other JAR list entries that point to other versions or copies of the JAR files. Stop and restart the product after you change the PATH environment variable.
[{"Product":{"code":"SSSQRS","label":"Optim Development Studio"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21390316