RE: 9.2.0.4 listener problems
- From: "Thomas Jeff" <jeff.thomas@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 3 Feb 2005 08:20:54 -0500
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
--------------------------------------------
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: