no ocijdbc11 in java_no ocijdbc11 in java.library.path (Win 7) — oracle-tech

ODAC package may be a bit much, if you just need Client libs for SQL Developer.

Since it seems you are using 64-bit sqldev / jvm, Instant Client for 64-bit may be found via:

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Instant Client package - Basic Lite alone should be enough. From instantclient_11_2 in the archive, just drop the files ocijdbc11.dll, oci.dll and oraociicus11.dll in sqldeveloper folder (same dir as the .exe).

If you have Oracle Home's (64-bit in this case) installed on the machine, you may need to find a way to stop Sql Developer from searching Home registry entries and thus avoid picking up Net config files (tnsnames.ora, sqlnet.ora) from such places.

Though, when testing, for TNS connection type with Network alias drop down it did not matter setting PATH, TNS_ADMIN or planting a oracle.key file (then bouncing sqldev), either way it found a Home and searched it for Net config files. I'm not sure why. A simple workaround however, is to use Connect Identifer field instead with easy connect syntax (no tnsnames.ora necessary).

Note, for Connection type TNS / network alias, the error may appear if 'use OCH/Thick driver' is ticked in preferences. Otherwise the included thin client will be used, hence no need for OCI/Instant Client.

Hope this helps.

Edit:

2)

Added some clarification about driver usage.

1)

I wanted to add, related to testing the setup, that docs states about JDBC OCI Instant Client:

(http://docs.oracle.com/cd/E11882_01/java.112/e16548/instclnt.htm

http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/oci01int.htm#i423362)

>

•Only one set of Oracle libraries should be specified in the library path environment variable. That is, if you have multiple directories containing Instant Client libraries, then only one such directory should be specified in the library path environment variable.

•If you have an Oracle home on your computer, then you should not have the ORACLE_HOME/lib and Instant Client directories in the library path environment variable simultaneously, regardless of the order in which they appear in the variable. That is, only one of ORACLE_HOME/lib directory (for non-Instant Client operation) or Instant Client directory (for Instant Client operation) should be specified in the library path environment variable.

>

However, I'm not sure how to achieve such setup properly in the context of SQL Developer on Windows. For example, Sqldeveloper seem to regardless of system env settings, look for ORACLE_HOME via Registry node/tree. But my test was by no means exhaustive.

Edited by: orafad on Dec 7, 2011 12:39 PM

Edited by: orafad on Dec 7, 2011 11:03 PM

Edited by: orafad on Dec 8, 2011 1:32 AM