ORA-00201: control file version 10.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home     
Search
     Members     Calendar     Who's On

Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Home » Oracle Forum » ORA - Oracle Database Error Codes - Search... » ORA-00000 Through ORA-09989 » ORA-00201: control file version 10.2.0.0.0...

ORA-00201: control file version 10.2.0.0.0... Expand / Collapse
Rate Topic
Display Mode
Topic Options
Message
Posted 2/22/2009 10:33:13 AM Post #87
Admin
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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,
Posted 6/15/2010 9:52:22 AM Post #365
Admin
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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?
Posted 6/15/2010 9:53:03 AM Post #366
Admin
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
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)
Posted 6/15/2010 9:54:06 AM Post #367
Admin
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

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.>>
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 2 (2 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:14am

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.088. 7 queries. Compression Disabled.