启动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 cd  C:\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 cd  C:\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