Oracle SQL Developer – Issue with JDBC Driver

jdbcoracleoracle-sqldeveloperwindows-7-x64

I've:

  • Windows 7 x64
  • My 11G Oracle client as per below
    C:\Oracle\product\11.2.0\client_1
  • My SQL Developer (downloaded the kit with JDK 8 included, but installed the JSK separately just in case) dir as per below
    C:\sqldeveloper

When I try to connect using TNS I have

no ocijdbc12 in java.library.path

If I go to Settings -> Database -> Advanced and choose my Oracle dir manually I get this:

Testing the Oracle Home located at C:\Oracle\product\11.2.0\client_1
Testing client directory … OK Testing loading Oracle JDBC driver …
OK Testing checking Oracle JDBC driver version … Failed: Minimum
driver version 11.2.0.3 required, specified driver version is
11.2.0.1.0

So I looked into upgrading the JDBC driver, but I can't use the check for updates feature, since it appears to be blocked in my virtual machine.

I got the ojdbc7.jar from the SQL developer directory and copied it to C:\Oracle\product\11.2.0\client_1\jdbc\lib, and now I get the error below:

Testing the Oracle Home located at C:\Oracle\product\11.2.0\client_1
Testing client directory … OK Testing loading Oracle JDBC driver …
OK Testing checking Oracle JDBC driver version … OK Driver
version: 12.1.0.2.0 Testing testing native OCI library load …

Failed: Error loading the native OCI library The native OCI driver
could not be loaded. The system propertyjava.library.path contains the
entries from the environment variable PATH. Check it to verify that
the expected native library directory

C:\Oracle\product\11.2.0\client_1\bin is present and precedes any
other client installations. java.library.path =
C:\sqldeveloper\jdk\jre\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Oracle\product\10.2.0\client_1\bin;C:\Oracle\product\11.2.0\client_1\bin;C:\Oracle\product\11.2.0\client_2;C:\Oracle\product\11.2.0\client_2\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\ARQDISP\;C:\Program
;.

Have no idea what I'm doing at this point. Could you please help?

Best Answer

Its missing drivers. So in my case I installed Oracle Client from http://www.oracle.com/technetwork/topics/winx64soft-089540.html and set the path variable accordingly.

Here's a blog post that shows how to tell SQL Developer where and which installed client to use :

https://www.thatjeffsmith.com/archive/2014/01/oracle-sql-developer-4-and-the-oracle-client/

Restart your SQL Developer.