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 09, 2023

Applies to:

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 <LOGIN> <PASSWORD>
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

Changes

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

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.