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.