batch file on windows to shutdown startup of database via scheduled tasks
KB..Jan 7 2009 — edited Jan 7 2009are 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