| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i NT - now autostart instance
Hi
I would have to disagree with this.
What if you have a standby database - whereby - you *have* to start the
service, but do not want to open the instance, but go through a stepwise
process
startup nomount
alter database mount standby database
recover standby database
shutdown abort -- this is to avoid bugsquit
In this case - a "correctly setup" database would not have the service start the instance.
Paul
don't pull overnight recoveries the night before a 3 day weekend.
"Cale, Rick T (Richard)" wrote:
>
> Scott,
>
> I would have to agree with Tom on this. If you have it setup correctly then
> starting the services
> WILL start the database. I have 8 instances and they all start if I start
> the NT services.
>
> Rick
>
> -----Original Message-----
> Sent: Friday, August 31, 2001 1:04 PM
> To: Multiple recipients of list ORACLE-L
>
> Tom, You could say that I am absolutely wrong but that
> would be incorrect. I have installed Oracle on NT many
> times and I am correct in saying that when you start
> the oracleservice<SID> this does not start the
> instance or database by default. I have 8.0.6, 8.1.7
> and 9.0.1 BETA installed and these instances don't
> start when the service is started. I have to log into
> a DOS window set ORACLE_SID=ops1 then start the
> instances and database. This is the default. If I want
> the instance and database to start when I start the
> service I use the ORDIM.exe command to set that
> feature up. I prefer not to start the instances and
> database it because I run OPS and RAC on NT and I
> haven't set a dependencies between the OSD services
> and the Oracle SID service. If you use DataBase
> Creation Assistant (DBCA) then it will not only create
> a service for you instance it will setup the autostart
> feature as well. However 9i NT BETA DBCA does not do
> this but 8.1.7 does. I don't use DBCA. I create the
> SID service using ORADIM.exe and I create the database
> with scripts. The NT Oracle GUI tools will setup all
> the services. Check you registry under
> HK_LOCAL_MACHINE -> SYSTEM -> CURRENTCONTROLSET ->
> ORACLE* and you should see the autostart service and
> check the dependencies.
>
> Scott
>
> --- "Mercadante, Thomas F" <NDATFM_at_labor.state.ny.us>
> wrote:
> > Scott,
> >
> > you are absolutely wrong on this one. every
> > database I am working with on
> > NT starts when the service starts. even without
> > setting the AUTOSTART
> > param.
> >
> > Tom Mercadante
> > Oracle Certified Professional
> >
> >
> > -----Original Message-----
> > Sent: Thursday, August 30, 2001 6:16 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Kevin, Starting the NT service for the oracle
> > instance
> > has never started the database in any version of
> > Oracle on NT by default. I think what you have seen
> > before is the use of the auto start service of the
> > DB.
> > This service has a dependency to the SID service, so
> > when you start the SID service it would start the
> > database as well. This auto start and shutdown
> > feature
> > can be configured through the oradim.exe command.
> >
> > If you already have the SID service create then:
> >
> > oradim -edit -sid test -startmode a -pfile
> > d:\ora901\database\init.ora
> >
> > There is also a -startup option that will allow you
> > to
> > specify the password.
> >
> > Good Luck,
> >
> > Scott
> >
> >
> > --- Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
> > > Just thought I would mention this interesting
> > little
> > > feature. Now I don't
> > > know if I am an idiot or if something went wrong
> > > (probably both), but
> > > apparently NT services will not start the
> > instance.
> > > I had to manually start
> > > it to get it to go? I guess in a way that's good,
> > > move little nt people
> > > like me away from the GUI tools:)
> > >
> > > Sincerely,
> > > Kevin Kostyszyn
> > > DBA
> > > Dulcian, Inc
> > > www.dulcian.com
> > > kevin_at_dulcian.com
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Kevin Kostyszyn
> > > INET: kevin_at_dulcian.com
> > >
> > > Fat City Network Services -- (858) 538-5051
> > FAX:
> > > (858) 538-5051
> > > San Diego, California -- Public Internet
> > > access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed
> > > from). You may
> > > also send the HELP command for other information
> > > (like subscribing).
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Get email alerts & NEW webcam video instant
> > messaging with Yahoo! Messenger
> > http://im.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Scott
> > INET: oraracdba_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Mercadante, Thomas F
> > INET: NDATFM_at_labor.state.ny.us
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
> http://im.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott
> INET: oraracdba_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: paled_at_home.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Aug 31 2001 - 19:16:06 CDT
 |
 |