Oracle database service startup process stops responding

To work around this problem, use one of the following methods.

Method 1: Manually start the Oracle database service

Change the startup behavior of the Oracle database service to a manual type on the computer that runs the Oracle database, and then start the Oracle database service manually. To do so, follow these steps:

1. Change the startup type of the Oracle database service to manual. To do so, follow these steps:
   
   1. Click Start, point to
      Settings, and then click Control Panel.
   2. In Control Panel, double-click
      Administrative Tools.
   3. In the Administrative Tools window, double-click Services.
   4. In the right pane of the Services window, double-click OracleService<SID>.
   5. In the OracleService<SID> Properties (Local Computer) dialog box, click the General tab.
   6. Click Manual in the Startup type list, and then click OK.
2. Change the startup setting of the instance of Oracle database such that the instance of Oracle database does not automatically start when the Oracle database service is started. To do so, follow these steps.
   
   Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
   322756 How to back up and restore the registry in Windows
   1. Click Start, and then click
      Run.
   2. In the Open box, type
      regedit, and then click OK.
   3. In Registry Editor, locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
      
      Note The name of this registry key ends with the number zero (0), not the letter o.
   4. In the right pane of Registry Editor, double click ORA_<SID>_AUTOSTART.
      
      Note: Replace <SID> with the name of the Oracle database service.
   5. In the Edit String dialog box, type FALSE in the Value data box, and then click OK.
   6. Close Registry Editor.
3. Create the following batch file with the name StartupOracleORCL.sql:

   connect <username>/<password>
   startup PFILE=<Full path of the INIT.ORA file for the instance of Oracle database>
   
   exit

4. Create the following Windows batch file with the name Orastart.bat in the same folder where you created the StartupOracleORCL.sql batch file in step 3:

   @echo off
   
   net start <Oracle Service Name>
   set ORACLE_SID=<Oracle SID> 
   svrmgrl @<Full path of startupOracleORCL.sql created in Step 3>
   
   exit

   
   Note You must replace <Oracle Service Name> and <Oracle SID> with the Oracle database service name and the SID of the Oracle database service, respectively.
5. Run the Orastart.bat file at a command prompt.
   
   Note You may notice that the instance of Oracle database starts successfully.

Method 2: Automate the startup of the Oracle services by using Windows Resource Kit utilities

To automate the startup of the Oracle services by using the Service Installer utility (Instsrv.exe) and the Applications as Services utility (Srvany.exe), follow these steps.

Note The Service Installer utility (Instsrv.exe) and the Applications as Services utility (Srvany.exe) are included with the Windows Server 2003 Resource Kit.

1. Download and install the Windows Resource Kit utilities. Download the Rktools.exe package now.
2. Create a folder that is named OracleStartup on the root of drive C.
3. In the C:\OracleStartup folder, create a text file that is named OracleStartup.reg and that contains the following information:

   REGEDIT4
   
   [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleStartup\Parameters]
   "Application"="C:\\OracleStartup\\OracleStartup.cmd"
   
   [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
   "ORA_ORCL_AUTOSTART"=hex(2):34,00,36,00,2c,00,30,00,30,00,2c,00,34,00,31,00,2c,00,30,00,30,\
     00,2c,00,34,00,63,00,2c,00,30,00,30,00,2c,00,35,00,33,00,2c,00,30,00,30,00,\
     2c,00,34,00,35,00,2c,00,30,00,30,00,2c,00,30,00,30,00,2c,00,30,00,30,00,00,\
     00

4. Double-click the C:\OracleStartup\Oracle.reg text file to import the information into your registry.
5. In the C:\OracleStartup folder, create a text file that is named OracleStartup.cmd and that contains the following information:

   sleep 60
   net start OracleServiceORCL
   SET ORACLE_SID=ORCL
   svrmgrl @C:\OracleStartup\OracleStartup.sql
   sleep 15
   EXIT

6. Create a C:\OracleStartup\OracleStartup.sql text file that contains the following information:

   connect internal/oracle
   startup PFILE=C:\init.ora

   Note The startup parameter must include the fully qualified path of the Init.ora file.
   
   Important The C:\OracleStartup\OracleStartup.cmd file contains user credentials in clear text. Therefore, restrict access to this file to administrators and to the Oracle service startup account only. You may be able to avoid including user credentials in the C:\OracleStartup\OracleStartup.cmd file by configuring the Oracle Server for Windows Authentication. For information about how to configure Oracle for Windows authentication, obtain Note: 60634.1 (WIN: Setup O/S Authentication) from Oracle Corporation. For information about how to contact Oracle Corporation, visit the following Web site:
   http://www.oracle.com/
7. Start OracleStartup as a service by using the InstSrv.exe and the SrvAny.exe resource kit utilities and by using the following commands:
   
   "C:\Program Files\Resource Kit\instsrv.exe" OracleStartup "C:\Program Files\Resource Kit\SRVAny.exe"
   sc config "OracleServiceORCL" start= demand
   exit
8. Restart Windows.