Failure Error Loading Native Jdbc Driver Library
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta error loading the native oci library Discuss the workings and policies of this site About Us Learn more
Testing Loading Oracle Jdbc Driver ... Failed
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack testing testing native oci library load Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping
Oci Thick Driver Sql Developer
each other. Join them; it only takes a minute: Sign up oracle sql developer connection error up vote 2 down vote favorite 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, sql developer.oci.available false 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") Oracle Instant is located under /usr/lib/java. The directory is set in the SQL Developer (through Database > Advanced) The Oracle server is up and running with default parameters (localhost:7001) and I can a
have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. So you can be up and running in usually less
An Error Was Encountered Performing The Requested Operation Vendor Code 0
than 5 minutes. But if you DO happen to have a Client on your machine,
Sql Developer Use Oracle Client
you'll be happier. If you're too lazy to go read the above post, here it is in a nutshell: JDBC doesn't do ocijdbc12 download everything that OCI can OCI does a better job at reliably cancelling queries OCI has better support for advanced data types including XML So, if you're on-board with the idea of connecting up your Oracle Client with http://stackoverflow.com/questions/24792692/oracle-sql-developer-connection-error SQL Developer, let's talk about how to get that going. Prior to version 4, you would tell SQL Developer to use the ‘OCI/Thick driver' - by the way, OCI stands for ‘Oracle Client Interface.' Yes or No, basically The ‘problem' here is that many of you have more than one Client on your machine. So not being able to explicitly tell SQL Developer WHICH client to use was problematic. So in version 4, we've enhanced http://www.thatjeffsmith.com/archive/2014/01/oracle-sql-developer-4-and-the-oracle-client/ the preferences to allow you to tell us exactly what client to use. Now you can say what client you want us to use Note the actual PATH I have here is: "Instant Client: file:/C:/Program Files/Oracle/11203_x64_InstantClient/instantclient_11_2/" You can put the Instant Client anywhere on your machine, but we need the directory location of where we can find these files: We get really picky, so you need to get this RIGHT. The Preferences Use Oracle Client This tells SQL Developer WHERE your client is. It will then use this location to attempt to load the OCI stuff when doing things like a Password Reset on an expired connection. It won't cause SQL Developer to use the OCI/Thick driver for connections though. Use OCI Thick Driver This DOES tell SQL Developer to make OCI/Thick connections to your Oracle database. It will use the client specified in the previous preference. SQL Developer will attempt to confirm that your Client is available once you click ‘OK.' If it's an Instant Client, it will check the OS Path to make sure it's there. Note we can only look at the first item in the path, so you may get a false positive, in which case you can ignore by clicking ‘Yes' here. This just says, we tried to find this in the Path and failed - you c