Re: Shutdown of one instance takes about 1hr

Alexander Skwar wrote:
> Hello!
>
> Each night, we shutdown the Oracle 9.2.0.4.0 databases on our
> Solaris 9 host. I now noticed, that it takes about 1 hour for
> a certain instance to shutdown:
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jan 31 02:55:56 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> Connected.
> SQL> ORA-01013: user requested cancel of current operation
> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> JServer Release 9.2.0.4.0 - Production
> Database "RACEREF1" shut down.
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jan 31 03:57:44 2007
>
> To shutdown, I use the Oracle supplied dbshut script, which simply
> does a "shutdown" after having connected with "connect / as sysdba".
> Obviously, I don't run those commands manually, but have a cron
> job setup, which runs dbshut and 15 seconds after it finishes, it
> runs dbshut again. Actually, it does:
>
> su - oracle -c "ORACLE_HOME=$ORACLE_HOME $ORACLE_HOME/bin/lsnrctl stop
> ORACLE_HOME=$ORACLE_HOME $ORACLE_HOME/bin/dbshut"
>
> Anyway, when it shuts down the databases for the 2nd time, it again
> takes about 1 hour to do the shutdown.
>
> But is the shutdown actually successful? I wonder because of the
> message
>
> ORA-01013: user requested cancel of current operation
>
> Further, when I startup the databases again, I see this in the logs:
>
> SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
> JServer Release 9.2.0.4.0 - Production
>
> Database "RACEP1" warm started.
> Database "RACEREF1" already started.
>
> Database "RACEREF1" possibly left running when system went down (system crash?).
> Notify Database Administrator.
>
> SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jan 31 05:00:58 2007
>
> The system did not go down. At noon today, I manually shutdown the
> database, and that was very fast (a few seconds). It also came up just
> fine (ie. no message).
>
> What's happening there?
>
> Alexander Skwar

I may be totally off-base here but I notice the names all start with RAC. If this is a RAC cluster you should not be shutting it down with SQL*Plus.

Also, seriously consider, patching to the latest 9.2 patchset. You are quite a ways behind that and desupport begins in a few short months.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org