Re: Re: Starting "Services" for Oracle on NT - question

i have this in a .cmd file..

SET ORACLE_SID=%1
NET START YOUR%1SERVICE
NET START YOUR%1LISTENER
SVRMGR30 <<EOF
CONNECT INTERNAL/ORACLE
STARUP OPEN PFILE=LOCATION OF INIT.ORA
EOF>> But on NT when i run this in DOS it doesnt like the "<<EOF" it says "<< was unexpected at this time.".

thanx.

In article <38208782.43982045_at_cnews.newsguy.com>,   (SightBlinder) wrote:
> The easiest thing to do is create a dos batch file to start the
> service, then run svrmgr30 with a command option to startup the
> database. And if you want to create re-usable batch code, use dos
> batch variables in the script. Then if you have multiple instances on
> the NT box, you can use the same script to start them up and shut them
> down.
>
> Something like this: (ps: double check syntax, this is all from
> memory)
>
> startdb.cmd would contain
>
> SET ORACLE_SID=%1
> NET START YOUR%1SERVICE
> NET START YOUR%1LISTENER
> SVRMGR30 <<EOF
> CONNECT INTERNAL/ORACLE
> STARUP OPEN PFILE=LOCATION OF INIT.ORA
> EOF>>
>
> To run it for a db called inst1, simply type startdb inst1. For
> inst2, startdb inst2
>
> Create a similar cmd file to shut the db down and stop all services
> with NET STOP.
>
> HTH
> ~Jim
>
> On Tue, 2 Nov 1999 18:56:36 +0100, "Sybrand Bakker"
> <postmaster_at_sybrandb.demon.nl> wrote:
>
> >Oracle is on NT implemented as a service, the background processes as
> >threads within that service.
> >When you start the Oracle service, the strt<%ORACLE_SID%>.cmd in
> >%ORACLE_HOME%\database is run.
> >This script calls the instance manager, oradim<xx>, which load the
Oracle
> >executable in memory, and starts all the threads.
> >A shutdown by means of svrmgr<xx> doesn't stop the service, as you
probably
> >have discovered. You should use oradim<xx> to accomplish that.
> >
> >Hth,
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 05 1999 - 14:13:17 CST