Re: production database on aix won't be open, help

Sorry, but does Oracle not do the rollback in the background, reading records from undo$. This is a feature called fast warmstart, introduced with 8.0. During an instance recovery, a roll forward is done, and the database opened for normal operations. A rollback is done in the background.

Raj

                                                                                                                    
                    "Charlie                                                                                        
                    Mengler"             To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>        
                    <charliem_at_mwh        cc:                                                                        
                    .com>                Subject:     Re: production database on aix won't be open, help            
                    Sent by:                                                                                        
                    root_at_fatcity.                                                                                   
                    com                                                                                             
                                                                                                                    
                                                                                                                    
                    June 19, 2002                                                                                   
                    01:28 PM                                                                                        
                    Please                                                                                          
                    respond to                                                                                      
                    ORACLE-L                                                                                        
                                                                                                                    
                                                                                                                    

It might be that Oracle is simply trying to rollback a _BIG_ uncommitted transaction.
Once in the past I had a similar problem. The fix was amazingly simple. I increased
the size of the TEMP tablespace. I suspect that if you are really, really, really
patient Oracle eventually will wake from its slumber & begin normal operations.

HTH & YMMV, HAND! chal_ping wrote:
>
> oracle-lHi, grurus:
> This is a production database 8.1.7.2 on aix 4.3.3, there are 17
instances running on the same box.
> I shutdown immediate the database and it hangs.After wait for one
hour, i do a shutdown abort. When i startup again, it failed to open the database , just hangs at this stage like:
> Sun Jun 16 09:36:40 2002
> SMON: enabling cache recovery
> SMON: enabling tx recovery
> And the sql*plus window hangs at : database mounted, but never
showed open.
> From another shell prompt, i sqlplus internal and query the
instance, it showed instance open in read write state!
> But from remote node via listener, client process showed 0134:
oracle not available.
> I once met such kind of questions on sun solaris, it is because
of solaris bug.But never heard of this kind on AIX. Oracle support suggest reboot the server, but as there is 16 other instance on it, it is not the solution.
> Can anyone help?
> Great thanks.
>
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).