Oh, come on! The goddess can get anything. She can raise her hands to the sky, mutter
a phrase or two, and POOF beta/pre-prod software appears in her hands (plus the doc
CD).
---
TheOracleDBA
theoracledba_at_lycos.com
On Sun, 02 Sep 2001 14:40:20
Rachel Carmichael wrote:
>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).
>
>
>_________________________________________________________________
>Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>--
>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).
>
Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: The Oracle DBA
INET: theoracledba_at_lycos.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 Tue Sep 04 2001 - 12:10:34 CDT
