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

Yes, I'm sure.

If in the services control panel you change OracleService<SID> starup properties, it does not affect "ORA_<SID>_AUTOSTART" key in "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0" (and does not change the way the database is started when the service is started). What it does, it changes the value of "Start" key in "HKEY_LOCAL_MACHINE\CurrentControlSet\Services\OracleService<SID>" (and the way service is started when the machine is rebooted - Automatic/Manual).

So, if you have "Start" key in
"HKEY_LOCAL_MACHINE\CurrentControlSet\Services\OracleService<SID>" set to "2" (which means "automatic") and you have "ORA_<SID>_AUTOSTART" key in
"HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0" set to "FALSE", then on reboot OracleService<SID> will start automatically, but the database will not startup. So, then (whenever you ready) you can do:

set oracle_sid=instance_name
sqlplus /nolog
connect sys/password as sysdba
startup

which will startup the database.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
Jacques Kilchoer
Sent: Friday, January 30, 2004 4:04 PM
To: Multiple recipients of list ORACLE-L star

> -----Original Message-----
> Igor Neyman
>
> 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

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.

If you want to startup the instance manually on system reboot, you should set the Startup Type for the service to Manual (either in the Services control panel or the registry). Then once the machine is rebooted, you can

1. go to the Services control panel and start the Service, which will start the service and the instance

OR

2) At a command prompt type in
set ORACLE_SID=instance_name
oradim -startup -sid %ORACLE_SID%
which will start the service and the instance

OR

3) At a command prompt type in
set ORACLE_SID=instance_name
oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then
oradim -startup -sid %ORACLE_SID% -starttype inst which will start the instance

OR

4) At a command prompt type in
set ORACLE_SID=instance_name
oradim -startup -sid %ORACLE_SID% -starttype srvc which will start the service, then
sqlplus /nolog
connect sys/password as sysdba
startup
which will start the instance

I personally use method 4.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jacques Kilchoer
  INET: Jacques.Kilchoer_at_quest.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: 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).