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

Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic startup of multiple instances on one Win2k-Machine??

Re: Automatic startup of multiple instances on one Win2k-Machine??

From: Roman Schicht <Roman.Schicht_at_atosorigin.com>
Date: 9 Sep 2003 05:35:14 -0700
Message-ID: <52d3eb63.0309090435.722c1c0d@posting.google.com>


"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3f5d9725$0$246$ed9e5944_at_reading.news.pipex.net>...
> "Roman Schicht" <Roman.Schicht_at_atosorigin.com> wrote in message
> news:52d3eb63.0309090045.72bb2e2_at_posting.google.com...
> > Daniel Morgan <damorgan_at_exxesolutions.com> wrote in message
> news:<1063033407.688154_at_yasure>...
> > > Roman Schicht wrote:
> > >
> > > >Hi,
> > > >
> > > >i have a Win2k-Machine with Oracle 8.1.7 installed. There are multiple
> > > >instances on this machine (5 instances). Every instance has its own
> > > >service set to Automatic. In the registry the "startup"-Parameter for
> > > >every Parameter is set to "true".
> > > >
> > > >The problem is now the following:
> > > >
> > > >At boot-time only the instance is started up, that is set in the
> > > >registry-parameter ORACLE_SID. The other Services are running too, but
> > > >the instances are not started.
> > > >
> > > >BUT!! if i restart such a service manually the database ist started!!
> > > >Only at boottime the instances are not started with the service...
> > > >
> > > >
> > > >Normally i am on UNIX and there is a oratab-file where the
> > > >startable-instaces are listed.
> > > >
> > > >Does anyone know how to start multiple instances at boot-time??
> > > >
> > > >KR
> > > >
> > > >Roman Schicht
> > > >
> > > >
> > > Take Sybrand's advice ... but why 5 instances on one machine.
> > >
> > > Seems like a truly marvelous way to waste memory and have five times
> > > more maintenance work to do.
> >
> >
> > My brain is working normally, thanks :)
> >
> > This 5 instances are not productive only for testing purposes.
> >
> > alert.log says nothing because THE INSTANCES ARE NOT STARTED!!!! <- i
> > said this already.
> >
> > Everything is set in the registry as described above.
> >
> > It works when restarting the service manually. But at the very first
> > starting of the services the instances are left unstarted (without
> > that one set in ORACLE_SID).
> >
> > There are no errors in eventviewer too.
> >
> > As i came from UNIX i donīt know this behaviour and have read some
> > times that it should be not possible to start more than one instance
> > at OS-boot-time.
> >
> >
> > Does anyone of you now have dedicated experience with more than one
> > instance or is it only a guess that it should work??
>
> In amongst all the other replies Paul correctly pointed you at oradim.log
> which is pertinent because on windows it is actually oradim.exe that starts
> the instance.
>
> Things that can cause this behaviour are
>
> 1. The service is set to autostart but the instance isn't, daft as it sounds
> you can configure these seperately
> 2. A parameter file is missing/incorrectly named
> 3. The instance needs to be started by an account with DBA privs and not by
> using a password file, and the SYSTEM account is not in the appropriate os
> group.

Thanks for the hints - i will test them.

#1 is a good hint - i will look at it
#2 isnt the problem because the instance is started if i manually start the service
#3 isnt the problem because manually starting the service with administrator starts the instance...

KR Roman Schicht Received on Tue Sep 09 2003 - 07:35:14 CDT

Original text of this message

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