RDMS三剑客的服务

@echo off
title %1
goto %1
echo Error...
echo.
goto bexit

:orcl_stop
rem 顺序：EM、LSN、SID
rem echo stop Oracle ORCL VSS Writer Service
net stop OracleVssWriterORCL
net stop OracleJobSchedulerORCL
net stop OracleMTSRecoveryService
net stop OracleDBConsoleorcl
net stop OracleOraDb11g_home1TNSListener
net stop OracleOraDb11g_home1ClrAgent
net stop OracleServiceORCL
goto bexit

:orcl_start

rem 顺序：LSN、SID、EM
net start OracleOraDb11g_home1TNSListener
net start OracleServiceORCL
net start OracleDBConsoleorcl
net start OracleJobSchedulerORCL
rem echo start Oracle ORCL VSS Writer Service
net start OracleVssWriterORCL
net start OracleMTSRecoveryService
goto bexit

:Mysql_stop
net stop MySQL57
goto bexit

:Mysql_start
net start MySQL57
goto bexit

:MSSQL_stop
echo SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
net stop MSSQLFDLauncher
echo SQL Server Analysis Services (MSSQLSERVER)
net stop MSSQLServerOLAPService
echo SQL Server Reporting Services (MSSQLSERVER)
net stop ReportServer
echo SQL Server Integration Services 10.0
net stop MsDtsServer100
echo SQL Server VSS Writer
net stop SQLWriter
echo SQL Server 代理 (MSSQLSERVER)
net stop SQLSERVERAGENT
echo SQL Server Browser
net stop SQLBrowser
echo SQL Server (MSSQLSERVER)
net stop MSSQLSERVER
goto bexit

:MSSQL_start
echo SQL Server (MSSQLSERVER)
net start MSSQLSERVER
echo SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
net start MSSQLFDLauncher
echo SQL Server Analysis Services (MSSQLSERVER)
net start MSSQLServerOLAPService
echo SQL Server Reporting Services (MSSQLSERVER)
net start ReportServer
echo SQL Server Integration Services 10.0
net start MsDtsServer100
echo SQL Server VSS Writer
net start SQLWriter
goto bexit


rem sc config [service name] start= <auto|demand|disabled>
:demand_sc
echo ================= orcl
sc config OracleVssWriterORCL start= demand
sc config OracleJobSchedulerORCL start= demand
sc config OracleMTSRecoveryService start= demand
sc config OracleDBConsoleorcl start= demand
sc config OracleOraDb11g_home1TNSListener start= demand
rem sc config OracleOraDb11g_home1ClrAgent start= demand
sc config OracleServiceORCL start= demand
echo ================= Mysql
sc config MySQL57 start= demand
echo ================= MSSQL
echo SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
sc config MSSQLFDLauncher start= demand
echo SQL Server Analysis Services (MSSQLSERVER)
sc config MSSQLServerOLAPService start= demand
echo SQL Server Reporting Services (MSSQLSERVER)
sc config ReportServer start= demand
echo SQL Server Integration Services 10.0
sc config MsDtsServer100 start= demand
echo SQL Server VSS Writer
sc config SQLWriter start= demand
echo SQL Server 代理 (MSSQLSERVER)
sc config SQLSERVERAGENT start= demand
rem echo SQL Server Browser
rem sc config SQLBrowser start= demand
echo SQL Server (MSSQLSERVER)
sc config MSSQLSERVER start= demand
goto bexit

:auto_sc
echo ================= orcl
sc config OracleVssWriterORCL start= auto
sc config OracleJobSchedulerORCL start= auto
sc config OracleMTSRecoveryService start= auto
sc config OracleDBConsoleorcl start= auto
sc config OracleOraDb11g_home1TNSListener start= auto
rem sc config OracleOraDb11g_home1ClrAgent start= demand
sc config OracleServiceORCL start= auto
echo ================= Mysql
sc config MySQL57 start= auto
echo ================= MSSQL
rem echo SQL Full-text Filter Daemon Launcher (MSSQLSERVER)
rem sc config MSSQLFDLauncher start= demand
echo SQL Server Analysis Services (MSSQLSERVER)
sc config MSSQLServerOLAPService start= auto
echo SQL Server Reporting Services (MSSQLSERVER)
sc config ReportServer start= auto
echo SQL Server Integration Services 10.0
sc config MsDtsServer100 start= auto
echo SQL Server VSS Writer
sc config SQLWriter start= auto
rem echo SQL Server 代理 (MSSQLSERVER)
rem sc config SQLSERVERAGENT start= demand
rem echo SQL Server Browser
rem sc config SQLBrowser start= disabled
echo SQL Server (MSSQLSERVER)
sc config MSSQLSERVER start= auto
goto bexit


:bexit
echo.
pause
exit

 

转载于:https://www.cnblogs.com/Tty725/p/9867857.html