| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9.2.0.4 listener problems
To add to this. We shut down the 9i listener and fired up a 10g
listener. The same
problems persist. What happens is that it's fine for about 5 minutes
(with the 10g
listener) then the tnsping times drop off the table, and the slowdowns
resume. It
looks like some sort of load/resource contention issue.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Jeff
Sent: Wednesday, February 02, 2005 6:27 PM
To: oracle-l_at_freelists.org
Subject: 9.2.0.4 listener problems
We are having a mysterious listener issue that suddenly cropped up at
roughly
4:00am today on our AIX 5.2.0.4, Oracle 9.2.0.4 test box. Everything
hangs,
sql*plus, tnsping, etc. We've checked it all, config files,
hardware,
network, etc, and cannot find a culprit. The box has been bounced to
no
avail. It can take anywhere from 30 seconds (if you are lucky) to
minutes=20
to infinity to get connected.
If we trace, the trace shows it hanging at this point:
[02-FEB-2005 18:11:11:665] nsnainit: inf->nsinfflg[0]: 0x41
inf->nsinfflg[1]: 0x41
[02-FEB-2005 18:11:11:665] nsopen: global context check-in (to slot 0)
complete [02-FEB-2005 18:11:11:665] nscon: doing connect handshake...
[02-FEB-2005 18:11:11:665] nscon: sending NSPTCN packet =20
The weird thing is that every now and then, it clears up momentarily,
and you can=20
connect and work for a very short window of time, perhaps 1 or 2
minutes, then the=20
hang/slowdowns resume.
This has our whole SA/DBA team flummoxed.
Oracle Support has been scratching their heads on this.
Email: jeff.thomas_at_thomson.net
Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 03 2005 - 08:23:47 CST
 |
 |