批处理(bat文件) 自动启动/关闭oracle服务
- 判断oracle 服务状态
- 如果服务处于启动状态,就关闭服务;
- 如果服务处于关闭状态,就启动服务。
- @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 ...
- net stop OracleServiceORCL
- net stop OracleDBConsoleorcl
- net stop OracleOraDb10g_home1TNSListener
- net stop OracleOraDb10g_home1iSQL*Plus
- )else (
- ECHO Starting OracleService, please wait ...
- net start OracleServiceORCL
- net start OracleDBConsoleorcl
- net start OracleOraDb10g_home1TNSListener
- net start OracleOraDb10g_home1iSQL*Plus
- )
- pause
- exit
注意:
OracleServiceORCL和OracleDBConsoleorcl服务名字根据你创建oracle的实例不同而变化,需要查看本地服务进程,相应该动。