Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown of one instance takes about 1hr

Re: Shutdown of one instance takes about 1hr

From: gazzag <gareth_at_jamms.org>
Date: 2 Feb 2007 09:20:37 -0800
Message-ID: <1170436837.891390.171020@l53g2000cwa.googlegroups.com>


On 31 Jan, 13:08, Alexander Skwar <alexan..._at_skwar.name> 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

To my knowledge, Oracle recommends that the dbstart and dbshut scripts are only used by the system boot procedure. As a matter of interest, why do you need to shut the database every night? Received on Fri Feb 02 2007 - 11:20:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US