From: Hassan Abba Subject: Re: Database shutdown on NT Date: 1997/09/09 Message-ID: <34151CC1.430F524C@softopt.co.uk>#1/1 References: To: Andy Hardy Organization: British Telecom Newsgroups: comp.databases.oracle.server 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