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

I might be mixing my NT with Unix. If that won't work, try placing all your generic startup commands in a seperate file, then call that file like this

SVRMGR30 COMMAND=@MYFILE Everything you need to pipe to svrmgr needs to be in myfile

On Fri, 05 Nov 1999 20:13:17 GMT, ks_user2_at_my-deja.com wrote:

>
>
>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 Mon Nov 08 1999 - 05:35:17 CST