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 [EMAIL PROTECTED] -----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 <[EMAIL PROTECTED]> <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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).