Home » RDBMS Server » Networking and Gateways » ORA-12154: TNS:could not resolve service name
ORA-12154: TNS:could not resolve service name [message #16002] Fri, 05 November 2004 14:21 Go to next message
Cynthia
Messages: 18
Registered: February 2000
Junior Member
Hello,

I keep getting this error every time I want to connect to my database through SQL Plus 9.2.0.1.0.

I can connect without any problems through the OEM 9.2.0.1.0.

Any suggestions?

My tnsnames.ora seems to be ok (at least it is exactly like the one that one of my workmates have and in his computer he can connect without any problems... he has installed only Oracle client tools)

Thank you,

Cynthia
Re: ORA-12154: TNS:could not resolve service name [message #16013 is a reply to message #16002] Sat, 06 November 2004 01:17 Go to previous messageGo to next message
Safeeq
Messages: 21
Registered: September 2004
Junior Member
Hi,
I too have faced this problem and i just renamed the sqlnet.ora to "sqlnet.ora.old" and now its working fine.
But there renaming is the file not only reason for getting ORA-12154.Try renaming the sqlnet.ora and if still the problem persists,
visit http://www.easywebtech.com/oracle/con_err.html
Re: ORA-12154: TNS:could not resolve service name [message #16027 is a reply to message #16013] Sun, 07 November 2004 02:21 Go to previous message
KR
Messages: 2
Registered: November 2000
Junior Member
Have you configured your Node in Net8Assistant?This problem that you are facing might be due to that if you are accessing a database over a network.You have to define the service name in net8assistant.You can ask one of your co-workers about it.

Hope that ur problem will be solved.
Previous Topic: cannot connect to DB on another machine
Next Topic: Oracle-VB connectivity from client machine
Goto Forum:
  


Current Time: Fri May 03 09:11:42 CDT 2024