Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TOAD/OID and TNSNAMES.ORA

180196Sep 8 2005 — edited Sep 12 2005
We had OID installed on a trial basis here to replace tnsnames.ora files on servers, laptops and desktops. We have since uninstalled and removed all files and registry entries of the application from the server where it was installed.

I had my laptop set up to use OID and I removed my TNSNAMES.ORA file. I have since removed all files from my laptop that had anything to do with OID and I put in a new TNSNAMES.ORA file. At the present time I can delete my TNSNAMES.ORA file from my laptop and TOAD will still connect to Oracle. However, SQLPlus or any other tool I use to connect to Oracle will not connect. Also, I can connect to Oracle databases that are not in my current TNSNAMES.ORA file.

I have scanned my laptop looking for TNSNAMES.ORA files. I have set my registry to include a TNS_ADMIN entry to point to my current TNSNAMES.ORA file and I have set up user and system variables to point to my current TNSNAMES.ORA file but nothing seems to stop TOAD from using the Oracle connection strings that were established in OID. By the way, I uninstalled TOAD, cleaned out all files and registry entries that I know of; then I reinstalled TOAD. That didn't help either.

Does anybody have any ideas of where I can look to resolve this?

Thanks,
Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2005
Added on Sep 8 2005
9 comments
7,264 views