Login prompt ORA-01033 after Oracle10.2.0.1.0 accidentally deleted data file

Oracle accidentally deleted the data file after the connection login ERROR: ORA-01033: ORACLEinitializationorshutdowninprogress

Oracle accidentally deleted the data file after the connection login: ERROR: ORA-01033: ORACLE initialization or shutdown in progress

After Oracle accidentally deleted the data file, the following error occurs during connection and login:

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Solution:

First, Log On As a dba user.

SQL> conn sys/orcl as sysdba;

If you cannot log on here, the prompt is: ORA-12505: TNS: The Listener currently cannot recognize the SID in the connection Descriptor (dbd error: OCIServerAttach)

You may have modified E: \ oracle \ oracle10.2.0 \ NETWORK \ ADMIN \ listener. ora to add a sid listener, as shown below:

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = orcl ))
(ADDRESS = (PROTOCOL = TCP) (HOST = xujj-PC) (PORT = 1521 ))
)
)

Then run conn sys/orcl as sysdba;

1. Shut down the database:

SQL> shutdown abort;

2. Load the database

SQL> startup mount;

3. Set the data file to offline

SQL> alter database datafile 'e: \ oracle \ oradata \ orcl \ PHMS-DATA1.dbf 'offline drop

ORA-01516: a non-existent log file, data file, or temporary file "E: \ oracle \ oradata \ orcl \ PHMS-DATA1.dbf"

4. Open the database

SQL> alter database open;

ORA-01157: unable to identify/lock Data File 5-see DBWR trace file
ORA-01110: Data File 5: 'e: \ oracle \ oradata \ orcl \ PHMS-DATA1.dbf'

5. Create a 5 Data File

SQL> alter database create datafile 5; -- the execution result creates an E: \ oracle \ oradata \ orcl \ PHMS-DATA1.dbf, but is only offline.

6. Set Data File 5 to offline

SQL> alter database datafile 5 offline drop

7. Open the database

SQL> alter database open;

OK

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

,