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).
Received on Wed Jun 19 2002 - 03:13:23 CDT
