Re: NT Scripting Oracle startup???

"John Reyst" <jreyst_at_home.com> wrote in message

> Guys I am trying to startup an Oracle Service using a script at
> WindowsNT system startup. I am not apparently able to pass script
> commands into svrmgr. Can anyone help?

Sybrand is correct that you should not be writing your own startup and shutdown scripts for Oracle on NT.

However, if you do want to run other scripts via Oracle server manager on NT, you can do it like this:

create a file called x.sql:
-- x.sql --
connect internal;
startup;
exit;
-- x.sql --
(the semicolons are used because even if Oracle is not consistent with SQL*Plus and Server Manager end-of-command indicators, I sure as hell am. :-)

Then you run it via server manager as follows: -- cmd.exe prompt --
C:\> svrmr30 < x.sql

--

A good idea to always script your db create in such a file and then simply run
it via server manager to create the database.

--
Billy