Discussion Locked

Oracle8i Automate dB Shutdown

0 helpful

3 replies

by keebmachine Jun 25, 2004 last reply Jun 25, 2004 1 view

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

I would like to know how to automate the shutdown of an Oracle8i database. I would like to be able to do this through the use of a script.

3 replies

Try this.

Database shutdown script:

1. Create a batch file dbdown:

ECHO OFF
REM Shutdown eniac, M.K.
h:\orant\bin\svrmgr23 @h:\CMS_Source$\CMS_Source\Db\Maintenance\shutdown.sql
REM
ECHO ON

2. The file shutdown.sql is:

connect internal/
shutdown immediate
exit;

Excellent this is exactly what I was looking for!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

This question was closed by the author

This discussion is closed to new replies.