Re: NT Scripting Oracle startup???

From: C. R. Soza <crsoza_at_hotmail.com>
Date: 20 Aug 2001 06:34:33 -0700
Message-ID: <c18ea449.0108200534.73c4077c@posting.google.com>

jreyst_at_home.com (John Reyst) wrote in message news:<e59a975.0108171003.3473ff07_at_posting.google.com>...
> Hi,
>
> 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?
>
> I thought I could do something like
>
> SET ORACLE_SID=XXXX
> call SVRMGR23.exe
> command="connect internal"
> command="umtd"
> command="STARTUP"
> exit
>
> This is what I want to do but when I run it it jumps out at srvmgr
> PROMPT, is
> there any way of piping the the following ORACLE commands onto the
> SVRMGR
> Prompt so that it runs through?
>
> Feel free to email me at jreyst_at_home.com if you have an answer!
>
> Thanks,
>
> John Reyst

orashutdown.cmd

---

set ORACLE_SID=%1
set ORACLE_HOME=%2
%2\bin\svrmgr30.exe "connect internal" <%2\database\orashutdown.sql >%2\database\shutdown%3.log

orashutdown.sql

---

shutdown immediate
spool off
exit Received on Mon Aug 20 2001 - 08:34:33 CDT