Oracle入门（二）之服务启动bat

转载自 批处理（bat文件）自动启动/关闭oracle服务

批处理（bat文件） 自动启动/关闭oracle服务

1. 判断oracle 服务状态
2. 如果服务处于启动状态，就关闭服务；
3. 如果服务处于关闭状态，就启动服务。

@ECHO OFF
for /f "skip=3 tokens=4" %%i in ('sc query OracleServiceORCL') do set "zt=%%i" &goto :next          
:next          
if /i "%zt%"=="RUNNING" (      
    ECHO Stoping OracleService, please wait ...       
rem    net stop OracleVssWriterORCL    
rem    net stop OracleDBConsoleorcl     
rem   net stop OracleMTSRecoveryService      
rem    net stop OracleOraDb11g_home1ClrAgent     
    net stop OracleOraDb11g_home1TNSListener    
    net stop OracleServiceORCL       
 )else (          
    ECHO Starting OracleService, please wait ...       
rem    net start OracleVssWriterORCL     
rem    net start OracleDBConsoleorcl     
rem    net start OracleMTSRecoveryService     
rem    net start OracleOraDb11g_home1ClrAgent     
    net start OracleOraDb11g_home1TNSListener     
    net start OracleServiceORCL    
    )         
	pause  
	exit