I have installed sqldeveloper 4.1.3.20.78-x64 on my computer. I extracted the zip file and placed the extracted the files to C:\Program Files\sqldeveloper to avoid getting scanned by McAfee every time I open it.
I have the Oracle 11g full client installed on this computer. I am running Win7 64 bit.
I use a program that connects to my Oracle database using a TNS string. I have 3 databases; one for each version of the program I'm testing. I can open the program and connect to each database successfully. Each ODBC instance is configured as MS ODBC for Oracle per the vendor requirement.
I have some backdoor things I need to do, so that's why I installed sqldeveloper. I installed this on another computer and am able to connect to one database but not any others. I get the "no ocijdbc12" error when I try to connect to database #2 or #3. This other computer also has the 11g client installed.
So I put this on my main computer. I open sqldeveloper and set up the connections. I get the no ocijdbc12 in java.library.path error no matter what database I try to connect to.
I downloaded the instant client version 12 (I'm thinking that is the ocijdbc12 vs ocjdbc11 message) and placed it C:\temp\instantclient-basic-nt-12.1.0.2.0.zip\instantclient_12_1. I created and set the ENV variables per:
Set the DYLD_LIBRARY_PATH and the NLS_LANG environment variables to the full path of the instantclient_11_2 directory.
Only I pointed to the instant client version 12.
I open sqldeveloper I have gone to Tools/Preferences/Database/Advanced. I selected "Use Oracle client," selected Instant Client, and entered the path to the instant client. I checked Use OCI/Thick driver. It restarted.
Then when i try to test my db connections, Failure - Test failed: no ocijdbc12 in java.library.path.
I know I have the TNS name right, and the username and passwords.
Any other suggestions?
Thanks,
Susan Cannon