ORA-12154: TNS:could not resolve the connect identifier...

Linux howto's, compile information, information on whatever we learned on working with linux, MACOs and - of course - Products of the big evil....
Post Reply
User avatar
^rooker
Site Admin
Posts: 1483
Joined: Fri Aug 29, 2003 8:39 pm

ORA-12154: TNS:could not resolve the connect identifier...

Post by ^rooker »

[PROBLEM]
(Oracle 10g / windows)

Althouth the net configuration assistant passes a connection test to a given TNSname, any other application throws this error message:
ORA-12154: TNS:could not resolve the connect identifier specified
Checking sqlnet.ora and tnsnames.ora doesn't reveal any errors, although almost all knowledge base entries point out that this ORA-12154 is a result of a misconfiguration within one of those files.


[SOLUTION]
If you've installed an oracle client on that machine.... REBOOT IT!
And then try again. Hey! It's windows! :roll:
Post Reply