I’ve just tried everything I could find googling and still haven’t managed to make this work.
My windows XP workstation’s old hard drive crashed, so I’ve just gotten a new drive with a fresh install of Windows 7 64 bit.
I log on to it with an account that has elevated admin privileges and also an account that does not. Before the hard drive crash and OS upgrade, I was successfully using TOAD to connect to local 11g and remote 10g & 11g databases.
I installed the 64-bit Enterprise Edition of Oracle’s 22.214.171.124.0 RDBMS on this local workstation. I can log on to this db via SQL+. It’s in dbhome_1. It’s in the registry as HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1.
I then installed the Oracle Data Access Components 126.96.36.199.2 64-bit xcopy version. It doesn’t end up in the central inventory, but does have a registry entry KEY_odac_home.
Then I installed TOAD for Oracle - one of my favorite tools ever - and started it up. It did not find my database’s ORACLE_HOME. I thought, well, maybe it needs a client install to set the right flags in the registry. So I installed an instant client into a client_1 ORACLE_HOME. It created another registry entry. I added the ODAC components there as well.
That did not resolve the problem. TOAD keeps showing me an “ORACLE_ROOT” of SOFTWARE\WOW6432NODE\ORACLE" which is an invalid Oracle Home.
I found the doc on how TOAD populates the homes drop-down. I’ve tried adding “ORACLEHOME=c:\app\oracle…\client_1” to the command line. Also ORACLE_HOME=xxxx and \ORACLE_HOME=xxx and OCIDLL=xxx. (xxx being the path to my client ORACLE_HOME). Adding these parameters does help in that I can see the contents of the tnsnames.ora I am pointing to via a TNS_ADMIN system environment variable. However I still can’t connect to any of them. I get the error:
Cannot find OCI DLL: in Command Line Client.
I’ve also tried adding an ORACLE_HOME xxx keyvalue pair at the top-level ORACLE entry in the registry. Doesn’t seem to make any difference. Have also tried putting the database home first and the client home first in the %PATH% variable - direclty and via the Oracle Home Selector tool in the Oracle Universal Installer. All to no avail.
So…I am at a loss here as to what else to try. At this point I’m resigned to perhaps needing to uninstall some or all of the components, but suspect I could easily go to all that trouble (my workstation is pretty slow) and end up with the same problem as I have now. I would surely very much appreciate any suggestions y’all might have.
I’ve never had to mess with the TOAD command line before; would prefer it to find my actual oracle_homes in a normal way.
Thanks very much!