In FMW 11.1.2 Setup, JDBC OCI Fails With UnsatisfiedLinkError: No ocijdbc10 In java.library.path (Doc ID 1505150.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version 10.2.0.1 and later
Oracle Reports Developer - Version 11.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Despite referencing the correct JDBC jar file in the system CLASSPATH, such as ojdbc6.jar or ojdbc5.jar, attempts to connect to the database fail with:

java JDBCInfo oci myhost 1521 mydb scott tiger
Exception in thread "main" java.lang.UnsatisfiedLinkError: no ocijdbc10 in java.library.path
        at java.lang.ClassLoader.loadLibrary(Unknown Source)
        at java.lang.Runtime.loadLibrary0(Unknown Source)
        at java.lang.System.loadLibrary(Unknown Source)
        at oracle.jdbc.driver.T2CConnection$1.run(T2CConnection.java:3139)
        at java.security.AccessController.doPrivileged(Native Method)
        at oracle.jdbc.driver.T2CConnection.loadNativeLibrary(T2CConnection.java:3135)
        at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:221)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
        at oracle.jdbc.driver.T2CConnection.<init>(T2CConnection.java:132)
        at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:78)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
        at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)
        at JDBCInfo.main(JDBCInfo.java:63)

Sample tests confirm this result, such as the test code provided in the following article:

<Document 467804.1> How To Determine The Exact JDBC Driver Version (9.x - 11.x) For Standalone Programs

Note: On Unix/Linux libocijdbc10 is mentioned rather than ocijdbc10

 

Changes

 The CLASSPATH has been modified to include jar(s) from an 11.1.2 Forms/Reports environment. 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms