Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle 817 freezing

RE: Oracle 817 freezing

From: Richard J. Goulet <rgoulet_at_kanbay.com>
Date: Mon, 22 Jan 2007 14:52:36 -0500
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D515676@miaexc01.kanbay.com>

 

nope.   

Dick Goulet, Senior Oracle DBA

45 Bartlett St Marlborough, Ma 01752, USA Tel.: 598.573.1978 |Fax: 508.229.2019 | Cell:508.742.5795

RGoulet_at_kanbay.com

: POWERING TRANSFORMATION  


From: GovindanK [mailto:gkatteri_at_fastmail.fm] Sent: Monday, January 22, 2007 2:49 PM
To: Richard J. Goulet; oracle-l_at_freelists.org Subject: Re: Oracle 817 freezing

Is there any Standby to this setup?

On Mon, 22 Jan 2007 14:25:05 -0500, "Richard J. Goulet"
<rgoulet_at_kanbay.com> said:

        Has anyone seen the following condition in 8.1.7 on Solaris 9, all 64 bit:          

  1. The database appears to be frozen. New connections do not reject, but don't come back to the client either.
  2. Dedicated server processes amount to ~ 150 sessions where the db process and sessions limits are up around 400
  3. Database will not shutdown immediate even after half an hour of waiting. Must use shutdown abort.
  4. Cannot see what v$lock contains. Connection as sysdba comes back to a command prompt, but about the only thing you can do is abort the instance.
  5. Memory(vmstat) appears normal, cpu loading is low and idle is high.
  6. Sar does not indicate any disks being hit for anything. Io appears to be non existent.
  7. Alert log does not contain anything outside of the normal redo switching activity. No user dump files either.

        Dick Goulet, Senior Oracle DBA

	45 Bartlett St  Marlborough, Ma 01752, USA
	Tel.: 598.573.1978 |Fax:  508.229.2019 | Cell:508.742.5795

	RGoulet_at_kanbay.com
	




--
http://www.freelists.org/webpage/oracle-l


klogo.gif
Received on Mon Jan 22 2007 - 13:52:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US