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
Related Q&A from Maria Anderson
I'm getting errors while installing the Database Configuration Assistant.continue reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk."continue reading
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.