| 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: [RE: 9i NT]
you can't yet. It's in beta testing only AFAIK
>From: Yigal Ran <ydran_at_usa.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: [RE: 9i NT]
>Date: Sun, 02 Sep 2001 09:05:54 -0800
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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 Sun Sep 02 2001 - 16:54:19 CDT
 |
 |