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