This discussion is archived
4 Replies Latest reply: Jul 30, 2012 1:09 PM by 952871 RSS

SQL developer 3.1 shows error Incompatible version of libocijdbc

916560 Newbie
Currently Being Moderated
I have been struggling with the oci.dll and the ocijdbc.dlls errors for most of the day today.

I deleted my previous SQL Developer 3.0 installation and downloaded the latest 3.1 yesterday.

Problem:
When I try to set up new connections that were working on the previous version, some of them work and two of them show the following error:

Status : Failure -Test failed: Incompatible version of libocijdbc[Jdbc:112020, Jdbc-OCI:112030


I have the JDK 1.6 installed and Oracle ODAC 11.2 32-bit installed as well.

Preferences->Database->Advanced shows the proper directory for the  tnsnames.ora file.


Alternative connection test:

When i try to connect to the database in question via SQLPlus using the command syntax
sqlplus username/password@connect_identifier

sqlplus is able to connect to the database in question and I can run queries in it.



Please help! Thank you.

LizetP

Edited by: Lizet P. on Feb 9, 2012 2:58 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
  • 1. Re: SQL developer 3.1 shows error Incompatible version of libocijdbc
    806917 Explorer
    Currently Being Moderated
    Instead of trying to leverage the tnsnames.ora, why don't you define the connections as type=basic?
  • 2. Re: SQL developer 3.1 shows error Incompatible version of libocijdbc
    TurlochO'Tierney Journeyer
    Currently Being Moderated
    Hi Lizet Pena,

    1/You may not need OCI
    2/3.0 (oci/thick) had a dependency on 11.2.0.2 oracle client or instant client - are you getting an issue with 11.2.0.3?

    -Turloch
    SQLDeveloper Team

    Earlier post for 3.0:

    Hi All,

    <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->Tnsnames Directory
    3/
    tools->Preferences->Database->advanced->use oci/thick driver unchecked
    4/ new connection connection type TNS -> Network Alias (pick from list)
    5/try connection
    6/May need to set Oracle Home back to SQLDeveloper instalation with for example a .bat file:

    set ORACLE_HOME=%CD%
    call sqldeveloper.exe

    (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 11.2.0.2: (This was for 3.0 I need to check 3.1 requirements)
    try instant client downloads:
    http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
    Windows 11.2.0.2 instant client from:
    32bit: http://www.oracle.com/technetwork/topics/winsoft-085727.html
    64bit: http://www.oracle.com/technetwork/topics/winx64soft-089540.html

    From Memory:
    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.

    -Turloch O'Tierney
    SQLDeveloper Team
  • 3. Re: SQL developer 3.1 shows error Incompatible version of libocijdbc
    Chad Juliano Newbie
    Currently Being Moderated
    Lizet,

    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 (v11.2.0.2) shipped with SQLDeveloper and the OCI library installed with the thick client. In my case I am using the v11.2.0.3 instant client. There is an easy way to fix this even if you have the 11.2.0.3 client installed.

    1. Exit SQLDeveloper.

    2. Backup the file ojdbc6.jar (v11.2.0.3) located in your SQLDeveloper installation at <INSTALL_PATH>\sqldeveloper\jdbc\lib\.

    3. Copy the ojdbc6.jar file from your $ORACLE_HOME (v11.2.0.3) to the location in SQLDeveloper.

    I don't know exactly what versions are interchangeable so use caution.

    Regards,
    Chad.
  • 4. Re: SQL developer 3.1 shows error Incompatible version of libocijdbc
    952871 Newbie
    Currently Being Moderated
    Thanks. That solved it for me on SQLdeveloper 3.1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points