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

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

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

From: Dharminder Softhome <dharminder_at_softhome.net>
Date: Fri, 30 Jan 2004 13:44:25 -0800
Message-ID: <F001.005DE77E.20040130134425@fatcity.com>


Igor,
What you have mentioned is right i.e. if I set "ORA_<SID>_AUTOSTART" to "FALSE" for the database in question and set OraceServiceSID startmode to Automatic then as windows starts it starts the OracleSID service (or I should say background services needed for the database to run and I believe I need to study about this more), but not the database. And then from OEM now I can startup the database.

My impression was that OEM should be able to do all these tasks itself.

Thanks to all others who have replied as well.

-----Original Message-----

Igor Neyman
Sent: Friday, January 30, 2004 3:04 PM
To: Multiple recipients of list ORACLE-L star

Dharminder,

OracleServiceSID starts the database automatically, because by default the registry key "ORA_<SID>_AUTOSTART" IN "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0" is set to "TRUE". If you don't want your OracleServiceSID to start the database automatically, change the value to "FALSE". This way service will be still running, but you should be able to startup the database from OEM.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----

Dharminder Softhome
Sent: Friday, January 30, 2004 2:20 PM
To: Multiple recipients of list ORACLE-L star

Tom,
As stated earlier, here the intention is to startup the database using OEM
only and without using windows service. As for as I understand if the OracleServiceSID is properly setup and if startmode for the service is set
to automatic then it will startup the database automatically once you boot
the machine.
Thanks.

-----Original Message-----

Mercadante, Thomas F
Sent: Friday, January 30, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L star

Dharminder,

Changes the service to AutoStart when the machine reboots. As Thomas said,
the NT service has to be running for you to be able to start the database.
The service will stay running even if you shut the database down. Think of
the service as a backgrouond placeholder for the database. It needs to be
running for the database to run, but you can still shut the database down as
normal and keep the background service running.

hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Friday, January 30, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L start a

Thomas,
That is the real problem. I can start the database using Windows 2000 OracleServiceSID.
But I want to start up the database using OEM only.

Thanks.

-----Original Message-----

Thomas Day
Sent: Friday, January 30, 2004 9:19 AM
To: Multiple recipients of list ORACLE-L start a

Go to the SERVICES and start the service.

                      "Dharminder
                      Softhome"                To:      Multiple
recipients
of list ORACLE-L <ORACLE-L_at_fatcity.com>
                      <dharminder              cc:
                      @softhome.net>           Subject: Starting
Database
from OEM 9.2 gives ORA-12500 Failed to start a dedicated
                      Sent by:                 ....
                      ml-errors


                      01/29/2004 06:14
                      PM
                      Please respond
                      to ORACLE-L






Hey all,
Following is the environment.
Windows 2000
Oracle Enterprise 9.2,
OEM 9.2 I have two 9.2 database installed on my system. OEM is configured properly.
One of the database is in automatic startmode and this DB contains OEM repository.

I start the machine, open OEM, login to OEM and then try to start the other
database, but it does not start the DB, instead I get ORA-12500 Failed to start a dedicated....

OEM doc says that with OEM, you can start/shutdown the database using OEM.
Can someone point to me what I am doing wrong. I am using sys username/password for the startup of the second database.

Thanks.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Dharminder Softhome
  INET: dharminder_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Thomas Day
  INET: tday6_at_csc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Dharminder Softhome
  INET: dharminder_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Dharminder Softhome
  INET: dharminder_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Dharminder Softhome
  INET: dharminder_at_softhome.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Jan 30 2004 - 15:44:25 CST

Original text of this message

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