Oracle database service startup process stops responding (841180)

WORKAROUND

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.
   
   Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.
   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.