Microsoft KB Archive/841180

= Oracle database service startup process stops responding =

Article ID: 841180

Article Last Modified on 9/5/2007

-

APPLIES TO


 * Microsoft Windows Server 2003, 64-Bit Enterprise Edition
 * Microsoft Windows Server 2003, Enterprise Edition
 * Microsoft Windows Server 2003, Standard Edition (32-bit x86)
 * Microsoft Windows 2000 Advanced Server
 * Microsoft Windows 2000 Server
 * Microsoft Windows XP Professional for Itanium-based systems
 * Microsoft Windows XP Professional
 * Microsoft Windows 2000 Professional Edition
 * Microsoft Windows NT Server 4.0 Standard Edition

-



Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



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:  Change the startup type of the Oracle database service to manual. To do so, follow these steps:  Click Start, point to Settings, and then click Control Panel. In Control Panel, double-click Administrative Tools. In the Administrative Tools window, double-click Services. In the right pane of the Services window, double-click OracleService. In the OracleService<SID> Properties (Local Computer) dialog box, click the General tab.</li> Click Manual in the Startup type list, and then click OK.</li></ol> </li> 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. <ol style="list-style-type: lower-alpha;"> Click Start, and then click Run.</li> In the Open box, type regedit, and then click OK.</li> In Registry Editor, locate the following registry key:

Note The name of this registry key ends with the number zero (0), not the letter o.</li> In the right pane of Registry Editor, double click ORA_<SID>_AUTOSTART.

Note: Replace <SID> with the name of the Oracle database service.</li> In the Edit String dialog box, type FALSE in the Value data box, and then click OK.</li> Close Registry Editor.</li></ol> </li>  Create the following batch file with the name StartupOracleORCL.sql: connect / startup PFILE=<Full path of the INIT.ORA file for the instance of Oracle database>

exit </li>  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. </li> Run the Orastart.bat file at a command prompt.

Note You may notice that the instance of Oracle database starts successfully.</li></ol>

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. <ol> Download and install the Windows Resource Kit utilities. Download the Rktools.exe package now.</li> Create a folder that is named OracleStartup on the root of drive C.</li>  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] &quot;Application&quot;=&quot;C:\\OracleStartup\\OracleStartup.cmd&quot;

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0] &quot;ORA_ORCL_AUTOSTART&quot;=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 </li> Double-click the C:\OracleStartup\Oracle.reg text file to import the information into your registry.</li>  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 </li> <li> 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/

</li> <li>Start OracleStartup as a service by using the InstSrv.exe and the SrvAny.exe resource kit utilities and by using the following commands:

&quot;C:\Program Files\Resource Kit\instsrv.exe&quot; OracleStartup &quot;C:\Program Files\Resource Kit\SRVAny.exe&quot;

sc config &quot;OracleServiceORCL&quot; start= demand

exit </li> <li>Restart Windows.</li></ol>

<div class="moreinformation_section">

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.

Additional query words: oracle database service startup failure hangs MS04-011 security update

Keywords: kboracle kbregistry kbscript kbserver kbservice kbdatabase kbsecurity kboracle800 kbprb KB841180

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.