windows서버 oracle restart

1) restart.sql

   connect / as sysdba

   host lsnrctl stop

   shutdown immediate

   startup 

   host lsnrctl start 

   exit

 

 

2) restart.bat

 

   D:\oracle\app\product\11g\bin\sqlplus.exe /nolog @c:\backup\restart.sql

 

 

3) windows의 작업스케쥴러에 restart.bat등록

 

 

4) 서버 재시작 확인