Re: [RE: 9i NT]
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 [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> >>Reply-To: [EMAIL PROTECTED] >>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >>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" <[EMAIL PROTECTED]> wrote: >> > Scott and Tom, >> > >> > You're both right. >> > >> > Prior to 8i there were two services: >> > oracleservice and oraclestart. The start >> > service controlled whether the db should attempt to be >> > started automatically. >> > >> > Starting with 8i there is only the oracleservice >> > service. The start service was replaced by the >> > registry entry ORA__AUTOSTART that controls >> > whether the db should attempt to be started >> > automatically. >> > >> > Keep in mind that in either case, the status of >> > oracleservice cannot be used to identify whether >> > the db is open. The exception is that if >> > oracleservice is stopped then the db cannot be >> > open. >> > >> > The start service or the ORA__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.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 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 >> > > >> > > >>
Re: [RE: 9i NT]
you can't yet. It's in beta testing only AFAIK >From: Yigal Ran <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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" <[EMAIL PROTECTED]> wrote: > > Scott and Tom, > > > > You're both right. > > > > Prior to 8i there were two services: > > oracleservice and oraclestart. The start > > service controlled whether the db should attempt to be > > started automatically. > > > > Starting with 8i there is only the oracleservice > > service. The start service was replaced by the > > registry entry ORA__AUTOSTART that controls > > whether the db should attempt to be started > > automatically. > > > > Keep in mind that in either case, the status of > > oracleservice cannot be used to identify whether > > the db is open. The exception is that if > > oracleservice is stopped then the db cannot be > > open. > > > > The start service or the ORA__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.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 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 > > >
Re: [RE: 9i NT]
Where can I get 9i for NT or Window2000 "A. Bardeen" <[EMAIL PROTECTED]> wrote: > Scott and Tom, > > You're both right. > > Prior to 8i there were two services: > oracleservice and oraclestart. The start > service controlled whether the db should attempt to be > started automatically. > > Starting with 8i there is only the oracleservice > service. The start service was replaced by the > registry entry ORA__AUTOSTART that controls > whether the db should attempt to be started > automatically. > > Keep in mind that in either case, the status of > oracleservice cannot be used to identify whether > the db is open. The exception is that if > oracleservice is stopped then the db cannot be > open. > > The start service or the ORA__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.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 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 Kostysz