Re: Database shutdown on NT

How about using a cmd file that uses ORADIM73 to shutdown the database. You should have one in the
X:\ORANT\DATABASE directory. This file is created when installing the database or creating a new instance.

For example, an entry in shutORCL.cmd file would be: d:\orant\bin\oradim73.exe -shutdown -sid ORCL -shuttype srvc,inst -shutmode n

For more information have a look at the Oracle7 users guide for Windows NT.

Regards

Hassan Abba
Oracle Developer/DBA

Andy Hardy wrote:

> Hi,
>
> I recently had to call Oracle support regarding an ORA-600 problem I
> had.
>
> During the course of conversation, support asked how I'd been shutting
> down the database. I said that I'd been using the Control
> Panel/Services. His reply was that this was the equivalent of a kill -9
> on Unix and was 'not a good thing'. Apparently Oracle 8 has changed the
> behaviour to be equivalent to a 'shutdown immediate'.
>
> Does the above sound correct?
>
> If so, how do you get a correct shutdown performed automatically when
> you shutdown NT? I'm sure that I'll almost always forget to go into
> svrmgr to shutdown the databases before I just ask NT to shutdown!
>
> Ideas?
>
> --
> Andy Hardy
Received on Tue Sep 09 1997 - 00:00:00 CDT