Shutdown/Startup from Windows Batch?

[thermidor]

Hi All,

Can Oracle 9i be shutdown and started from a Windows batch script? If so, can anyone provide any examples? I have been unable to log on as sys as sysdba from a script or command prompt.

TIA,
Sven

 

[LKBrwnDBA]

Yes:
Batch script:

sqlplus /nolog @C:\Myscripts\shutdown.sql

shutdown.sql script:

conn <uid>/<pw>@MyDB as sysdba
shutdown immediate
exit

and same for startup.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[thermidor]

Thanks for the info.
Can you give an example of the conn?

Thanks,
Sven

 

[thermidor]

Or rather do I need statements before the call to sqlplus?

 

[LKBrwnDBA]

Maybe:

SET ORACLE_HOME=C:\Ora9i
SET ORACLE_SID=MyDB
sqlplus /nolog @C:\Myscripts\shutdown.sql >C:\Temp\MyDB_Startup.log

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb