Re: Oracle Shutdown Fails

If the Oracle database did not shutdown with shutdown immediate then stopping those Oracle NT services is the same as crashing your database, i.e. database recovery will occur next time you start it up. This is not normally a big deal, but you could run into problems if you are doing this prior to a cold backup and need to restore from it later.

hstack_at_att.com wrote:

> Jean Wimmerlin wrote in message <6mae78$lb2$1_at_ubnnews.unisource.ch>...
> >When we give "SHUTDOWN IMMEDIATE", Oracle cancels all active transactions,
> >rollback and shutdown the database instance. But, sometime (not all the
> >time) it hangs and logs the following in the alert file : "Shutdown :
> >waiting for logins to complete". I have a backup script that shutdowns the
> >instance with immediate option:
> >ORADIM73 -SHUTDOWN -SID DMS -USRPWD ****** -SHUTTYPE SRVC, INST - SHUTMODE
> >i -PFILE D:\ORANT\DATABASE\DMS\INITDMS.ORA
> >
> >Does anybody have a clue what is wrong with doing so ?
> >
> >We are using Oracle Server 7.3.3.0.0 on Windows NT 4.0
> >
> >Thanks in advance,
> >
> >Jean Wimmerlin
> >
> >
>
> Jean,
>
> I wrote the following to do the same on ours and we have the same system. Nt
> 4.0 server Oracle 7.3.3. The problem could be with the NT services running
> so try to shutdown these first. See my example. I back up to another disk
> on the same machine then after its done write those files to tape. It takes
> less time and my db is not down as long.
>
> Hope it helps.
> Help me sometime...we are all in oracle hell
> hstack_at_att.com
>
> rem the following runs a script(shutdown.sql) to shutdown oracle
> E:\orant\bin\svrmgr23 @E:\orant\admin\shutdown.sql
> echo just finished shutdown.sql
>
> net stop OracleServiceORCL /y
> net stop OracleTNSListener /y
> echo oracle shut down
> del e:\orant\admin\backorcl.log
>
> echo Backup oracle, E: to F: > E:\orant\admin\backorcl.log
> echo Time Started >> E:\orant\admin\backorcl.log
> date /t >> E:\orant\admin\backorcl.log
> time /t >> E:\orant\admin\backorcl.log
>
> copy e:\orant\database\. f:\orant\backup 1>> E:\orant\admin\backorcl.log
>
> echo Time Completed >> E:\orant\admin\backorcl.log
> date /t >> E:\orant\admin\backorcl.log
> time /t >> E:\orant\admin\backorcl.log
>
> rem=================================================================
> rem the following runs a script(startup.sql) to start oracle
>
> net start OracleServiceORCL
> E:\orant\bin\svrmgr23 @E:\orant\admin\startup.sql
> net start OracleStartORCL
> net start OracleTNSListener
>
> Shutdown.sql is as follows
>
> connect internal
> shutdown immediate
> exit;
>
> Startup.sql is as follows:
>
> connect internal
> startup pfile=e:\orant\database\initorcl.ora
> exit;
Received on Mon Jun 29 1998 - 19:53:29 CDT