Re: Running a script on shutdown/startup

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au>
Date: Tue, 1 Jun 1999 20:55:39 +1000
Message-ID: <7j0ep5$9mq$1@m2.c2.telstra-mm.net.au>

FWIW, No matter what OS you're running, do not use a direct ORACLE interface command to shutdown the database. Create a script in the OS's shell language that calls other scripts that shutdown your bg processes and make the last line of this script a call to svrmgr to shutdown the database.

Simple and effective.

Or upgrade to 8i and do it all automatically from the database using the new event triggers.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au
http://www.users.bigpond.net.au/the_Den ----- Original Message -----
From: Richard Anstey <ranstey_at_compuserve.com> Newsgroups: comp.databases.oracle.server Sent: Tuesday, 1 June 1999 02:14
Subject: Running a script on shutdown/startup

> Hello,
>
> Has anyone come accross a way of getting a script to run automatically when
> the shutdown command is issued ? I need to run a command to stop several
> jobs before the db is shutdown. I'm running on 7.3.4 but would also be
> interested if a solution exists in 8.
>
> Many thanks for any suggestions,
Received on Tue Jun 01 1999 - 05:55:39 CDT