Can you please send me a script to shut down my database using a Windows scheduler? Our database is 8.05. Thank you very much.

    Requires Free Membership to View

    Login

Create the following in Notepad and save it with a SQL extension: 
Shut.sql 
==================== 
connect internal/<password> 
shutdown <normal/immediate/abort> 
exit
Then, create the following batch file and call the previously created SQL file within it: 
Shutdown.bat 
=================== 
SET ORACLE_SID=<SID> 
svrmgr30 @c:shut.sql 
NET STOP ORACLESERVICE<SID> /y
If ORA_<SID>_SHUTDOWN = TRUE and ORA_<SID>_SHUTDOWN_TIMEOUT is high enough, you can simply create this instead: 
Shutdown.bat 
=================== 
NET STOP ORACLESERVICE<SID> /y

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top