Home » RDBMS Server » Networking and Gateways » ORA- 12154: TNS:Could not Resolve the service name (Oracle 9.2 - Windows xp)
ORA- 12154: TNS:Could not Resolve the service name [message #427483] Thu, 22 October 2009 16:50 Go to next message
poratips
Messages: 345
Registered: April 2005
Location: IL
Senior Member
Hi,
I got hte new m/c and i have asked my tech support to copy my all the files and programs so i don't have to install again.
After getting new m/c i am having following error during start up, I have multiple Oracle home nad its fine except Ora92.

Oracle Intelligent Agent Executable encountered a problem and needed to close.


The second problem is: when i am opening sql*Plus, i am getting following error:

ORA- 12154: TNS:Could not Resolve the service name


For agent error, fro mthe one of the forum, i tried to stop the agent and deleted all *.q files.

For TNS error: I have tried to replace my new m/c name as host but didn't get any luck.

Thanks is advance!
Poratips

Re: ORA- 12154: TNS:Could not Resolve the service name [message #427485 is a reply to message #427483] Thu, 22 October 2009 17:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ora-12154 = "I can not find the entry in the TNSNAMES.ORA file that I am using (regardless of the one YOU THINK I am using)!"
Re: ORA- 12154: TNS:Could not Resolve the service name [message #427512 is a reply to message #427485] Fri, 23 October 2009 00:54 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
@ BlackSwan
Quote:
Ora-12154 = "I can not find the entry in the TNSNAMES.ORA file that I am using (regardless of the one YOU THINK I am using)!"


Super.... Laughing You are an expert writing errors.
Previous Topic: Can not connect to the designer & Developer
Next Topic: regarding configuring listener.ora and tnsnames .ora
Goto Forum:
  


Current Time: Thu Mar 28 06:21:13 CDT 2024