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