Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [RE: 9i NT]

Re: [RE: 9i NT]

From: Yigal Ran <ydran_at_usa.net>
Date: Sun, 02 Sep 2001 09:07:41 -0700
Message-ID: <F001.00380655.20010902090554@fatcity.com> 






Where can I get 9i for NT or Window2000



"A. Bardeen" <abardeen1_at_yahoo.com> wrote:


> 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 <oraracdba_at_yahoo.com> 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"

> > <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).

> 

> 

> __________________________________________________

> 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: abardeen1_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).







Get free email and a permanent address at http://www.amexmail.com/?A=1

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yigal Ran
  INET: ydran_at_usa.net

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 Sun Sep 02 2001 - 11:07:41 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US