my guess is that the instance is rolling back transactions which, were interupted when u shutdown the db.
> ---------- > From: chal_ping[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > 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. > > > > > > > > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: chal_ping > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
