Saturday, October 24, 2020

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

 

Control file version 11.2.0.1.0 incompatible with ORACLE version 10.2.0.3.0

 

SQL> startup;

ORACLE instance started.

Total System Global Area 2004340736 bytes

Fixed Size                  2256544 bytes

Variable Size            1006633312 bytes

Database Buffers          973078528 bytes

Redo Buffers               22372352 bytes

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

10.2.0.0.0

ORA-00202: control file: 'D:\ORACLE\GPQ\ORIGLOGA\CNTRL\CNTRLGPQ.DBF'


SQL> show parameter compatible

NAME                                 TYPE

------------------------------------ ---------------------------------

VALUE

------------------------------

compatible                           string

10.2.0

SQL> alter system set compatible='11.2.0.0.0' scope=spfile;

System altered.

SQL> shut immediate;

ORA-01507: database not mounted


ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 2004340736 bytes

Fixed Size                  2256544 bytes

Variable Size            1006633312 bytes

Database Buffers          973078528 bytes

Redo Buffers               22372352 bytes

Database mounted.

 

SQL> show parameter compatible

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      11.2.0.0.0

SQL>

No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts