Home » RDBMS Server » Networking and Gateways » listener stopped suddenly (10g RAC ,solaris)
listener stopped suddenly [message #395996] Fri, 03 April 2009 08:11 Go to next message
knight
Messages: 111
Registered: January 2009
Senior Member
10g RAC two node setup on solaris.

listener suddenly went down today ( on both nodes ).
I could only find foll. messages logged in listener.log


03-APR-2009 14:13:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=server-02)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
03-APR-2009 14:13:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(server=dedicated)(service_name=prod)(failover_mode=(type=select)(method=basic))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.160.12.12)(PORT=44830)) * establish * PROD * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
.
.
.
.



Currently tracing is not enabled for listener.
Is there any way that the cause for this can be detected.



Also the foll. messages are in alert log

ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='PROD1';Fri Apr 3 14:08:43 2009
Immediate Kill Session#: 3732, Serial#: 7794


was this statement fired implicitly by oracle server ??
or by user??
Re: listener stopped suddenly [message #396003 is a reply to message #395996] Fri, 03 April 2009 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
By a user.

Regards
Michel
Re: listener stopped suddenly [message #396008 is a reply to message #395996] Fri, 03 April 2009 09:25 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
!!!!some 1 is messing things,,,,

but is this query the cause for listener going down??

instances were up. only listener went down.
Re: listener stopped suddenly [message #396013 is a reply to message #395996] Fri, 03 April 2009 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The listener is an external process & not a session within the RDBMS.

The listener can not, will not make log entries when it is down.

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: listener stopped suddenly [message #396018 is a reply to message #396008] Fri, 03 April 2009 09:32 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Also; You may need to check your OS log.

ps: /var/adm/message entries.

Babu
Re: listener stopped suddenly [message #396043 is a reply to message #396008] Fri, 03 April 2009 10:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
knight wrote on Fri, 03 April 2009 16:25
!!!!some 1 is messing things,,,,

but is this query the cause for listener going down??

instances were up. only listener went down.

It explains the message:
Quote:
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

Regards
Michel

Re: listener stopped suddenly [message #396379 is a reply to message #395996] Mon, 06 April 2009 06:55 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
Thanx
the os logs at /var/adm/message show NIC failure

RCA detected.
Re: listener stopped suddenly [message #396395 is a reply to message #396379] Mon, 06 April 2009 07:49 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Thanks for the feedback.

If you post complete error message. This is help us in feature/analyze.

Babu
Previous Topic: Listener intermittently drops
Next Topic: Weird internet connection
Goto Forum:
  


Current Time: Tue Mar 19 06:03:35 CDT 2024