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

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

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK