How to start and stop Oracle services using Batch file
If you're new here, you may want to subscribe to Windows Reference RSS feed Thanks for visiting!
how are you guys
i have problem i wanna to stop service by batch file because i need this to stop service oracle database automaticly by batch file
if you know oracle daatabase in task manager take 256mb form usage and make my pc work slowly i stop it manually
but i need batch file to stop this service and another one to run i used oracle 10g
thank you
Random Posts
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically each day to your feed reader.
Trackbacks & Pingbacks
Comments
Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
Use the following batch file
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 ******************************************************************
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 “OracleOraDb11g_home1TNSListener”
NET START “OracleServiceINNOVATEST”
NET START “Oracle INNOVATEST VSS Writer Service”
NET START “OracleDBConsoleInnovaTest”
NET START “OracleJobSchedulerINNOVATEST”
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
NET STOP “Oracle INNOVATEST VSS Writer Service”
NET STOP “OracleDBConsoleInnovaTest”
NET STOP “OracleJobSchedulerINNOVATEST”
NET STOP “OracleOraDb11g_home1TNSListener”
NET STOP “OracleServiceINNOVATEST”
echo Oracle Services Stopped
GOTO END
:END
Beautiful!!! I saw this and now I can stop/start other services also with this information. Thanks mr.admin!
Will this batch file work in Windows XP? I have some problems regarding the file. In my computer, it does not work!
Thanks in advance.
Hi Guys, I’m a bit of a novice and not sure where to run this batch file, is it at the Command prompt?