Re: Database shutdown on NT

In 7.1 and 7.2 on Windows NT use SQLDBA7x, in 7.3 use svrmgr23 connect internal/pwd_at_2:sid (2:sid only works on the DB server). Once connected issue SHUTDOWN (7.1, 7.2), if you are using OEM Oracle Enterprise Manager there is always the DBSNMP user connected to the DB if the Oracle Agent Service is running. If so, SHUTDOWN IMMEDIATE will disconnect all users and shutdown the DB after rolling forward commited data.

If you are shutting down for a cold backup stop the SIDs services to be sure the OS has no locks on the datafiles. I know once the DB is closed the datafiles are suppose to be closed but I've seen different on NT. (Not on all systems though.)

SVRMGR23, SQLDBA72, or SQLDBA71 depending on the version used is the correct way to shutdown the database.

Matt Arrocha marrocha_at_bellsouth.net

Nicolas Issakides <nissakid_at_planete.net> wrote in article <340f1a17.0_at_Kampot>...
> to shutdown Oracle,you can use the shudown command under sqldba7x
> or
> Under Windows NT, you can use oradim7x
>
> (where x is the Oracle version number.)
>
> for example oradim 71 for Oracle NT 7.1, oradim73 for 73
>
> This program is the instance manager of Oracle can be run interactively
> and also with command line parameters.
>
> Interactivly, you will have a list of SID with the status of each
 instance and
> option to start, shutdown, the instance
>
> type sqldim73 /? to get correct command line synthax.
>
> but you will be able to perform the same operation this way that
 interactvly
>
> In article <LzsHnHAD4RD0MwzM_at_camk.demon.co.uk>, Andy Hardy
> <Andy_Hardy_at_camk.demon.co.uk> 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?
> >
>
> Nicolas
>
>
> Nissakid_at_planete.net
> Microsoft Certified Product Specialist
> AUI Member
>
> The above represents my own opinion not my employer's and does not
> necessarily constitute the official policy of my employer. Any opinion
> developed through this account represent a private conversation.
>
>
Received on Thu Sep 11 1997 - 00:00:00 CDT