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" <[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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
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).