Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pln-e!extra.newsguy.com!lotsanews.com!bloom-beacon.mit.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: Roman.Schicht@atosorigin.com (Roman Schicht) Newsgroups: comp.databases.oracle.server Subject: Re: Automatic startup of multiple instances on one Win2k-Machine?? Date: 9 Sep 2003 05:35:14 -0700 Organization: http://groups.google.com/ Lines: 85 Message-ID: <52d3eb63.0309090435.722c1c0d@posting.google.com> References: <52d3eb63.0309080041.384c2315@posting.google.com> <1063033407.688154@yasure> <52d3eb63.0309090045.72bb2e2@posting.google.com> <3f5d9725$0$246$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: 193.80.57.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1063110915 10494 127.0.0.1 (9 Sep 2003 12:35:15 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 9 Sep 2003 12:35:15 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242686 "Niall Litchfield" wrote in message news:<3f5d9725$0$246$ed9e5944@reading.news.pipex.net>... > "Roman Schicht" wrote in message > news:52d3eb63.0309090045.72bb2e2@posting.google.com... > > Daniel Morgan wrote in message > news:<1063033407.688154@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