ORA-00225 : expected size string of controlfile differs from actual size string

Saturday, March 22nd, 2008

Cause : The expected size of the control file as stored in its header was different than the actual operating system file size. This usually indicates that the control file was corrupted.
Action : Restore a good copy of the control file.

Popularity: 8% [?]

ORA-00219 : required controlfile size string exceeds maximum allowable size string

Saturday, March 22nd, 2008

Cause : An invocation of CREATE DATABASE, CREATE CONTROLFILE, cfileCalcSizeList, or cfileCalcSizeArray was executed specifying a combination of parameters that would require the control file size in blocks to exceed the maximum allowable value.
Action : In the case of CREATE DATABASE or CREATE CONTROLFILE, use a different combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses. In the case of cfileCalcSizeList() or cfileCalcSizeArray(), use a different combination of record type counts.

Popularity: 10% [?]

ORA-00215 : must be at least one controlfile

Saturday, March 22nd, 2008

Cause : No control file is specified or the control file specified does not exist.
Action : Specify at least one valid control file and retry the operation.

Popularity: 9% [?]

ORA-00214 : controlfile ’string’ version string inconsistent with file ’string’ version string

Saturday, March 22nd, 2008

Cause : An inconsistent set of control files, datafiles, and redo log files was used.
Action : Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.

Popularity: 12% [?]

ORA-00213 : cannot reuse controlfile; old file size string, string required

Saturday, March 22nd, 2008

Cause : To reuse a control file, it must be the same size as the one previously used.
Action : 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.

Popularity: 20% [?]

ORA-00211 : controlfile does not match previous controlfiles

Saturday, March 22nd, 2008

Cause : A control file was specified that belongs to another database.
Action : Find and install the correct control file.

Popularity: 8% [?]

ORA-00210 : cannot open the specified controlfile

Saturday, March 22nd, 2008

Cause : Cannot open the control file.
Action : Check to make sure the control file exists and is not locked by some other program.

Popularity: 10% [?]

ORA-00209 : control file blocksize mismatch, check alert log for more info

Saturday, March 22nd, 2008

Cause : The block size in the control file header does not match the size specified in the DB_BLOCK_SIZE parameter.
Action : Reduce the block size to the amount specified in the message and try again.

Popularity: 23% [?]

ORA-00201 : controlfile version string incompatible with ORACLE version string

Friday, March 21st, 2008

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.

Popularity: 18% [?]

ORA-00200 : controlfile could not be created

Friday, March 21st, 2008

Cause : It was not possible to create the control file.
Action : Check that there is sufficient disk space and no conflicts in file names and try to create the control file again.

Popularity: 8% [?]

Close
E-mail It