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

Roman Schicht wrote:

>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??
>
>KR Roman Schicht
>
>

The problem can be fixed by dropping the Oracle services using oradim.exe and recreating them
being careful to use -startmode a.

The problem should be fixed by having a single database instance with 5 schemas. To have 5 system
tablespaces, 5 temp tablespaces, 5 SGAs, etc. unless there is a compelling business reason is pure madness.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)