Batch file for STARTUP/SHUTDOWN ORACLE database

[dejanj]

Hi All,

I would like to automate process of starting up Oracle 8i database on WIN2000 machine. I understand i can set to start Oracle8i ( SID ) service to automatic ( using Services control panel ) but i would like to automate the sequence of starting and shuting down Oracle database through use of SVRMGRL

SET ORACLE_SID=CABP

SVRMGRL
> connect internal/manager
> startup

or shuting down database

SET ORACLE_SID=CABP

SVRMGRL
> connect internal/manager
> shutdown immediate

Thanks

Regards
Dejan

 

[myersg]

you would use oradim -stop and oradim -start to control your instance startup/shutdown