REM "dbstart.cmd"
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
net start OracleService%ORASID%
REM net start Oracle%ORAHOME%HTTPServer
REM 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 "dbshut.cmd"
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
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
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
net start OracleService%ORASID%
REM net start Oracle%ORAHOME%HTTPServer
REM 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 "dbshut.cmd"
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
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
NET START
NET STOP
写成个脚本调就可以了
2. 启动脚本
net start OracleOraHome92TNSListener
net start OracleServiceSID
3. 停止脚本
net stop OracleOraHome92TNSListener
net stop OracleServiceSID
net start OracleServiceSID
这种语句重复执行会不会出问题啊?也就是说如果这个监听器和实例已经启动了,
我再用语句启动一下,
会不会出问题啊?
先
net stop OracleOraHome81TNSListener
net stop OracleServiceZQ
在
net start OracleOraHome81TNSListener
net start OracleServiceZQ
或者直接进入
lsnrctl status查看listener的情况
如果没有启动呢,
就启动。
在关闭以前看一下监听器和实例是不是已经关闭了,
如果没有关闭呢,
就关闭。这个用lsnrctl status这个怎么来判断啊?
net start OracleServiceSID
这种语句重复执行会不会出问题啊?