Print Thread
ORA-12154 with 11g client; tnsping resolves correctly
#38215 06/10/10 02:47 PM
Joined: Jun 2010
Posts: 35
J
James B Offline OP
Member
OP Offline
Member
J
Joined: Jun 2010
Posts: 35
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

Last edited by James B; 06/10/10 02:47 PM.
Re: ORA-12154 with 11g client; tnsping resolves correctly
James B #38216 06/10/10 03:19 PM
Joined: Jun 2010
Posts: 35
J
James B Offline OP
Member
OP Offline
Member
J
Joined: Jun 2010
Posts: 35
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!


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.037s Queries: 15 (0.013s) Memory: 2.4987 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-06-26 05:52:22 UTC
Valid HTML 5 and Valid CSS