数据库服务开关db service switch

view plaincopy to clipboardprint?
·········10········20········30········40········50········60········70········80········90········100·······110·······120·······130·······140·······150
echo off 
cls 
color 8b 
echo.================================================================
echo.+++++++++++++++ 数据库服务开关_jmy           +++++++++++++++++++
echo.               Database service switch
echo. ORACLE:
echo. 1.开启
echo. 2.关闭
echo. ++++++
echo. SQL SERVER
echo. 3.开启
echo. 4.关闭
echo.++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
echo.================================================================

:F 
set zcyh= 
set /p zcyh=确定要启动数据库服务(1,2,3,4) 
if /i "%zcyh%"=="1" goto START_ORACLE 
if /i "%zcyh%"=="2" goto STOP_ORACLE 
if /i "%zcyh%"=="3" goto START_MSSQLSERVER  
if /i "%zcyh%"=="4" goto STOP_MSSQLSERVER  
 
 
:START_ORACLE 
echo 确定要启动Oracle吗？ 
pause 
net start OracleDBConsoleorcl
net start OracleMTSRecoveryService
net start OracleOraDb11g_home1TNSListener
net start OracleServiceORCL
ECHO ORACLE 启动成功。 
goto PATCH_END 
 
:STOP_ORACLE 
echo 确定要停止Oracle吗？ 
pause 
net stop OracleDBConsoleorcl
net stop OracleMTSRecoveryService
net stop OracleOraDb11g_home1TNSListener
net stop OracleServiceORCL
ECHO ORACLE 已经停止 
goto PATCH_END 

 
:START_MSSQLSERVER 
echo 确定要启动MSSQLSERVER吗？ 
pause 
net start MSSQLSERVER
net start MSSQLServerOLAPService
net start MsDtsServer100
net start ReportServer
net start SQLWriter
ECHO SQLSERVER 启动成功。 
goto PATCH_END 

:STOP_MSSQLSERVER 
echo 确定要停止MSSQLSERVER吗？ 
pause 
net stop MSSQLSERVER
net stop MSSQLServerOLAPService
net stop MsDtsServer100
net stop ReportServer
net stop SQLWriter
ECHO SQLSERVER 已经停止 
goto PATCH_END 
 
:PATCH_END 
ECHO   按确定后退出 
pause 
exit