小乔 发表于 2015-8-15 14:18:15

启动Oracle,SQL服务,IIS脚本

  
  启动Oracle服务脚本
  将下面的脚本保存成.bat格式文件
  

@echo off
rem Copyright LGCX Inc 2008. All rights reserved
rem Author: furenjun
rem Last Update: 23 DEC 2008

echo "starting oracle services"
echo "%date%"
cd c:\
set ORAHOME="OraHome92"
set ORASID="ORCL"
REM cdC:\oracle\ora92\BIN\
net start OracleService%ORASID%
REM net start Oracle%ORAHOME%HTTPServer
net start Oracle%ORAHOME%TNSListener
REM net start Oracle%ORAHOME%ClientCache
REM net start Oracle%ORAHOME%Agent
REM net start Oracle%ORAHOME%SNMPPeerEncapsulator
REM net start Oracle%ORAHOME%SNMPPeerMasterAgent
REM net start Oracle%ORAHOME%PagingServer
REM net start OracleMTSRecoverService

REM =============================================
REM STOP SERVICES
REM net stop OracleService%ORASID%
REM net stop Oracle%ORAHOME%HTTPServer
REM net stop Oracle%ORAHOME%TNSListener
REM net stop Oracle%ORAHOME%ClientCache
REM net stop Oracle%ORAHOME%Agent
REM net stop Oracle%ORAHOME%SNMPPeerEncapsulator
REM net stop Oracle%ORAHOME%SNMPPeerMasterAgent
REM net stop Oracle%ORAHOME%PagingServer
REM net stop OracleMTSRecoverService
REM =============================================

echo "Successfully start oracle services :)"
echo "Press Any key to exit"
pause  
  
  启动SQL服务脚本
  将下面的脚本保存成.bat格式文件
  

@echo off
rem Copyright LGCX Inc 2008. All rights reserved
rem Author: furenjun
rem Last Update:2009-3-21

echo "starting SQL services"
echo "%date%"
cd c:\
set ORAHOME="OraHome92"
set ORASID="FRJSQL"
REM cdC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\
net start   MSSQLSERVER
net start   SQLSERVERAGENT
net start   SQLBrowser
net start   MSSQL$%ORASID%
REM net start Oracle%ORAHOME%HTTPServer
net start   SQLAgent$%ORASID%
REM net start Oracle%ORAHOME%ClientCache
REM net start Oracle%ORAHOME%Agent
REM net start Oracle%ORAHOME%SNMPPeerEncapsulator
REM net start Oracle%ORAHOME%SNMPPeerMasterAgent
REM net start Oracle%ORAHOME%PagingServer
REM net start OracleMTSRecoverService

REM =============================================
REM STOP SERVICES
REM net stop OracleService%ORASID%
REM net stop Oracle%ORAHOME%HTTPServer
REM net stop Oracle%ORAHOME%TNSListener
REM net stop Oracle%ORAHOME%ClientCache
REM net stop Oracle%ORAHOME%Agent
REM net stop Oracle%ORAHOME%SNMPPeerEncapsulator
REM net stop Oracle%ORAHOME%SNMPPeerMasterAgent
REM net stop Oracle%ORAHOME%PagingServer
REM net stop OracleMTSRecoverService
REM =============================================

echo "Successfully start SQL services :)"
echo "Press Any key to exit"
pause  
  注:
  根据实际情况更改
  set ORAHOME="OraHome92"
set ORASID="ORCL"
  两项,此两项的具体名称可在windows 服务中查看到; 通过 开始-->运行, 输入services.msc 命令可调出本机的所有windows服务;
  
  重启IIS脚本
  方法1:

可以通过执行命令重启IIS
方法:
开始-->运行-->CMD-->IISRESET
  
  方法2:

@ECHO off
@Title IIS6重新启动
net stop w3svc
net stop iisadmin /y
net start w3svc
页: [1]
查看完整版本: 启动Oracle,SQL服务,IIS脚本