I have Oracle Client 32 bit and Oracle Client 64 bit installed on my Win7 machine.
Yesterday I was able to connect to my databases via SQL DEVELOPER (4.0.3). I had to reboot my machine this morning and now when I try and connect to my databases, I get the following error:
no ocijdbc11 in java.library.path
I have Win7
I have Oracle Client 32
I have Oracle Client 64 (I need both as I support legacy systems that still use 32 bit)
I have SQL developer 4.0.3
I have set Tools > Preferences > Database > Advances > TNS Names Directory to the 64-bit path and I have confirmed that the TNSNames.ora file is located in that Oracle Client\Network\Admin folder
I noticed that Tools > Preferences > Database > Third Party JDBC Drives list box is empty. I tried to add an entry here to the Oracle\Client\JDBC\bin\ folder and I have ojdbc7 in there. (not sure if this is needed as I use TNS to connect)
I don't know what else to do. Can someone assist?
you don't need a client to use tnsnames
in advanced preferences, disable the use client/thick connections
and then be sure your setting for tnsnames file directory points to the tnsnames you want to use
restart sqldev, try your connection