lmgre.blogg.se

Set oracle_home=D:\ORACLE\instantclient_11_1

Set PATH=D:\ORACLE\instantclient_11_1 %WINDIR% %WINDIR%\SYSTEM32

So the version that works is slightly modified: It’s mandatory that you exclude from the path all other Oracle client software that is not part of the instant client. The important part is line with SET PATH, where I put 11g client in the front of other directories, already in the path variable, including some 10g homes. Set TNS_ADMIN=D:\ORACLE\instantclient_11_1 Set ORACLE_HOME=D:\ORACLE\instantclient_11_1 Set PATH=D:\ORACLE\instantclient_11_1 %PATH% My first attempt of setting environment was something like this: Instead I downloaded 32-bit Oracle instant client 11.1.0.6.

Since all other Oracle Software installed on this test box is 64-bit, I didn’t want to install full blown 32-bit Oracle client just for the sake of running Toad. Of course, my first thought was to use SQL Developer, but in this particular case Toad was a better choice. While working on my Windows 圆4 test server, trying to reproduce ( yet another) critical Oracle bug related to compressed tables, I thought some help from the GUI tool can easy my research.