Oracle Database automatic startup failure

Source: Internet
Author: User
Tags exit manual modify connect oracle database
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.


Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.