|
|
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Soham
Messages: 29 Registered: June 2004 Location: Mumbai
|
Junior Member |
![soham_khot](/forum/theme/orafaq/images/yahoo.png)
|
|
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
|
|
|