![]() ![]() 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. Note Choose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server. For the 64-bit version of Power BI Desktop, download and install the 64-bit Oracle 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. For the 32-bit version of Power BI Desktop, download and install the 32-bit Oracle client. 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 |