RE: Oracle 817 freezing

 
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@xxxxxxxxxx

: POWERING TRANSFORMATION 

 

________________________________

From: GovindanK [mailto:gkatteri@xxxxxxxxxxx] 
Sent: Monday, January 22, 2007 2:49 PM
To: Richard J. Goulet; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx> 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@xxxxxxxxxx

GIF image

Other related posts: