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
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