Re: Shutdown Oracle on NT Server

If you know the name of the service that you want to stop then the command

net stop "servicename"

will stop the service. The quotes are needed for services with spaces in them

You can stop the OracleStart<SID> and OracleService<SID> services to shutdown a database (better possibly to script a SVRMGR30 session and do a shutdown first)

You can then schedule this job with the AT command before the backup kicks in, and restart it with

net start "OracleStart<SID>"

after the backup has finished.

Mark Fisher
Technical Specialist
Britannic Assurance

stuart.crawford_at_usa.net wrote in message <6v9j9q$g2c$1_at_nnrp1.dejanews.com>...
>I would like to shutdown my Oracle 7 Server on NT, so I can back up my
>database at night using NT backup, what I am doing right now is during the
>day, stopping the oracle services and backing up the dbase, I am looking
for
>the commands so I can write a file that shuts down these services or if
there
>is a switch that NTBackup has to back up live databases
>
>Thanks
>
>Stu&#137;
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 05 1998 - 04:37:01 CDT