1/You may not need OCI
2/3.0 (oci/thick) had a dependency on 220.127.116.11 oracle client or instant client - are you getting an issue with 18.104.22.168?
Earlier post for 3.0:
<Other customer> has got away with using thin:
Try pure java thin:
1/create tnsnames.ora file
2/Set tnsnames directory
tools->Preferences->Database->advanced->use oci/thick driver unchecked
4/ new connection connection type TNS -> Network Alias (pick from list)
6/May need to set Oracle Home back to SQLDeveloper instalation with for example a .bat file:
(Where %ORACLE_HOME%\jdbc\lib\ojdbc6.jar exists)
Then launch SqlDeveloper from this batch file; this will set your ORACLE_HOME variable to the SQL Developer home directory
If that works - fine no additional software required.
Thick (OCI) has a few more features and is slightly more stable, requires additional software
instant client (or Oracle client or Oracle server) version 22.214.171.124: (This was for 3.0 I need to check 3.1 requirements)
try instant client downloads:
Windows 126.96.36.199 instant client from:
unzip Set PATH and ORACLE_HOME [you can just set them in the session for initial test] (LD_LIBRARY_PATH needs to be set for linux)
Note there is a preference:
- Tools preferences -> database -> advanced -> use oci/thick driver
Thick is required for
new connection connection type TNS -> Connection Identifier.
I was forced to use the thick client with SQLDeveloper because of a bug in the thin client that prevented it from connecting to a RAC through a special firewall configuration.
SQLDeveloper gives the comparability message because there is a version mismatch between the java library ojdbc6.jar (v188.8.131.52) shipped with SQLDeveloper and the OCI library installed with the thick client. In my case I am using the v184.108.40.206 instant client. There is an easy way to fix this even if you have the 220.127.116.11 client installed.
1. Exit SQLDeveloper.
2. Backup the file ojdbc6.jar (v18.104.22.168) located in your SQLDeveloper installation at <INSTALL_PATH>\sqldeveloper\jdbc\lib\.
3. Copy the ojdbc6.jar file from your $ORACLE_HOME (v22.214.171.124) to the location in SQLDeveloper.
I don't know exactly what versions are interchangeable so use caution.