XP-rience

Referring to Toad + Oracle instant client, I tried to set it up but unfortunately it doesn't work out for me. Some extra additional steps help to resolve the issue and I love to share it here.

First, download Oracle Client from Oracle Database Instant Client. Instant Client Package - Basic Lite wil do just fine. (about 17MB)

Next, create 4 folders ( recommended under c:\Program Files ) according to folder hierarchy below;



You should have 4 folders.



Now, extract the Instant Client Package to C:\Program Files\oracle\bin ( make sure the oci.dll is in the C:\Program Files\oracle\bin )



Right click at My Computer > Properties > Goto Advance tab > Click Environment Variables. Add listed Environment Variables below to your OS.





Under system variables, edit Path, add C:\Program Files\oracle\bin to the end of other path (don't forget to separate it with ";")



Copy/create 3 simple *.ora files below to C:\Program Files\oracle\network\admin



tnsnames.ora



sqlnet.ora


ldap.ora


Finally, test it out.



The drop down button seems to be highlighted in red but it works. I've tried it with several DB connections.