Scott and Tom,
You're both right.
Prior to 8i there were two services:
oracleservice<sid> and oraclestart<sid>. The start
service controlled whether the db should attempt to be
started automatically.
Starting with 8i there is only the oracleservice<sid>
service. The start service was replaced by the
registry entry ORA_<sid>_AUTOSTART that controls
whether the db should attempt to be started
automatically.
Keep in mind that in either case, the status of
oracleservice<sid> cannot be used to identify whether
the db is open. The exception is that if
oracleservice<sid> is stopped then the db cannot be
open.
The start service or the ORA_<sid>_AUTOSTART registry
entry merely determine whether the appropriate version
of oradim should be called to start up the db. Prior
to 8i, this call to oradim is made via the
%ORACLE_HOME%\DATABASE\STRT<sid>.CMD file; in 8i+ a
call is made to oradim directly.
The status of the service does not change based on the
outcome of the call to oradim, so if oradim is unable
to open the db (e.g. media recovery is needed) the
service will still show as started. Nor does the
status change if the db is manually shutdown.
When creating the services via oradim the -STARTMODE
AUTO option controls whether the appropriate start
service is created or registry entry is set.
There have been several bugs in the various releases
where the services were unable to start up the db
automatically. In earlier releases, for example, tabs
in the pfile would prevent oradim from starting up the
db, but the db started fine via svrmgrl.
HTH,
-- Anita
--- Scott <[EMAIL PROTECTED]> wrote:
> 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"
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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
> > > [EMAIL PROTECTED]
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: Kevin Kostyszyn
> > > INET: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: A. Bardeen
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).