Home » RDBMS Server » Server Administration » 10.1.0.4 listener spawns a child listener and DB is hung (10.1.0.4 on Solaris)
10.1.0.4 listener spawns a child listener and DB is hung [message #394890] Mon, 30 March 2009 13:26 Go to next message
Orna
Messages: 62
Registered: November 2008
Member
Hi

Last week we had a problem with the listener on one of our 10.1.0.4 databases.
the TNS connections were timing out, and no one was able to connect ( unless as a local connection from the DB server ).

When I did ps -ef | grep -i listener I saw TWO listener processes with the same name , one is spawned by the other.
The only way to solve this was to kill -9 the new listener process

Is this a normal behavior for the listener to spawn another listener process ? and if saw - why did it cause all connections to hung ?
Any known bug regarding this ?

I did find a couple of reports of this behavior in 10. but no followup

http://dbaforums.org/oracle/index.php?showtopic=991

http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-l/spawns-new-rogue-listener-with-same-name-as-original-644065


Thanks in advance for any explanation
Orna
Re: 10.1.0.4 listener spawns a child listener and DB is hung [message #394893 is a reply to message #394890] Mon, 30 March 2009 13:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is not normal.
Did you find anything in logs?
Re: 10.1.0.4 listener spawns a child listener and DB is hung [message #394895 is a reply to message #394893] Mon, 30 March 2009 13:39 Go to previous messageGo to next message
Orna
Messages: 62
Registered: November 2008
Member
Nop,

the second the child process was started ( 23:02:20 ) the listener.log stopped being written to. The last entry was an innocent Java connection , nothing special that I can see.

the next entry in the log is 45 minutes later , once we killed the child process.

Orna
Re: 10.1.0.4 listener spawns a child listener and DB is hung [message #394899 is a reply to message #394893] Mon, 30 March 2009 14:19 Go to previous message
Orna
Messages: 62
Registered: November 2008
Member
ok,After some Metalink browsing I stumble upon doc id :284602.1
That is talking about this problem.

My DB is not a RAC DB. HOWEVER - the Oracle software used to be RAC binary that I relinked to non RAC.
But the $ORACLE_HOME/opmn/conf/ons.config file was still there.
I removed the file and I hope that will not happen again

thanks
Orna
Previous Topic: ORA-12571: TNS:packet writer failure
Next Topic: Password file
Goto Forum:
  


Current Time: Fri Dec 09 04:25:15 CST 2016

Total time taken to generate the page: 0.04993 seconds