I run an Oracle 10g database on windows 7 OS.
I have never had problems before starting the database and using it.
Today, as usual, when I tried to log in into SQL * PLUS, I am getting an
ERROR :
ORA-01033: ORACLE initialization or shutdown in progress
so i tried some ideas i got from another similar post, and here is what happened..
SQL> connect sys/manager as sysdba
Connected.
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 293601280 bytes
Fixed Size 1248600 bytes
Variable Size 75498152 bytes
Database Buffers 209715200 bytes
Redo Buffers 7139328 bytes
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL01.CTL'
version 11867 inconsistent with file
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\SCOTT\CONTROL03.CTL' version 11864
What should I do?
Any ideas ?
Thanks