Re: 9.2.0.4 listener problems

Jeff,

Just a wild guess, but are you having any DNS issues? (domain name changes, DHCP server going bonkers, collisions with respect to another host grabbing that same IP address, etc.)

(Ok, this is just typical me wanting to blame Network Operations instead of wanting it to be an Oracle problem that I have to work an iTAR for ...)

Paul

On Wed, 2 Feb 2005 18:27:01 -0500, Thomas Jeff <jeff.thomas_at_thomson.net> wrote:
> 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_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-l