![]() ![]() So install Oracle 32-bit in a different directory than your 64-bit version and they will both coexist quite nicely. The two installs must reside in different ORACLE_HOME directories though. You can install Oracle 32-bit and Oracle 64-bit on the same server.I chose to install Toad on this particular test server because the machine is in the sand-box environment that prevents connectivity from the net. Installing client GUI tools, such as Toad on production server(s) is not recommended – don’t do it :-). Don’t worry, just key in Oracle TNS alias that you want to connect to (assuming that you put valid TNSNAMES.ORA, SQLNET.ORA in the directory from TNS_ADMIN variable). When you run Toad for the first time you’ll likely see combo box with empty list of TNS aliases. ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |