Popular Posts
Asynchronous and deferred JavaScript execution explained Normal execution <script> This is the default behavior of the <script> element. Parsing of the HTML code pauses while the scr... Statement.executeBatch() always returns an array of value -2 The elements in the array returned by the method executeBatch may be one of the following: A number greater than or equal to zero -- indi... vi hot key guide 第一部份:一般模式可用的按鈕說明,游標移動、複製貼上、搜尋取代等 移動游標的方法 h 或 向左方向鍵(←) 游標向左移動一個字元 j 或 向下方向鍵(↓) 游標向下移動一個字元 k 或 向上方向鍵(↑) 游標向上移動一個字元 l 或 向右方向鍵(→) 游標...
Stats
Start/stop oracle
REM This batch file is used to start/stop the oracle instance
REM Simply invoke oracle.bat start/stop
cls
@ECHO off
REM ******************************************************************
REM ** Batch file used to stop/start oracle services
REM ******************************************************************

SET _db_=10g_home1
SET _sid_=CCIMES


if(%1)==(start) GOTO START
if(%1)==(stop) GOTO STOP
echo Invalid use. Usage is oracle.bat stop/start
GOTO END


:START
REM ** START the oracle services
echo Starting Oracle Services
REM change the instance/listener names to match what is in your services list
NET START OracleCSService
NET START OracleOraDB%_db_%iSQL*Plus
NET START OracleOraDb%_db_%TNSListener
NET START OracleService%_sid_%
NET START OracleDBConsole%_sid_%
REM NET START OracleJobScheduler%_sid_%
REM NET START "Oracle INNOVATEST VSS Writer Service"
echo Oracle Services Started
GOTO END


:STOP
echo Stopping Oracle Services
REM change the instance/listener names to match what is in your services list
REM NET STOP "Oracle INNOVATEST VSS Writer Service"
REM NET STOP OracleJobScheduler%_sid_%
NET STOP OracleDBConsole%_sid_%
NET STOP OracleOraDb%_db_%TNSListener
NET STOP OracleService%_sid_%
NET STOP OracleOraDB%_db_%iSQL*Plus
NET STOP OracleCSService
echo Oracle Services Stopped
GOTO END


:END