Re: orasrv hangs for no apparent reason

From: John Verhoeven <johnv_at_acix.DIALix.oz.au>
Date: 1996/09/28
Message-ID: <johnv.0a4h_at_acix.DIALix.oz.au>#1/1


In article dated 25 Sep 1996 15:50:56 GMT, Stephen G. Roseman (lusgr_at_chili.CC.Lehigh.EDU) wrote:
> Environment: AIX 4.1.4, Oracle 7.1.6.2.0, SQL*Net v1.
>
> Problem: About once a week, orasrv stops accepting connections and goes into a
> CPU loop. We need to kill the process and restart orasrv.

I haven't run into this specific problem but to fix problems with dead processes etc, I created a script to kill the orasrv process and any child processes of it each night before restarting it.

> (I know - update to SQL*Net v2. Maybe soon...)

Under way .. so we can play with some of the newer toys like Oracle 7.3.

--
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."
Received on Sat Sep 28 1996 - 00:00:00 CEST

Original text of this message