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:
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:
a.
Click Start, point to
Settings, and then click Control
Panel.
b.
In Control Panel, double-click
Administrative Tools.
c.
In the Administrative Tools window,
double-click Services.
d.
In the right pane of the Services
window, double-click OracleService<SID>.
e.
In the OracleService<SID> Properties
(Local Computer) dialog box, click the General
tab.
f.
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 (http://support.microsoft.com/kb/322756/) How to back up and restore the registry in Windows
a.
Click Start, and then click
Run.
b.
In the Open box, type
regedit, and then click OK.
c.
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.
d.
In the right pane of Registry Editor,
double click ORA_<SID>_AUTOSTART.
Note: Replace <SID> with the name of the Oracle database
service.
e.
In the Edit String dialog box, type FALSE in
the Value data box, and then
click OK.
f.
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. (http://www.microsoft.com/downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd&DisplayLang=en)
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:
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:
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.
Need More Help? Contact a Support professional by E-mail, Online or Phone.
Customer Service For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
Newsgroups Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.
Help and Support
Back to the top
