Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> FW: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

FW: Starting Database from OEM 9.2 gives ORA-12500 Failed to star

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 31 Jan 2004 20:10:28 -0000
Message-ID: <00b101c3e836$4734da70$95acbc3e@nlhome>


Try and get the correct address :(

> -----Original Message-----
> From: Niall Litchfield [mailto:niall.litchfield_at_dial.pipex.com]
> Sent: 31 January 2004 16:14
> To: 'ORACLE-L_at_fatcity.com'
> 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_at_freelists.org 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
-----------------------------------------------------------------
Received on Sat Jan 31 2004 - 14:10:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US