OraFAQ Forum: Networking and Gateways » ORA-12514 ERROR...TNSPING WORKS

Home » RDBMS Server » Networking and Gateways » ORA-12514 ERROR...TNSPING WORKS

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

ORA-12514 ERROR...TNSPING WORKS [message #66810]

Tue, 21 January 2003 04:17

Vetrivel
Messages: 2
Registered: November 2002

Junior Member

I am facing an Ora-12514 TNS Listener could not resolve the service name given in connect descriptor.

I am trying to connect the database in the remote site. The IP and port of the database are mapped to a local ip in my LAN. When I TNS ping this local ip, it succeeds. But my net8 assistant check to connect the database results in ORA-12514..
Help me in this issue

I have created the tnsnames.ora using net8 configration assistant.

Thanks in advance
Vetrivel

Report message to a moderator

Re: ORA-12514 ERROR...TNSPING WORKS [message #66812 is a reply to message #66810]

Tue, 21 January 2003 06:47

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

are you getting any
ORA-01041: internal error. hostdef extension doesn't exist 
when trying to connect?
sql*net will not do the host name resolution.
Pls post your listener.ora and tnsnames.ora.
carefully look into your listener.ora , even any unwanted space around = will create an error!~

Report message to a moderator

Re: ORA-12514 ERROR.TNSPING WORKS [message #67530 is a reply to message #66810]

Sat, 18 September 2004 07:36

sanjeev sharma
Messages: 2
Registered: June 2003

Junior Member

Hi,

I think i have the solution to your problem.

When you closely look into your tnsnames.ora then there might me two entries for your database that is for two listeners.

Check the services on each of the two listeners by (listener services listener-name) and remove the entry from the tnsnames.ora on which that service is not present.

Sanjeev

Report message to a moderator

Previous Topic:	Oracle 8i Client installation program doesn't start
Next Topic:	can't connect to linux oracle 10g, firewall?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:35:24 CST 2024