Home » RDBMS Server » Networking and Gateways » Listner stoped unexpectedly (Oracle 10g)
Listner stoped unexpectedly [message #331559] Fri, 04 July 2008 00:28 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Hi,

On the production server the listener was down automatically. I don't find the reason to down the listner.
There was no problem for listener before on the production.

Please find the listber.log on the production server.
03-JUL-2008 15:31:41 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\WINDOWS\system32\dllhost.exe)(HOST=testgl)(USER=testgl_terminal))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.155)(PORT=2388)) * establish * ora01 * 0
03-JUL-2008 15:31:44 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\WINDOWS\system32\dllhost.exe)(HOST=testgl)(USER=testgl_terminal))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.155)(PORT=2389)) * establish * ora01 * 0
03-JUL-2008 15:31:45 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=c:\windows\system32\inetsrv\w3wp.exe)(HOST=testgl)(USER=IUSR_testgl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.155)(PORT=2390)) * establish * ora01 * 0
03-JUL-2008 15:31:46 * service_update * ora01 * 0
03-JUL-2008 15:31:48 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\WINDOWS\system32\dllhost.exe)(HOST=testgl)(USER=testgl_terminal))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.155)(PORT=2392)) * establish * ora01 * 0

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 03-JUL-2008 16:20:30

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

System parameter file is /home/oracle/product/10gR2/network/admin/listener.ora
Log messages written to /home/oracle/product/10gR2/network/log/listener.log
Trace information written to /home/oracle/product/10gR2/network/trace/listener.trc
Trace level is currently 0

Started with pid=15265
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=machine1.test.net)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
03-JUL-2008 16:20:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=machine11)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0

03-JUL-2008 16:20:30 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\WINDOWS\system32\dllhost.exe)(HOST=testgl)(USER=testgl_terminal))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.155)(PORT=1316)) * establish * ora01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
03-JUL-2008 16:20:34 * ping * 0
WARNING: Subscription for node down event still pending
03-JUL-2008 16:21:05 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=machine11)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
03-JUL-2008 16:21:12 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Documents and Settings\Administrator\Skrivebord\SQL Navigator 4\SQLNav4.exe)(HOST=testuser)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=111.111.111.111)(PORT=31449)) * establish * ora01 * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
03-JUL-2008 16:21:12 * service_register * ora01 * 0
03-JUL-2008 16:21:21 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Documents and Settings\Administrator\Skrivebord\SQL Navigator 4\SQLNav4.exe)(HOST=testuser)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=111.111.111.111)(PORT=31456)) * establish * ora01 * 0
03-JUL-2008 16:21:28 * (CONNECT_DATA=(ORACLE_SID=ora01)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Documents and Settings\Administrator\Skrivebord\SQL Navigator 4\SQLNav4.exe)(HOST=testuser)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=111.111.111.111)(PORT=31457)) * establish * ora01 * 0
03-JUL-2008 16:21:34 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ora01)(CID=(PROGRAM=C:\Program Files\Quest Software\TOAD\TOAD.exe)(HOST=UTPALS)(USER=abhoite))) * (ADDRESS=(PROTOCOL=tcp)(HOST=203.199.150.10)(PORT=58514)) * establish * ora01 * 0
03-JUL-2008 16:21:39 * service_update * ora01 * 0
03-JUL-2008 16:22:00 * (CONNECT_DATA=(SERVICE_NAME=ora01)(CID=(PROGRAM=httpd2-prefork)(HOST=machine11)(USER=wwwrun))) * (ADDRESS=(PROTOCOL=tcp)(HOST=129.142.228.156)(PORT=46442)) * establish * ora01 * 0
03-JUL-2008 16:22:00 * service_update * ora01 * 0
03-JUL-2008 16:22:03 * service_update * ora01 * 0
03-JUL-2008 16:22:07 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=machine11)(USER=oracle))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * services * 0
WARNING: Subscription for node down event still pending



What is reason to down the listener?
Or do i need to look into other part?

Please suggest me.

Thanks,
Re: Listner stoped unexpectedly [message #331561 is a reply to message #331559] Fri, 04 July 2008 00:34 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
More information:

I started listener on 03-JUL-2008 16:20:30.
And from 03-JUL-2008 15:31:48 the listener was not available.

During down time of the listener i was able to connect to oracle on server but not from client end.
I tried to start the listener but it was not getting started i dont know why it was not started.

But after 10 minutes my command works and listner starts.
i.e. lsnrctl start

I posted listener.log file in my previous post during the down time.

Thanks,

[Updated on: Fri, 04 July 2008 01:06]

Report message to a moderator

Re: Listner stoped unexpectedly [message #331599 is a reply to message #331561] Fri, 04 July 2008 03:23 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Quote:
I tried to start the listener but it was not getting started i dont know why it was not started.


When you did a START command from LSNRCTRL, what exactly happened?
Re: Listner stoped unexpectedly [message #331604 is a reply to message #331599] Fri, 04 July 2008 03:53 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks for reply.
Actually i used command,

:=>lsnrctl start

But just the blank screen for more than 5 minuts no error or no reply.
So i terminate the comand with Ctrl+Z and again executed the same command and it works.

Please tell me if any other information is required.

1. Can you judge with listener.log file what was the problem.
2. Any other place to look for the problem?

Thanks,


Re: Listner stoped unexpectedly [message #331627 is a reply to message #331599] Fri, 04 July 2008 04:36 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member
your system is a windows system.
maybe you can lookup "event manager" for more information.
-----
if possible ,you can migrate the database to linux system.
Re: Listner stoped unexpectedly [message #331628 is a reply to message #331559] Fri, 04 July 2008 04:38 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
This is UNIX system not windows Smile
Re: Listner stoped unexpectedly [message #331710 is a reply to message #331628] Fri, 04 July 2008 15:41 Go to previous messageGo to next message
JackyShu
Messages: 25
Registered: May 2008
Junior Member
linux box? why this in log file?

(PROGRAM=C:\WINDOWS\system32\dllhost.exe)
Re: Listner stoped unexpectedly [message #331711 is a reply to message #331710] Fri, 04 July 2008 15:48 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
JackyShu wrote on Fri, 04 July 2008 13:41
linux box? why this in log file?

(PROGRAM=C:\WINDOWS\system32\dllhost.exe)



A Windows client can connect to Linux Oracle DB server.
Re: Listner stoped unexpectedly [message #331712 is a reply to message #331710] Fri, 04 July 2008 15:51 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
JackyShu wrote on Fri, 04 July 2008 22:41
linux box? why this in log file?

(PROGRAM=C:\WINDOWS\system32\dllhost.exe)




Because that is the CLIENT program that connected to the listener. And there might very well be Windows clients using the database.

Two possible reasons for the problem :

- Bug Number 4518443
- Have you changed the IP of the server?
Re: Listner stoped unexpectedly [message #332017 is a reply to message #331711] Mon, 07 July 2008 04:48 Go to previous messageGo to next message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Hi,
What is the size of the listener log file?
Re: Listner stoped unexpectedly [message #332410 is a reply to message #331559] Tue, 08 July 2008 08:21 Go to previous messageGo to next message
malikjee
Messages: 80
Registered: May 2007
Location: lahore
Member

Hi there !

please try to restart all your oracle services ,and startup your database with restrict command .some time a production databases force the bug to be occered ,I strongly hope it will be solution of this problem ,If not it will be faced by you in future and then you will have to tune new port for your listner,or listner for database
Regards,
Malik
Re: Listner stoped unexpectedly [message #332569 is a reply to message #331559] Wed, 09 July 2008 00:45 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks all for your replies.

As a workaround, two steps should be done:

1. The following parameter can be added to listener.ora 

For example, if the listener name is LISTENER (default), the parameter would be: 

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

2. Locate the ons.config file in the 10g(rdbms) home and rename it to something else. 
For example: 
cd $ORACLE_HOME/opmn/conf 
mv ons.config ons.config.orig 

The listener needs to be restarted after these changes. 


If i will follow the previous solution then one question in my mind is that where exactly i can put SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF in listener.ora?


# listener.ora Network Configuration File: E:\oracle\product\10.1.0\db_2\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.1.0\db_2)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = test1.com)(PORT = 1521))
      )
    )
  )


Re: Listener stopped unexpectedly [message #364428 is a reply to message #332569] Mon, 08 December 2008 07:27 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It doesn't matter. I would just append it to the file.
Previous Topic: connection problem with Db or instance
Next Topic: TNS Names not availabe
Goto Forum:
  


Current Time: Thu Apr 18 15:04:57 CDT 2024