Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
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
The weird thing is that every now and then, it clears up momentarily,
and you can
connect and work for a very short window of time, perhaps 1 or 2
minutes, then the
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-lReceived on Wed Feb 02 2005 - 18:29:40 CST