Archive for the ‘TOAD’ Category

cannot load oraclient9.dll

Friday, January 6th, 2006

Today TOAD kept telling me it couldn’t load oraclient9.dll in the oracle home I was in (I was connecting to a 9i database), and I noticed that the file had a different length than the other two I found on my system. I copied one of those in the oracle home it was looking and it worked.
Unfortunately the lsnrctl also uses that file and expects the old version.

I ended up using a different home for TOAD to use the tnsnames.ora from.

TOAD

Tuesday, December 27th, 2005

Apparently TOAD (8.0.0.47) looks at the TNS_ADMIN environment variable for tnsnames.ora, no matter what you select in your oracle home dropdown.

Also, when one of the other tnsnames.ora files is first in the PATH variable, this screws up its possibility to connect to your database……