Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00201: control file version 10.2.0.4.0 incompatible with ORACLE version

717168Sep 25 2009 — edited Sep 28 2009
Hi,

I have upgraded the database from 9.2.0.4 to 10.2.0.4 and for some time compatible parameter remained 9.2.0.0.
Recently i have changed compatible parameter to 10.2.0.4.Now I could open the database with pfile but when I am trying to open database with spfile then I am getting following error:--

SQL> startup
ORACLE instance started.

Total System Global Area 1694498816 bytes
Fixed Size 1299532 bytes
Variable Size 1342180276 bytes
Database Buffers 343932928 bytes
Redo Buffers 7086080 bytes
ORA-00201: control file version 10.2.0.4.0 incompatible with ORACLE version
9.2.0.0.0
ORA-00202: control file: 'C:\ORACLE9I\ORADATA\UPGRD9I\CONTROL01.CTL'

OS=Windowxp 32 bit
Database version=10.2.0.4 32 bit.

Please share your experience with me.


MK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2009
Added on Sep 25 2009
#database, #database-upgrade
6 comments
3,245 views