Home » RDBMS Server » Networking and Gateways » ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect [message #188093] Thu, 17 August 2006 01:57 Go to next message
suneevas
Messages: 1
Registered: August 2006
Location: kerala
Junior Member
Hi every one,

i set up my database and when i am trying to connect to sql i am getting the message "ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor"... i added tns names in tnsnames.ora file and sqlnet.ora file is also correct.
can any one suggest me how to proceed

Thanks in advance
sumathi
Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect [message #188125 is a reply to message #188093] Thu, 17 August 2006 03:52 Go to previous message
SanthoshKumar_s
Messages: 28
Registered: March 2005
Location: Hyderabad
Junior Member

Hi,

Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable.

Thanks,
Previous Topic: How to limit the listener port that client can connect through tnsnames.ora?
Next Topic: Msg in listener.log
Goto Forum:
  


Current Time: Tue Dec 06 04:51:04 CST 2016

Total time taken to generate the page: 0.13556 seconds