Error Loading Native Jdbc Driver Library Sql Developer
Contents |
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 than 5 minutes. But error loading the native oci library if you DO happen to have a Client on your machine, you'll be happier. If you're testing loading oracle jdbc driver ... failed too lazy to go read the above post, here it is in a nutshell: JDBC doesn't do everything that OCI can OCI does a
Sql Developer.oci.available False
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 SQL Developer, let's talk about how to get that going.
Oci Thick Driver Sql Developer
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 the preferences to allow you to tell us exactly what client to use. Now testing testing native oci library load 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 can ignore IF you can connect How Do I Know if I Did it ‘Right?' You can check two things. One - on a disconnected connection, right click. I
von Firefox wird nicht mehr unterstützt. Installieren Sie einen unterstützten Browser.SchließenDateiBearbeitenAnsichtToolsHilfeBedienungshilfenFehlerbehebungNeue Änderungen anzeigenBedienungshilfenNur LesezugriffUnterstützung für Screenreader aktivieren/deaktivieren
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. https://community.oracle.com/thread/508732?start=30&tstart=0 Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in SQL Developer All PlacesDatabaseDatabase Application DevelopmentSQL Developer This discussion is archived 1 2 3 4 Previous Next 55 Replies Latest reply on Jul 21, 2008 9:42 PM by user443012 Go to original post This content has been marked sql developer as final. Show 55 replies 30. Re: Connection Error -K- Jul 6, 2007 9:35 AM (in response to 203328) Can you confirm missing "/lib" in your jdbc.library? Don't know how to change that wrong path, but the easiest would be to put the jars in there. K. Like Show 0 Likes(0) Actions 31. Re: Connection Error 203328 Jul 6, native oci library 2007 9:46 AM (in response to -K-) My current jdbc folder under sqldev root looks like this: C:\sqldeveloper.new\jdbc\lib And files within the lib are (both copied from my oracle client lib as suggested in an earlier post): ojdbc14.jar ojdbc14dms.jar I have the original jars in the folder as well, listed in the folder as 'copy of....jar' B Like Show 0 Likes(0) Actions 32. Re: Connection Error -K- Jul 6, 2007 10:25 AM (in response to 203328) Yes, I know, but can you confirm or correct: "jdbc.library = /C:/sqldeveloper.new/jdbc/ojdbc14.jar" without the "\lib" in there? K. Like Show 0 Likes(0) Actions 33. Re: Connection Error 203328 Jul 6, 2007 10:37 AM (in response to -K-) Oops I misreported the path to the jdbc.library, I'll edit it on my other reply post, sorry. should have been: /C:/sqldeveloper.new/jdbc/lib/ojdbc14.jar Like Show 0 Likes(0) Actions 34. Re: Connection Error -K- Jul 6, 2007 11:11 AM (in response to 203328) In that case I'm out of ideas already :-( Well, if the path could have any influence according to John, you