This content has been marked as final. Show 47 replies
If you use oci based connections , you need an 11 oracle_home. Do you have this ?
I take it you mean Oracle 11? I didn't see anything to indicate this requirement. I just wanted to connect to a 10g instance over TNS and assumed the jdbc/oci infrastructure would be in place...
So is this version only for 11g?
Just this in the README:
" The JDBC drivers shipped are 11g R1. This means that users will no longer be able to connect to an Oracle 8.1.7 database."
Irt also notes it should be good for >= 9.2.
SQL Developer 1.5 is supported and tested for all versions of the Oracle Database from 9.2 and above.
Well yes and no - everybody's right here. Normal connections work (you won't even need a client for Basic connections), but mind for OCI an 11g client is needed...
According to the above info, it appears that you need to install the Oracle 11g client driver, correct, or does the verbage above imply that Sql Developer has all of the 11g drivers that it needs?
What I want to do is use the OCI client with the Sql Dev 1.5. I downloaded the Instant Client, and unzipped it into a directory (I'm using Windows). I have the 9i drivers currently installed. I can get Sql Dev to work, but I want to use LDAP. When I select LDAP, I can see the service names, but when I try to connect, I get: 'no ocijdbc11 in java.library.path'. I moved ocijdbc11 from the instant client folder to the jdbc folder under Sql Dev.
Can anyone help me?
LDAP based connections do not require the OCI driver. They can be created using the Thin driver too.
Please check if you have "Use OCI/Thick driver" preference set. When this pref. is set, connections are created using OCI driver by default.
This preference is available in Database - Advanced Parameters.
no ocijdbc11 in java.library.path - This can be resolved by placing the Instant client files (oci dll files) in the system path.
I am running on a 10.2.0.3 instant client.
I am getting the same error.
I don't get this error on a full install of the 10.2.0.3 client.
I thought SQL developer could work with or without an Oracle client.
Note that there is a similar bug logged:
7205317 CONNECT FROM WORKSHEET WITH TNS ENTRY REQUIRES 11GOCI (THICK DRIVER)
Just like to comment that you must use the OCI driver if your DB accounts are set to expire periodically - at least SQL Developer says it cannot change an expired password without OCI.
If you deselect OCI, you'll have to use something like the microsoft ODBC applet to change an expired password.
How did you set up your connections? You didn't happen to import another Developer's connections, did you?
If you did, you probably will get this error. If that's the cause, here's the workaround that is working for me:
Open the connection properties, Click Test, then Save.
Should be able to connect after that.
After using previous versions of SQL Developer successfully (with Oracle10g client installed), first attempt to use SQL Developer 220.127.116.11 to connect to a database fails with "no ocijdbc11 in java.library.path". As the previous contents of this thread refer to earlier SQL Developer releases, I am posting in hopes of finding a solution. Thanks.
I am on the same boat - I downloaded the new version (18.104.22.168) and I get the same error message. I don't have Oracle 11 Client installed on my machine - I only have 81, 92, and 10. Did anyone figure out how to make this version work with a 10 client?
I got the same problem with sql Developer 2.1 and sql*net 10.2.04. Is there a workaround ?