SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to set ORACLE_HOME used by SQL Developer?

220870Jun 4 2009 — edited Jul 24 2013

I need to use OCI/Thick driver with SQL Developer to get OS authentication working. I have 64-bit windows and 64-bit oracle installed. I also have 32-bit instant client in another ORACLE_HOME, because the libs of 64-bit ORACLE_HOME won't work with SQL Developer. Quite trivial setup if the SQL Developer would just take the hint an start using the right ORACLE_HOME. I have tried making a start.bat containing following...

set ORACLE_HOME=C:\oracle\product\11.1.0\instantclient_11_1
start sqldeveloper.exe

..but it doesn't have any effect. I can't change ORACLE_HOME in registry, because it would mess up other services requiring 64-bit oracle.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 21 2013

Added on Jun 4 2009

#sql-developer

7 comments

28,851 views