也是在網上看到的,自己給改了改。
寫了一個批處理。
REM "oraStart.cmd"
@echo off
set ORAHOME="OraHome90"
set ORASID="zsd"
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 "oraStop.cmd"
@echo off
set ORAHOME="OraHome90"
set ORASID="zsd"
net stop OracleService%ORASID%
REM net stop Oracle%ORAHOME%HTTPServer
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
說明一下,ORAHOME是oracle的目錄的全局變量名,ORASID是安裝數據庫的SID名。
一個是啟動,一個是停止。方便機器不太靈光的oracle初學者。REM部分是屏蔽的命令,可以參考系統服務列表。一般開啟監聽和數據庫服務就可以了。