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!

How to change the TNSPING Path when I have many ver of Oracle installed

658970Sep 9 2008 — edited Sep 10 2008
Hi All,
I currently have Oracle version 8.05, 8.1.7 and 10.2 installed on my machine. OS = W2k3 Server

However, I am unable to change the tnsping.exe path from 10.2 to point back to 8.1.7.
I have already moved the 10.2 path to the end of the PATH setting. I.e.
8.1.7 Path = C:\orant\bin;
10.2 Path = C:\oracle\product\10.2.0\client_1\bin

From cmd;
PATH=C:\orant\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\W
INDOWS\System32\Wbem;C:\Program Files\Perforce;c:\Program Files\Microsoft SQL Se
rver\90\Tools\binn\;C:\Program Files\Windows Imaging\;C:\Program Files\IDM Compu
ter Solutions\UltraEdit-32;C:\oracle\product\10.2.0\client_1\bin

Even after doing the above, "where tnsping.exe" in the command prompt shows me the 10.2 path.
If I go ahead and remove the 10.2 path from my env variable, then of course the system is unable to find tnsping.exe in the first place.

All help is much appreciated. If this issue has been addressed earlier, do forward me to the appropriate thread.

Thanks,
Varun

FYI - Even though I have set my Oracle_Home = C:\orant\, it seems like 10g clients don't respect the regkey changes.
Is that because 10g clients work differently to 8i/9i clients?
8i clients put in a Home0, Home1 folder in the registry, while 10g seems to put in folder names like KEY_OraClient10g_home1, KEY_OraClient10g_home2
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2008
Added on Sep 9 2008
3 comments
3,807 views