How to change the TNSPING Path when I have many ver of Oracle installed
658970Sep 9 2008 — edited Sep 10 2008Hi 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