All posts by mpbod

ORA-00227: corrupt block detected in control file: (block string, # blocks string)

ORA-00227: corrupt block detected in control file: (block string, # blocks string)

ORA-00227: corrupt block detected in control file: (block string, # blocks string)
Cause: A block header corruption or checksum error was detected on reading the control file.
Action: Use the CREATE CONTROLFILE or RECOVER DATABASE USING BACKUP CONTROLFILE command.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00226: operation disallowed while alternate control file open

ORA-00226: operation disallowed while alternate control file open

ORA-00226: operation disallowed while alternate control file open
Cause: The attempted operation could not be executed at this time because this process had an alternate control file open for fixed table access.
Action: Retry the operation after calling cfileUseCurrent.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

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/