Saturday, March 30, 2013

ORA-00215 Must be at Least one Control File

Error Code
ORA-00215

Description
Must be at least one control file.

Cause
Possible cause of this error is, no control file is specified or the control file specified does not exist.

Action
To fix this issue, specify at least one valid control file and retry the operation.

reference

ORA-00214 Control file String Version String Inconsistent

Error Code
ORA-00214

Description
Control file 'string' version string inconsistent with file 'string' version string.

Cause
Possible cause of this error is, an inconsistent set of control files, datafiles/logfiles, and redo files was used.

Action
To fix this issue, use a consistant set of control files, datafiles/logfiles, and redo log files. That is, all the files must be for the same database and from the same time period.

reference

ORA-00213 Cannot Reuse Control File

Error Code
ORA-00213

Description
Cannot reuse control file; old file size string, string required.

Cause
Possible cause of this error is,to reuse a control file, it must be the same size as the one previously used.

Action
To fix this issue, either do not specify REUSE, or specify a matching combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses in the CREATE DATABASE or CREATE CONTROLFILE statement.

reference

ORA-00212 Block Size String below Minimum Required Size of String Bytes

Error Code
ORA-00212

Description
Block size string below minimum required size of string bytes.

Cause
Possible cause of this error is, the block size specified was too small. Space for the system overhead is required.

Action
To fix this issue, specify a larger block size and retry the operation.

reference

ORA-00211 Control File does not Match Previous Control Files

Error Code
ORA-00211

Description
Control file does not match previous control files.

Cause
Possible cause of this error is, a control file was specified that belongs to another database.

Action
To fix this error, find and install the correct control file.

reference