Discussion Locked

Managing Oracle 9i services

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,
I've read the artice - Manage Oracle9i services under Windows by Scott Stephens and i have'nt understood clearly how to make the batch jobs for the startup and shutdown of database.
Could somebody please tell me how?
Heres the link for the article.
http://builder.com.com/5100-6388-5224417.html

Thanks in advance

3 replies

by jaqui

to start:

REM "dbstart.cmd"
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
net start OracleService%ORASID%

save as "oracle_start.bat"

to stop:

REM "dbshut.cmd"
@echo off
set ORAHOME="OraHome92"
set ORASID="ORCL"
net stop OracleService%ORASID%

save as "oracle_stop.bat"

to use:
as system administrator open command prompt window.
type:
oracle_start.bat

to start it.

type:
oracle_stop.bat

to stop it.

they are not batch jobs, thay are batch files.

by y_siline

how i configuration color in batch file(windows xp)?

can you give me a example of batch file in windows xp ?

This discussion is closed to new replies.