Listner stoped unexpectedly [message #331559] |
Fri, 04 July 2008 00:28 |
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 |
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 |
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 |
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 #331712 is a reply to message #331710] |
Fri, 04 July 2008 15:51 |
ThomasG
Messages: 3212 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 #332569 is a reply to message #331559] |
Wed, 09 July 2008 00:45 |
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))
)
)
)
|
|
|
|