ORA-12154 with 11g client; tnsping resolves correctly

[James B]

I've seen this in other posts here at the forum, but the solution was always to upgrade to 11g... I'm running 11g, and I'm getting ORA-12154, could not resolve the connect identifier, when I try to connect from within PL/SQL Developer... tnsping successfully resolves.

I'm running Windows 7 x64, so PL/SQL developer is installed to C:\Program Files\ (no parentheses), and I'm running 11g anyway, so that bug shouldn't affect me. My Oracle_Home in HKLM\SYSTEM\CurrentControlSet\Control\Session Manager\Environment is set correctly.

I did have 10.2.0.3 installed, and PL/SQL Dev connected fine. I uninstalled 10.2.0.3 before installing 11g, and reinstalled PL/SQL Dev 7.1.5 after that. This may just be an old setting floating around... I just can't figure out what/where.

Any ideas?

Thanks!
James

 

[James B]

I reinstalled 10.2.0.3, and PL/SQL Developer now connects.

I removed the 10.2.0.3 client directory and deleted the reference to it in the path. PL/SQL Developer still connects, and is using the 11g DLL.

I uninstalled 10.2.0.3 completely using the Oracle installer, and PL/SQL Dev still connects. So I believe my problem is resolved, though I'm still not sure what the problem was.

Thanks!