Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

batch file on windows to shutdown startup of database via scheduled tasks

KB..Jan 7 2009 — edited Jan 7 2009
are these script ok

startup.bat
c:\
cd \
set oracle_sid=service
net start OracleService<service>

{
conn sys/** as sysdba
startup
} | sqlplus /nolog
exit

shutdown.bat
c:\
cd \
set oracle_sid=service

{
conn sys/c** as sysdba
shutdown immediate
} | sqlplus /nolog
net stop OracleService<service>
exit

Kedar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2009
Added on Jan 7 2009
1 comment
680 views