Script to shut down database with Windows scheduler
Can you please send me a script to shut down my database using a Windows scheduler? Our database is 8.05.
Shut.sql ==================== connect internal/<password> shutdown <normal/immediate/abort> exitThen, 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> /yIf 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
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments