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).
Received on Wed Jun 19 2002 - 12:28:32 CDT
