Tuesday, November 3, 2009

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.
All Oracle errors in the blog can be found at: Oracle errors
All ESRI ArcSDE errors in the blog can found at:
ArcSDE Errors
Last updated: 2009-11-02 Monday


More Oracle DBA tips, please visit Oracle DBA Tips