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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Jeff
Sent: Wednesday, February 02, 2005 6:27 PM
To: oracle-l@xxxxxxxxxxxxx
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.

--------------------------------------------
Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.

Email: jeff.thomas@xxxxxxxxxxx

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-l

Other related posts: