Try and get the correct address :( > -----Original Message----- > From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxxxxxxx] > Sent: 31 January 2004 16:14 > To: 'ORACLE-L@xxxxxxxxxxx' > Subject: RE: Starting Database from OEM 9.2 gives ORA-12500 > Failed to star > > > Jacques Kilchoer wrote > > Are you sure about that? > > This is the way I thought it worked with Oracle 8.1 and 9.2 > > (I just tried it again today using Oracle 8.1.7 on Windows 2000) > > > > If in the services control panel the database service has > > Startup Type Automatic, then the registry entry you mention > > will have ORA_sid_AUTOSTART TRUE, and when the machine is > > rebooted, the service will start up AND the instance will be > > started up. > > True by default but this is because of a weakness IMO of the > configuration options in the Windows port. The service and > the database are logically distinct, but oradim sets the > startup behaviour of both of them to be the same. So if you > create a db with oradim -new .... -startmode a both the db > and the service are set to autostart. Similarly if you create > with oradim -new .. -startmode m both are set to manual > start. Probably the easiest way to break the link is to > create the db with startmode manual and then modify the > startup behaviour of the service in control panel to > automatic start, you get an automatically starting service, > but a db that is started as per *nix. If you already have a > service created then you can use oradim -edit to specify > manual startup and then modify the service properties. > > In my view just as oradim -edit allows you to specify > shutmode for the database and shuttype (database and/or > service) it should also allow you to specify the startup > behaviour of the service and the db seperately. > > HTH > > Niall > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------