Re: Oracle shutdown abort on NT

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 16 Sep 1999 19:21:43 GMT
Message-ID: <19990916152143.03105.00000076@ngol01.aol.com>

>>Is this for an 8 installation??

Yes it is an Oracle 8...

>>If you're running Oracle7 on (DEC-ALPHA) NT4, you must also shutdown the
service
(oracleservice{SID}), as this holds the databaese files locked open. use a "net stop oracleservice{SID}" after the shutdown script, and a "net start......" before the startup.
I found this out the hard way! -- if you're using ntbackup.exe, check the logfile for "File in Use" errors, and make sure that none of you database files are skipped.
<<

I thought everyone using NT already had some variety of the following scripts...

REM -----------------------------------------------------

REM OCSTOP.BAT - Stop Open Services for backup REM
REM x's automatic tape backup program, Cheyenne's ARCserve, must have all files in the
REM backup directory(ies) closed at the time the backup is started. If any files are open,
REM the backup will be marked as 'incomplete.' To prevent this, certain services on the
REM server which hold files open must be stopped during the backup session. This batch
REM file uses the Windows NT command "sc" to stop services prior to the backup session.
REM
REM This file is the first of two parts. The companion file 'OCSTART.BAT' is responsible
REM for restarting the services at the end of the backup session, and the services in that
REM file must match those listed here. Note that the sequence of start and stop services
REM may differ between the two files.

REM -----------------------------------------------------

REM REM 1.0 6/25/98 rlr Initial Version REM

REM REM Stop Oracle Services
sc stop "OracleStartORCL"
sc stop "OracleServiceORCL"

REM Stop IIS-Related Services
REM - FTP Publishing Service
sc stop "MSFTPSVC"
REM - Microsoft SMTP Service
sc stop "SMTPSVC"
REM - World Wide Web Publishing Service sc stop "W3SVC"
REM - Now can stop IISADMIN
sc stop "IISADMIN"

REM exit

REM -----------------------------------------------------

REM OCstart.BAT - Start Open Services for backup REM
REM This file is a companion to OCSTOP.BAT. See that file for a complete description.
REM

REM

REM     Ver     Date            Who     Comments
REM     ---     -------         ---     -------------------------
REM     1.0     6/25/98         rlr     Initial Version

REM

REM REM Start Oracle Services
sc start "OracleStartORCL"
sc start "OracleServiceORCL"

REM Start IIS-Related Services
REM - World Wide Web Publishing Service sc start "W3SVC"
REM - Microsoft SMTP Service
sc start "SMTPSVC"
REM - FTP Publishing Service
sc start "MSFTPSVC"
REM - Now can start IISADMIN
sc start "IISADMIN"

REM exit

Paul in VT Received on Thu Sep 16 1999 - 14:21:43 CDT