Re: V2 listener hangs on NCR System 3000

From: Pratul.Sharma <appy_at_churchill.ColumbiaSC.NCR.COM>
Date: 1995/06/09
Message-ID: <D9x1nv.Lo7_at_ncrcae.ColumbiaSC.ATTGIS.COM>#1/1


In article <3r2g9c$o35_at_ixnews2.ix.netcom.com> vgeshel_at_ix.netcom.com (Vadim Geshel) writes:

Hi,

I was supporting Oracle 7.1.3, and am supporting Oracle 7.1.4.1.1 instances on two different different NCR (Now AT&T GIS) platforms, and using both SQLNET V1 and V2. I did face the problem you that you described, with SQLNET V1, but never with V2. As a matter of fact I have *never* had to restart sqlnet V2, but V1 a couple of times a day. According to Oracle Support this is a known problem (with V1) and there is nothing much you can do about it. I have a cron job that checks the sqlnet every 15 minutes, if it find it hanging it kills the old process and starts another one.

Hope it helps,

Pratul Sharma

P.S: My views only.....
>I'm running Oracle 7.1.3.2.1 on a NCR System 3000 (a 4-Pentium SMP
>system) under NCR UNIX 4.0MP (SVR4.2). The V2 listener is set up to
>serve 2 instances and supports 1 protocol - TCP. The problem is that
>the listener hangs approximately every day - it eventually just stops
>accepting connections, including a control connection from LSNRCTL, and
>I have to kill it and restart it.
>
>Has anybody else seen this? And if so, is there a fix/workaround?
>(Stopping and starting the listener every once in a while reduces the
>frequency of hangs, but they still happen occassionaly. Besides, I
>don't like this kind of a solution...) Also, if this is a known
>problem, does it happen on other Unix flavors, especially SVR4.2
>derivatives, and with other versions of Oracle (the one I'm
>specifically interested in is the WG2000 server for UnixWare -
>7.1.5.2.0)?

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Pratul Sharma (803)-939-6835 E-Mail: appy_at_Churchill.ColumbiaSC.ATTGIS.COM
3325 Platt Springs Rd Cola SC 29170       ***    ------ ?????? ------   ***
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Received on Fri Jun 09 1995 - 00:00:00 CEST

Original text of this message