Re: urgent: production database hangs on mount stage and won't open

"chao_ping" <chao_ping_at_163.com> wrote in message news:3d1021e5$1_at_usenetgateway.com...
> 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.
>

First point. 17 Instances on one box is a bit ambitous. (see thread above).

Second Point. Depending what was happening in your Instance, "shutdown immediate" may need an hour or greater to take effect. There may have been a large DML statement without a commit running.

Third point. It is sometimes good practice to issue the command "alter system checkpoint" *before* the
 "shutdown immediate" command. This would explicity trigger a checkpoint thus applying any information in the online-redo logs to the instance's datafiles.

Forth point. What are the contents of the alert.log?

My suggestion at this time is patience, give the instance some time( more than an hour) let the system try to recover by itself.

George Barbour. Received on Wed Jun 19 2002 - 07:18:23 CDT