RE: Oracle on NT startup question

RE: Oracle on NT startup question

 

  

Peter,

Oops, I missed that completely!

Thanks,

-- Anita

--- Peter.[Email Address Removed] wrote:
> I didn't you may notice that I used the -EDIT switch
> of oradim
>
> Peter
>
> -----Original Message-----
> From: A. Bardeen [mailto:[Email Address Removed]
> Sent: 31 October 2001 14:03
> To: Berry, Peter - ACE; LazyDBA.com Discussion
> Subject: RE: Oracle on NT startup question
>
> 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
>


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