oracle| Data | database
Reference: http://support.microsoft.com/default.aspx?kbid=841180
After you install the Windows ms04-011 Security update, the Oracle 8i database on your machine will not run automatically. You can generally solve this problem by manually starting the Oracle database.
1. Modify the Oracle database service startup type as "Manual."
A. Control Panel-> management tools-> Services.
B. Double-click oracleservice<sid>.
C. In the Oracleservice<sid> Properties dialog box, click the "General" tab and install "Startup type" to "manual".
D. Click "OK" to complete.
2. Modify the startup settings for the Oracle instance.
A. Start-> run.
B. Enter the regedit and click "OK".
C. Found in Registry Editor: HKEY_LOCAL_MACHINE OFTWARE\ORACLE\HOME0.
D. Double click on the Ora_<sid>_autostart and enter false and click OK.
E. Close Registry Editor.
3. Create the SQL script file and name it "Startuporacleorcl.sql". The contents are as follows:
Connect <username>/<password>
Startup Pfile=<init. Absolute path of ora >
Exit
Cases:
Connect internal/oracle
Startup Pfile=c:\oracle\admin\orcl\pfile\init. ORA
Exit
4. Create a batch file and name it "Orastart.bat". The contents are as follows:
@echo off
NET start <oracle database service name >
Set oracle_sid=<sid>
Absolute path of SVRMGRL @<startuporacleorcl.sql >
Exit
Cases:
@echo off
net start ORACLESERVICEORCL
Set ORACLE_SID=ORCL
SVRMGRL @e:\tools\orastart Tartuporacleorcl.sql
Exit
5. Run Orastart.bat to complete the manual launch of Oracle.
