OraFAQ Forum: Networking and Gateways » ORA-12514: TNS:listener could not resolve SERVICE

Home » RDBMS Server » Networking and Gateways » ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

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

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor [message #11024]

Mon, 01 March 2004 09:46

vincent
Messages: 18
Registered: November 1998

Junior Member

�

I might be giving service_name wrong.....

I installed oracle 9i on my system where client and server are there on same system

i would like to know , how to find out what service name is there in my system and how to find out the service_name

Thanks

Vincent

Report message to a moderator

Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor [message #11026 is a reply to message #11024]

Mon, 01 March 2004 19:07

Harish Kumar
Messages: 4
Registered: March 2004

Junior Member

Open TSNNAMES.ORA file , there you will find the service name. This file resides in oracleora81networkADMIN .

Report message to a moderator

Re: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor [message #11027 is a reply to message #11024]

Mon, 01 March 2004 19:11

Nirene
Messages: 22
Registered: February 2004

Junior Member

First of all there is no need to have client installed in the server.

Secondly to get your service name search for TNSNAMES.ORA file open that in Notepad and look for SID,which is your Server Identifier.

Third give the correcct Username and Password to get connected.

Report message to a moderator

Previous Topic:	LDAP
Next Topic:	creating Database link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 10:46:08 CST 2024