Try and get the correct address :(

> -----Original Message-----
> From: Niall Litchfield [mailto:niall.litchfield@(protected)]
> Sent: 31 January 2004 16:14
> To: 'ORACLE-L@(protected)'
> 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@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------