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

Hi,

As Charlie said Oracle may be recovering a _BIG_ uncommitted transaction.

Also,

have you got huge redo logs ? If so, Oracle may be rolling forward comitted transactions too.

In both cases, I recommend:

• Use parallel recovery
• Tune IO subsystem before recovery

Note that recovery process is disk instensive process, not CPU intensive.

regards...

Charlie Mengler wrote:

> 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: chal_ping
> > INET: chaospku_at_163.net
> >
> > 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).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct.
> 858-831-2229 San Diego, CA 92131
> There are no stupid questions, but there are many inquisitive idiots!
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: charliem_at_mwh.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).

--
Danisment Gazi Unal
http://www.ubTools.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal (ubTools)
  INET: dunal_at_ubTools.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).