my guess is that the instance is rolling back transactions which, were
interupted
when u shutdown the db.
> ----------
> From: chal_ping[SMTP:chaospku_at_163.net]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, June 19, 2002 2:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: urgent: production database won't be opened
>
> Hi, 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.
>
>
>
>
>
>
>
> chaospku_at_163.net
>
> --
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rahul
INET: rahul_at_ratelindo.co.id
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 - 04:03:20 CDT
