In 8i+ you don't need to recreate the service to
change this. Whether the db is started when the
service is started is determined by the
ORA_<sid>_AUTOSTART registry entry. If you don't want
the db to start when the service is started just set
it to false (the default setting is true).

I believe if you create the db using the DBCA then the
registry entry is created for you, otherwise you'll
need to create it manually.

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEn
where HOMEn is the appropriate Oracle Home for the
version of the db

For more info on the services see Note: 74006.1 "NT:
Instance Specific Oracle Services FAQ"

HTH,

-- Anita


--- Peter.[Email Address Removed] wrote:
> With 8.0.x there is a separate startup service so
> you have the
> OracleService<SID> set to automatic and
> OracleStart<SID> set to manual.
>
> With 8i the command would be
> 'oradim -EDIT -SID <SID> -STARTMODE manual'
> You can then have the OracleService<SID> set to
> automatic but the database
> will not start until you issue a startup command
> with sqlplus, svrmgrl or
> oradim.
>
> Peter Berry
>
> -----Original Message-----
> From: Andrey Bronfin
> [mailto:[Email Address Removed]
> Sent: 31 October 2001 09:33
> To: LazyDBA.com Discussion
> Subject: Oracle on NT startup question
>
>
> Dear list !
>
> If my NT server (which runs an Oracle instance) gets
> rebooted accidentally,
> how can i bring up the Oracle services without
> starting up the instance ?
> I want to startup the instance with a script later .
> I'm interested in an answer for both Oracle 8.0.5
> and 8.1.7 on NT4.
>
> Thanks in advance.
>
> DBAndrey
>
> * 03-9254520
> * 053-464562
> * mailto:[Email Address Removed]
>
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com
Oracle LazyDBA home page