Batch Processing (BAT file) automatically starts/closes the Oracle service

Batch Processing (BAT file) automatically starts/closes the Oracle service

1. Determining the Oracle service status
2. If the service is in the starting status, the service is closed;
3. If the service is closed, start the service.

@ Echo off <br/> for/F "Skip = 3 tokens = 4" % I in ('SC query oracleserviceorcl ') do set "zt = % I" & Goto: Next <br/>: next <br/> If/I "% ZT %" = "running" (<br/> echo stoping oracleservice, please wait... <br/> net stop oracleserviceorcl <br/> net stop oracledbconsoleorcl <br/> net stop oracleoradb10g_home1tnslistener <br/> net stop oracleoradb10g_home1isql * Plus <br/>) else (<br/> echo starting oracleservice, please wait... <br/> Net start oracleserviceorcl <br/> Net start oracledbconsoleorcl <br/> Net start oracleoradb10g_home1tnslistener <br/> Net start oracleoradb10g_home1isql * Plus <br/>) <br/> pause <br/> exit <br/>

 

Note:

The service names of oracleserviceorcl and oracledbconsoleorcl vary depending on the instance you created for Oracle. You need to check the local service process.

 

 

References:

1. http://hi.baidu.com/smilevt/blog/item/ceca43f6f4aa892e730eec8b.html

2. http://zdz8207.javaeye.com/blog/487532