Oracle database service startup process stops responding

Article translations Article translations
Article ID: 841180 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

After you install the MS04-011 Security Update for Microsoft Windows on a computer that runs Oracle database 8i, the computer may stop responding during the startup process. The MS04-0ll Security Update is described in the following Microsoft Security Bulletin:
http://www.microsoft.com/technet/security/bulletin/ms04-011.mspx

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.

    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.
    Collapse this imageExpand this image
    Download
    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.

MORE INFORMATION

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products. Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Properties

Article ID: 841180 - Last Review: September 5, 2007 - Revision: 1.7
APPLIES TO
  • Microsoft Windows Server 2003, Enterprise x64 Edition
  • Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
  • Microsoft Windows Server 2003, Standard Edition (32-bit x86)
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows 2000 Server
  • Microsoft Windows XP 64-Bit Edition Version 2003
  • Microsoft Windows XP Professional
  • Microsoft Windows 2000 Professional Edition
  • Microsoft Windows NT Server 4.0 Standard Edition
Keywords: 
kboracle800 kboracle kbsecurity kbscript kbregistry kbservice kbserver kbdatabase kbprb KB841180

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com