Oracle initialization or shutdown in progress Solution

Source: Internet
Author: User

Oracle initialization or shutdown in progress solution this year has been testing server migration issues, constantly creating tablespaces, creating databases, and creating users. After that, I thought that creating so many things would take up too much disk space. I thought about deleting them. So we ran the dbca command to delete all useless databases, after deleting all the dbf and dmp files, you will find that the service cannot be started. The connection will prompt oracle initialization or shutdown in progress. Later, you will find that, it turns out that these dbf and dmp cannot be deleted because they are not deleted. (at that time, we obviously found that some of them are not allowed to be deleted. I still deliberately stopped the oracle service and deleted it ), eventually, the database instance cannot be started. My solution is as follows: Microsoft Windows [version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. c: \ Documents ents and Settings \ Administrator> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Friday March 4 18:40:13 2011 Copyright (c) 1982,200 5, Oracle. all rights reserved. SQL> connect system/hope; ERROR: ORA-01033: ORACLE initialization or shutdown in progress [This is the ERROR] [solution] SQL> connect sys/hope as sysdba is connected. SQL> shutdown normal ORA-01109: the database has not opened the detached database. The ORACLE routine has been disabled. SQL> start mount SP2-0310: Unable to open file "mount. SQL" SQL> startup mount ORACLE routine started. Total System Global Area 612368384 bytes Fixed Size 1332348 bytes Variable Size 183151492 bytes Database Buffers 423624704 bytes Redo Buffers 4259840 bytes Database load is complete. SQL> alter database open; alter database open * 1st Line Error: ORA-01157: unable to identify/lock Data File 5-see DBWR trace file ORA-01110: Data File 5: 'C: \ TYKM. DBF 'SQL> alter database datafile 5 offline drop; [5 is Data File 5] The database has been changed. SQL> alter database open; [We keep repeating this statement until no error is prompted.] The database has been changed. SQL> shutdown normal database has been disabled. The database has been detached. The ORACLE routine has been disabled. The SQL> startup ORACLE routine has been started. Total System Global Area 612368384 bytes Fixed Size 1332348 bytes Variable Size 187345796 bytes Database Buffers 419430400 bytes Redo Buffers 4259840 bytes Database load is complete. The database has been opened.
 

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.