DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=H5YSjT6lf9LPFfTSyWGtEOPoLiv43IPeUcoo0US+/OITutYdJSPz93Y1Mhsn4Dz/GcFrByNEjXtRwoUJHpaQPZPowOnTJy4qwrslqkO2Gcl36ti6LLRADsYBmTlIfxVMHOwFpz9IVtLlr//GSiP3NJMBtfiRSCGZXVr9wNS0XZs=
Message-ID: <ad3aa4c90709141133w7478d347t1efa5452ae36dce@mail.gmail.com>
Date: Fri, 14 Sep 2007 13:33:23 -0500
From: "Andrew Kerber" <andrew.kerber@gmail.com>
To: don@seiler.us
Subject: Re: Weird database hanging
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <716f7a630709141119p6b28d084h1ee33adec81944ca@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_4548_31702227.1189794804133"
References: <716f7a630709141119p6b28d084h1ee33adec81944ca@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: andrew.kerber@gmail.com
------=_Part_4548_31702227.1189794804133
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Do you have a record of memory availability on the box?  I have seen this
type of error when there was no free memory on the server.

On 9/14/07, Don Seiler <don@seiler.us> wrote:
>
> Running 10gR2 (10.2.0.2) on RHEL4 on 4 64-bit dual-core box.  Earlier
> today users complained en masse about not being able to connect to the
> database.  I got to a term and found that even trying to log in
> locally as sysdba was hanging.
>
> The alert log had this:
> Fri Sep 14 11:23:36 2007
> kkjcre1p: unable to spawn jobq slave process
> Fri Sep 14 11:23:36 2007
> Errors in file /u00/app/oracle/admin/foo/bdump/foo_cjq0_11519.trc:
> Fri Sep 14 11:25:46 2007
> kkjcre1p: unable to spawn jobq slave process
> Fri Sep 14 11:25:46 2007
> Errors in file /u00/app/oracle/admin/foo/bdump/foo_cjq0_11519.trc:
> Fri Sep 14 11:26:49 2007
> PMON failed to acquire latch, see PMON dump
>
> I hit the Google but before I came back, my login was ready and things
> seemed back to normal.  Checking back in the alert log I saw a lot of
> these:
>
> WARNING: inbound connection timed out (ORA-3136)
>
> I'm assuming those are just symptoms of the original cause, and I've
> already found suggestions for treating timeouts in sqlnet.ora and
> listener.ora.
>
> The trace files mentioned have lines such as:
>
> Waited for process J000 to initialize for 60 seconds
>
> repeated for 70, 80, 90 seconds, etc.
>
> So in summary, there was hanging for everyone, it seemed to clear
> itself up.  One post on Google suggested that the PROCESSES init
> parameter might be too low.  Any other possibilities?
>
> --
> Don Seiler
> oracle: http://ora.seiler.us
> ultimate: http://www.mufc.us
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

------=_Part_4548_31702227.1189794804133
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Do you have a record of memory availability on the box?&nbsp; I have seen this type of error when there was no free memory on the server.<br><br><div><span class="gmail_quote">On 9/14/07, <b class="gmail_sendername">Don Seiler</b>
 &lt;<a href="mailto:don@seiler.us">don@seiler.us</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Running 10gR2 (<a href="http://10.2.0.2">
10.2.0.2</a>) on RHEL4 on 4 64-bit dual-core box.&nbsp;&nbsp;Earlier<br>today users complained en masse about not being able to connect to the<br>database.&nbsp;&nbsp;I got to a term and found that even trying to log in<br>locally as sysdba was hanging.
<br><br>The alert log had this:<br>Fri Sep 14 11:23:36 2007<br>kkjcre1p: unable to spawn jobq slave process<br>Fri Sep 14 11:23:36 2007<br>Errors in file /u00/app/oracle/admin/foo/bdump/foo_cjq0_11519.trc:<br>Fri Sep 14 11:25:46 2007
<br>kkjcre1p: unable to spawn jobq slave process<br>Fri Sep 14 11:25:46 2007<br>Errors in file /u00/app/oracle/admin/foo/bdump/foo_cjq0_11519.trc:<br>Fri Sep 14 11:26:49 2007<br>PMON failed to acquire latch, see PMON dump
<br><br>I hit the Google but before I came back, my login was ready and things<br>seemed back to normal.&nbsp;&nbsp;Checking back in the alert log I saw a lot of<br>these:<br><br>WARNING: inbound connection timed out (ORA-3136)<br>
<br>I&#39;m assuming those are just symptoms of the original cause, and I&#39;ve<br>already found suggestions for treating timeouts in sqlnet.ora and<br>listener.ora.<br><br>The trace files mentioned have lines such as:<br>
<br>Waited for process J000 to initialize for 60 seconds<br><br>repeated for 70, 80, 90 seconds, etc.<br><br>So in summary, there was hanging for everyone, it seemed to clear<br>itself up.&nbsp;&nbsp;One post on Google suggested that the PROCESSES init
<br>parameter might be too low.&nbsp;&nbsp;Any other possibilities?<br><br>--<br>Don Seiler<br>oracle: <a href="http://ora.seiler.us">http://ora.seiler.us</a><br>ultimate: <a href="http://www.mufc.us">http://www.mufc.us</a><br>--<br>
<a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br><br clear="all"><br>-- <br>Andrew W. Kerber<br><br>&#39;If at first you dont succeed, dont take up skydiving.&#39;

------=_Part_4548_31702227.1189794804133--
--
http://www.freelists.org/webpage/oracle-l