answersLogoWhite

0


Best Answer

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

maovandara

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you create batch file which start the oracle services?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are batch files used for?

batch files are used to run a series of commands at once. people who work on computers daily and have a series of files or programs to start and command to run often create a batch file to do it automatically and save time.


How do you create and launch batch file with multiple websites?

Well Here is your answer: type this in Notepad: start www."website".com and save as "anything.bat"


How to start a career in Oracle?

If you want to make your career in Oracle,to enter in this domain you need to have any certification done


How kill explorerexe when start computer?

you can create an batch file containing following code : @echo off taskkill /F /IM "Explorer.exe" exit and save tha batch file in the startup folder . This would work for windows xp and higher but an not sure for windows 2000.you can start it again manually from task manager->new Task


When did Charlie Batch start for the Detroit Lions?

Charlie Batch started 46 games for the Detroit Lions from 1998-2001.


How do you run a batch file automatically at start up?

Probably trying to make a virus. It's simple: Drag the batch file you want to start on startup into the startup folder in All Programs.


How do you create a batch file on your computer?

You create a batch file by opening up a text editor, the standard windows one is Notepad. Next just start coding using dos commands, for a tutorial visit http://www.allenware.com/icsw/icswidx.htmOnce you finish writing your file just click File-->Save As--> fileName.batAlso choose all files under the "Save as Type" drop down menu.


Can Veritas Backup Exec 10.0 do the backup for oracle database?

Yes. 2 options: 1) Cold backup, pre-script to stop oracle, post script to start up oracle again. 2) Hot backup, use oracle agent for backup exec.


How do you create batch file to launch multiple websites?

OK well first you would need a webstie to open. Lets say it is google. This would be the script: ________________________ @echo off start www.google.com start www.google.com start www.google.com exit ________________________ That would open google three times hope that helps!


Oracle of ages how do you fight gannon i need to know?

You must start a linked game between The Legend of Zelda Oracle of Ages and The Legend of Zelda Oracle of Seasons for an ultimate Linked Game showdown with Twinrova and Gannon.


Who did Charlie Batch beat in first start as Pittsburgh steeler?

Charlie Batch's first start for the Steelers came on November 6, 2005 against the Green Bay Packers in Green Bay. The Steelers won, 20-10.


How do you make a batch file without it closing immediately when you start it or use a command?

YES