1 Reply Latest reply on Jul 17, 2014 7:28 PM by Gary Graham-Oracle

    SQLDeveloper cannot connect to WebLogic 12c using Oracle Instant

    ea586a1a-143e-41ef-9bd3-4cb87981dd14
    ea586a1a-143e-41ef-9bd3-4cb87981dd14 Jul 17, 2014 7:07 AM

      I can't get the connection to work for Oracle WebLogic 12c using SQL Developer. Here is the error that I get when I click connect:

      An error was encountered performing the requested operation:
      

      /usr/lib/java/libocijdbc11.dylib: dlopen(/usr/lib/java/libocijdbc11.dylib, 1): Library not loaded: 
      

      /ade/b/2475221476/oracle/rdbms/lib/libclntsh.dylib.11.1 Referenced from: /usr/lib/java/libocijdbc11.dylib
      

      Reason: image not found  Vendor code 0

      When I click Test in the Settings of SQL Developer I get the following log:

      Testing the Instant Client located at /usr/lib/java Testing client directory ... OK
      

      Testing loading Oracle JDBC driver ... OK
      

      Testing checking Oracle JDBC driver version ... OK
      

      Driver version: 11.2.0.3.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 DYLD_LIBRARY_PATH.
      

      Check it to verify that the expected native library directory /usr/lib/java is present and precedes any other client installations.
      

      java.library.path = /Users/gasim/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.

      Here is an outline of my setup:

      • Operating system: OSX Mavericks (10.9.4 to be specific)
      • The Java SE Runtime version: "1.8.0" (build "1.8.0_11-b12")
      • java.library.path = /Users/gasim/Library/Java/Extensions:/Library/Java/Extensions:/Network/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java:.
      • Oracle Instant is located under /usr/lib/java. The directory is set in the SQL Developer (through Database > Advanced)
      • Oracle Instant Client version: 11.2.0.4.0
      • WebLogic Server version: 12.1.3.0.0
      • WebLogic Instance running at localhost:7001; Its configured properly as I can enter the web console.
      • SQL Developer version: 4.0.2.15 (build 15.21)
      • The directory listing of /usr/lib/java:
      BASIC_README 
      

      adrci genezi
      

      libclntsh.dylib.11.1 
      

      libnnz11.dylib 
      

      libocci.dylib.11.1 
      

      libociei.dylib 
      

      libocijdbc11.dylib 
      

      ojdbc5.jar 
      

      ojdbc6.jar 
      

      uidrvci 
      

      xstreams.jar

      Am I missing something here? All the library files are listed in the library path but why does it try to load the library from this path /ade/b/2475221476/oracle/rdbms/lib/libclntsh.dylib.11.1? What can I try to solve this problem or at least debug to find it?

        • 1. Re: SQLDeveloper cannot connect to WebLogic 12c using Oracle Instant
          Gary Graham-Oracle
          Gary Graham-Oracle Jul 17, 2014 7:28 PM (in response to ea586a1a-143e-41ef-9bd3-4cb87981dd14)

          Isn't there some sort of warning when configuring the Oracle Home/Instant Client in Tools > Preferences > Database > Advanced to the effect that the PATH variable must include that Home/Instant Client first (or at least before any other Home/Instant Client)?  I see something similar in your test output:

          Check it to verify that the expected native library directory /usr/lib/java is present and precedes any other client installations.

          but is seems different from Windows.  On Windows, the PATH gets concatenated into java.library.path and it must include the path to Home/InstantClient.


          Regards,

          Gary

          SQL Developer Team