FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-00000 Through ORA-09989 / ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0 / Latest Posts

RE: ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0

Admin — Tue, 15 Jun 2010 09:54:06 GMT

ora error code ORA-00201

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

Cause: The control file was created by incompatible software.

Action: Either restart with a compatible software release or use CREATE CONTROLFILE to create a new control file that is compatible with this release.

Example:

Cloning database using dbca gives ora-00201 controlfile version incompatible:

ORA-00201: controlfile version 10.1.0.4.0 incompatible with ORACLE version 10.1.0.2.0
ORA-00202: controlfile 'D:\ORACLE\PRODUCT\10.1.0\ADMIN\SMARTX\CREATE\TEMPCONTROL.CTL

Reason:

The COMPATIBLE initialization parameter enables or disables the use of features in the database that affect file format on disk. The default value for the COMPATIBLE parameter is the release number of the most recent major release. You may use the alert.log to verify the correct setting. Please look for the most recent successful startup to locate the COMPATIBLE= line and use that value. In this case , change compatible to 10.1.0.4.

RE: ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0

Admin — Tue, 15 Jun 2010 09:53:03 GMT

SQL> create pfile from spfile;
SQL> shutdown
SQL> !vi <pfile> and change compatible
SQL> startup nomount pfile=...
SQL> create spfile from pfile;
SQL> shutdown
SQL> startup (connected as SYS)

RE: ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0

Admin — Tue, 15 Jun 2010 09:52:22 GMT

Oracle Version: 10.1.0.2.0
Operating System: Windows Server 2003

i made a mistake by changing the parametrer COMPATIBLE='9.2.0' in oracle version 10.1.0.2.0

ALTER SYSTEM SET COMPATIBLE='9.2.0' SCOPE=SPFILE;
after restarting DB SERVER, i m getting the following error
SQL> conn sys/gateway@testdb as sysdba
Connected.

SQL> conn scott/tiger@testdb
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

Warning: You are no longer connected to ORACLE.

SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00201: controlfile version 10.0.0.0.0 incompatible with ORACLE version
9.2.0.0.0
ORA-00202: controlfile: 'D:\ORACLE\ORADATA\TESTDB\CONTROL01.CTL'

i think i have to recreate spfile by first starting the DB by using pfile

Can anybody give me some suggestions for that?

ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0

Admin — Sun, 22 Feb 2009 10:33:13 GMT

ORA-00201 ora error when starting up database. Here is possible solution.

SQL> startup
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size 2084264 bytes
Variable Size 805306968 bytes
Database Buffers 754974720 bytes
Redo Buffers 14692352 bytes
ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0
ORA-00202: control file: '/u01/genesis/oradata/control01.dbf'

Most likely you started this db after upgrade or patch install . The compatible parameter needs to be updated so that it reflects what the control file got upgraded to.

Although it can be different, your best bet is to correct it by updating your pfile/spfile.

00201, 00000, "controlfile version %s incompatible with ORACLE version %s"
// *Cause: The controlfile was created by incompatible software.
// *Action: Either restart with a compatible software release or use
// CREATE CONTROLFILE to create a new controlfile that is
// compatible with this release.

Some helpful steps:

SQL> shutdown immediate;
ORA-01507: database not mounted

ORACLE instance shut down.
SQL> create pfile='/tmp/genesisprod.ora' from spfile;

At this point update the parameter compatible in this init file and then recreate your spfile:

#sqlplus '/ as sysdba'

SQL*Plus: Release 10.2.0.4.0 - Production on Sun Feb 22 09:16:53 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Connected to an idle instance.

SQL>create spfile='/opt/dbms/oracle/product/ora10204_64/dbs/spfilegenisisprod.ora' from pfile='/tmp/genesisprod.ora';

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size 2084264 bytes
Variable Size 805306968 bytes
Database Buffers 754974720 bytes
Redo Buffers 14692352 bytes
Database mounted.
Database opened.
SQL> exit

Hope this helps.

Thanks,