I am getting the following error while starting the sqlplus (I am using Oracle XE 11.2.0
)
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0
So, I did the following..
SQLPLUS> CONN AS sysdba
and then..
SQLPLUS> alter database mount
I am getting the following error for the above command.
alter database mount
*
ERROR at line 1:
ORA-00227: corrupt block detected in control file: (block 3, # blocks 1)
ORA-00202: control file: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\CONTROL.DBF'
I have the following files along with CONTROL.DBF in the same folder.
CONTROL.DBF
SYSAUX.DBF
SYSTEM.DBF
TEMP.DBF
UNDOTBS1.DBF
USERS.DBF
I also tried disk check on the C:\ drive, and Windows said it repaired the CONTROL.DBF
file but still, I am getting the same error.
Thanks in advance. Hope you will reply as soon as possible.
show parameter control