Home » RDBMS Server » Networking and Gateways » Listener Hanged...........
Listener Hanged........... [message #172513] Wed, 17 May 2006 00:56 Go to next message
hafeezs
Messages: 8
Registered: May 2006
Location: islamabad
Junior Member
Hello Friends

I have a very intreasting problem with my Oracle Listener.Please help me to resolve it.

I tried to get the staus of listener but got hanged, i tried to connect sql it got hanged, i tried to stop and start the listener it got hanged.........

i have Oracle 10g rel 2 on Solaris 9.

i resolved the problem by following way.......but i want to know what was the problem and why it occured........

root@oracle-srv # ps -ef | grep lsnr
oracle 1811 1 0 Apr 12 ? 74:55 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit
oracle 4038 4037 0 09:26:35 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
oracle 3936 3929 0 09:20:53 pts/2 0:00 sh -c /u01/product/oracle/dbase10g/bin/lsnrctl > /tmp/1MRYhYrWSi
root 4452 4296 0 09:44:05 pts/3 0:00 grep lsnr
oracle 3937 3936 0 09:20:53 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
oracle 2851 1811 0 05:53:51 ? 0:00 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit
oracle 4037 4030 0 09:26:35 pts/2 0:00 sh -c /u01/product/oracle/dbase10g/bin/lsnrctl > /tmp/k8E7u2N13B

root@oracle-srv # kill -9 4037

root@oracle-srv # ps -ef | grep lsnr
oracle 1811 1 0 Apr 12 ? 74:55 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit
oracle 4038 1 0 09:26:35 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
oracle 3936 3929 0 09:20:53 pts/2 0:00 sh -c /u01/product/oracle/dbase10g/bin/lsnrctl > /tmp/1MRYhYrWSi
oracle 3937 3936 0 09:20:53 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
root 4466 4296 0 09:44:28 pts/3 0:00 grep lsnr
oracle 2851 1811 0 05:53:51 ? 0:00 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit

root@oracle-srv # ps -ef | grep lsnr
oracle 1811 1 0 Apr 12 ? 74:55 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit
oracle 4038 1 0 09:26:35 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
oracle 3936 3929 0 09:20:53 pts/2 0:00 sh -c /u01/product/oracle/dbase10g/bin/lsnrctl > /tmp/1MRYhYrWSi
oracle 3937 3936 0 09:20:53 pts/2 0:00 /u01/product/oracle/dbase10g/bin/lsnrctl
root 4479 4296 0 09:44:42 pts/3 0:00 grep lsnr
oracle 2851 1811 0 05:53:51 ? 0:00 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit

root@oracle-srv # kill 2851
root@oracle-srv # kill 2851
bash: kill: (2851) - No such pid
root@oracle-srv # ps -ef | grep lsnr
oracle 1811 1 1 Apr 12 ? 74:56 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit
oracle 4976 1811 0 09:45:43 ? 0:00 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit

root@oracle-srv # kill 4976
bash: kill: (4976) - No such pid
root@oracle-srv # ps -ef | grep lsnr
oracle 1811 1 2 Apr 12 ? 74:57 /u01/product/oracle/dbase10g/bin/tnslsnr listener -inherit

Please help me so that i can avoid this problem in future.

i shall be thankfull for any assistance..

Regards
Hafeez

Report message to a moderator

Re: Listener Hanged........... [message #173022 is a reply to message #172513] Fri, 19 May 2006 00:48 Go to previous message
hafeezs
Messages: 8
Registered: May 2006
Location: islamabad
Junior Member
I have resolve this problem as follow.

This is bug in Oracle 10g rel 1 and 2 which has been resolved in rel 3.

the bug # is 4518443

u can get help on this bug from metalink
or contact me
mh_fiji@hotmail.com

Regards
Hafeez

Report message to a moderator

Previous Topic: Application Connection Error
Next Topic: Oracle Transparent Gateway.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 06:07:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.