Re: associating scripts with Oracle startup and shutdown in NT

From: Mikele <notreally_at_me.com>
Date: Thu, 6 May 1999 21:38:02 -0400
Message-ID: <iArY2.133255$Mb.52780783@newscontent-02.sprint.ca>

Ted,

Sure you can write you own startup and shutdown scripts. Create a bat file that opens server manager and then call a script to shut down, startup, or whatever you want

eg: whatever_script.bat

set oracle_sid = init
call svrmgr30.exe
command="@ shutdown.sql"
bla
bla
bla
call svrmgr30.exe
command="@startup.sql"
more called scripts....
exit

On 8 when NT shuts down, a script called Orashut.bat should shut down the db for you before NT shuts down.

Mikel

tao_foos_at_my-dejanews.com wrote in message <7gcfue$r26$1_at_nnrp1.dejanews.com>...
>Is there any way to associate scripts with Oracle instance or services
startup
>and shutdown? Or is the only way to write a script which performs the
startup
>and shutdown which also performs other tasks?
>
>On the same subject can a script be written to shutdown Oracle instances
which
>is kicked off by WIndows NT shutdown such that the NT shutdown waits for
the
>script to complete before proceeding?
>
>Thanks,
>Ted Andrews
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu May 06 1999 - 20:38:02 CDT