Category Archives: ORA Database Error Messages

ORA-00225: expected size string of control file differs from actual size string

ORA-00225: expected size string of control file differs from actual size string

ORA-00225: expected size string of control file differs from actual size string
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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00224: control file resize attempted with illegal record type (string)

ORA-00224: control file resize attempted with illegal record type (string)

ORA-00224: control file resize attempted with illegal record type (string)
Cause: An attempt was made to expand or shrink the control file by calling cfileResizeSection using an invalid value for the RECORD_TYPE parameter.
Action: Use a value for the RECORD_TYPE parameter that specifies a valid record type other than type 0 (valid range is 1-16).

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00223: convert file is invalid or incorrect version

ORA-00223: convert file is invalid or incorrect version

ORA-00223: convert file is invalid or incorrect version
Cause: An Oracle7 to Oracle8 convert file contains invalid data or was created with an different version of the migration utility. This error can also be caused by incorrect ORACLE_HOME environment variable when ALTER DATABASE CONVERT command is issued.
Action: Use a correct version of the convert file or regenerate it with the migration utility. Make sure that the migration utility is the same version as the Oracle8 RDBMS executable and that the ORACLE_HOME environment variable is properly set.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00222: operation would reuse name of a currently mounted control file

ORA-00222: operation would reuse name of a currently mounted control file

ORA-00222: operation would reuse name of a currently mounted control file
Cause: The filename supplied as a parameter to the ALTER DATABASE BACKUP CONTROLFILE command or to cfileSetSnapshotName matches the name of the specified currently mounted control file.
Action: Retry the operation with a different filename.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00221: error on write to control file

ORA-00221: error on write to control file

ORA-00221: error on write to control file
Cause: An error occurred when writing to one or more of the control files.
Action: See accompanying messages.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00220: control file not mounted by first instance, check alert log for more info

ORA-00220: control file not mounted by first instance, check alert log for more info

ORA-00220: control file not mounted by first instance, check alert log for more info
Cause: The specified control file has a different mount ID than the other control files that are being mounted. This means that the first instance to mount the database did not use this control file.
Action: Find and install the correct control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00219: required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)

ORA-00219: required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)

ORA-00219: required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks)
Cause: An invocation of CREATE DATABASE or CREATE CONTROLFILE 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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00218: block size string of control file ‘string’ does not match DB_BLOCK_SIZE (string)

ORA-00218: block size string of control file ‘string’ does not match DB_BLOCK_SIZE (string)

ORA-00218: block size string of control file ‘string’ does not match DB_BLOCK_SIZE (string)
Cause: The block size as stored in the control file header is different from the value of the initialization parameter DB_BLOCK_SIZE. This might be due to an incorrect setting of DB_BLOCK_SIZE, or else might indicate that the control file has either been corrupted or belongs to a different database.
Action: Restore a good copy of the control file. If the control file is known to be clean set the DB_BLOCK_SIZE to match control file headers block size value.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00217: control file could not be resized for new record types

ORA-00217: control file could not be resized for new record types

ORA-00217: control file could not be resized for new record types
Cause: The control file was missing some new record types supported by this release. These record types are automatically added by resizing the contol file during mount. The resize has failed.
Action: Look in the alert log for the reason that the resize has failed. If indicated in the alert log, give the control file more space. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00216: control file could not be resized for migration from 8.0.2

ORA-00216: control file could not be resized for migration from 8.0.2

ORA-00216: control file could not be resized for migration from 8.0.2
Cause: The control file created by release 8.0.2 was missing some record types. These record types are automatically added by resizing the control file during mount. The resize has failed.
Action: Look in the alert log for the reason that the resize has failed. If indicated in the alert log, give the control file more space. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/