- 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