OraFAQ Forum: Server Administration » Listener Failure - Strange Problem

Home » RDBMS Server » Server Administration » Listener Failure - Strange Problem - Need Help

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

Listener Failure - Strange Problem - Need Help [message #144330]

Wed, 26 October 2005 01:23

kvjai
Messages: 6
Registered: October 2005
Location: Chennai

Junior Member

Hi guys,

Error Mesg: ora-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Few Days Back due to power failure Server got shutdown Abnormally. After that Listener Error Mesg was coming.

Activities Done...
1. Listener was deleted and Reconfigured.
2. Checked the status of Listener using LSNRCTL Command(Start / Stop / Status )
3. Added the DB entries to listener.ora.
4. Listener Service for DB was started and working fine.

Still was not able to connect to DB,

1. Tried to Connect to DB thru EM, but failed. Used logins like System,<User - DBA Privilege>,scott,<Normal User>. But did not connect to Database
2. When used sysdba login in EM got connected to DB and after that everything is working fine.

Meanwhile restarted the server several times.

Still confused and want to know the reason...
What was the problem ?
How it suddenly started working ?
Why got connected to db when SYS Login used ? while other logins failed ?

Please help

Regards

Vijai K

Report message to a moderator

Re: Listener Failure - Strange Problem - Need Help [message #144392 is a reply to message #144330]

Wed, 26 October 2005 06:19

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

Senior Member
Account Moderator

Did you also add proper entries to tnsnames.ora?
Every client has it own version of tnsnames.ora

Report message to a moderator

Re: Listener Failure - Strange Problem - Need Help [message #144523 is a reply to message #144330]

Wed, 26 October 2005 20:52

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

Also check the complete entries in the tnsnames.ora sometiomes an extra ( can mess up things

Report message to a moderator

Re: Listener Failure - Strange Problem - Need Help [message #146559 is a reply to message #144523]

Fri, 11 November 2005 01:22

kvjai
Messages: 6
Registered: October 2005
Location: Chennai

Junior Member

hi,

have done that, but does not seem to help, Any suggestion

Thanks and Regards

Vijai K

Report message to a moderator

Re: Listener Failure - Strange Problem - Need Help [message #146599 is a reply to message #146559]

Fri, 11 November 2005 06:52

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

kvjai AS per your case--->
Some time in place of SERVICE_NAME (which is in bold in below written example) must be replaced by SID in tnsnames.ora.

e.g
==================================
CLONE.HCLT-GUINDY.CO.IN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hdchbscg)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = clone)
)
)
==================================

Regards
Always Friend sunilkumar

Report message to a moderator