-K- wrote:The option is already checked. The problem is that SQL Developer can't use the 64-bit oracle libs I have in my primary ORACLE_HOME. I get an error: "C:\oracle\product\11.1.0\db_1\BIN\ocijdbc11.dll: %1 is not a valid Win32 application". I have also 32-bit instant client, but I can't get SQL Developer to use it.
Now check Preferences - Database - Advanced Parameters - Use OCI/Thick driver and/or use TNS as connection type.
Hope that worked,
-K- wrote:It should work, but it doesn't. SQL Developer gets ORACLE_HOME setting from registry and doesn't seem to respect the ORACLE_HOME environment variable.
Your start.bat should work. Sure the instant client supports OS authentication?
Else install the complete 11g client, which has to work...
It might be a little late for the original post, but maybe someone else will need it:
I found that the way to solve such issue is by specifying the TNSNAMES of the wanted oracle_home. That'll do it.
It could be done in Tools -> Preferences -> Database -> Advanced -> Tnsnames directory.
Tested on Oracle SQL Developer 3.2.20.09 and 22.214.171.124