My guess is that in switching to the 10g client, Oracle still thinks you are looking for the 9i TNSNAMES.ORA file... in the Windows version of Oracle Client(s) it uses a registry setting to tell all Oracle products which "Oracle Home" to use for tnsnames entries. I would check which client is in use. It's been a while since I've looked for it, but I seem to remember it to be here:
\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
I think the Key you are looking for is something like CURRENT_HOME or ORACLE_HOME... it should point to your 10g directory, not the 9i one...
Hopefully, this will help...
No comments:
Post a Comment