OraFAQ Forum: Networking and Gateways » Failure to start SQL* Plus

Home » RDBMS Server » Networking and Gateways » Failure to start SQL* Plus - "TNS could not resolve service name"

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Failure to start SQL* Plus - "TNS could not resolve service name" [message #13281]

Tue, 06 July 2004 00:21

Andile Khanyile
Messages: 1
Registered: July 2004

Junior Member

I have loaded the Oracle database software on to my PC/Server running on windows XP operating system.� I have a problem with starting SQL* Plus for SQL development.� I get the error message "TNS could not resolve service name" each time I start it.� What could be the problem? Please advise.

Report message to a moderator

Re: Failure to start SQL* Plus - "TNS could not resolve service name" [message #13302 is a reply to message #13281]

Tue, 06 July 2004 23:56

Adrian Billington
Messages: 139
Registered: December 2002

Senior Member

You need to check your tnsnames.ora file in ORACLE_HOMEnetworkadmin to ensure you have entered your instance details. As the error message mentions "SERVICE", it would suggest that you have a "SERVICE=something" in the tnsnames.ora but no service defined in the listener.ora. You could try changing SERVICE=something to SID=your_sid instead.

HTH
Adrian

Report message to a moderator

Re: Failure to start SQL* Plus - "TNS could not resolve service name" [message #13334 is a reply to message #13281]

Thu, 08 July 2004 00:23

Soham
Messages: 29
Registered: June 2004
Location: Mumbai

Junior Member

hi!
"TNS could not resolve service name" error indiacate tht u r not getting connected to the database.
all the information about which databases and instances and schemas is stored into the tnsnames.ora file in ORACLE_HOMEnetworkadmin.
goto the file and open it into the notepad u can see the databases name like
Example1.world
its address hostid, portid etc
check whether it is right or not.
same thing u can do through sql net easy configuration.
check host id
use same name of database into host string when sql ask for the host string

Report message to a moderator

Previous Topic:	ORA-12571 TNS PACKET FAILURE
Next Topic:	Remote DB access problems accross the WAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 28 14:59:15 CDT 2025