Monday, April 29, 2013

ORA-00227 Corrupt Block Detected in Control File

Error Code
ORA-00227

Description
Corrupt block detected in control file: (block string, # blocks string).

Cause
Possible cause of this error is, a block header corruption or checksum error was detected on reading the control file.

Action
To fix this issue, use the CREATE CONTROLFILE or RECOVER DATABASE USING BACKUP CONTROLFILE command.

reference

ORA-00226 Operation Disallowed while Alternate Control File Open

Error Code
ORA-00226

Description
Operation disallowed while alternate control file open.

Cause
Possible cause of this error is, the attempted operation could not be executed at this time because this process had an alternate control file open for fixed table access.

Action
To fix this issue, retry the operation after calling cfileUseCurrent.

reference

ORA-00225 Expected Size String of Control File Differs from Actual Size String

Error Code
ORA-00225

Description
Expected size string of control file differs from actual size string

Cause
Possible cause of this error is, 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
To fix this issue, restore a good copy of the control file.

reference

ORA-00224 Control File Resize Attempted with illegal Record Type

Error Code
ORA-00224

Description
Control file resize attempted with illegal record type (string).

Cause
Possible cause of this error is, an attempt was made to expand or shrink the control file by calling cfileResizeSection using an invalid value for the RECORD_TYPE parameter.

Action
To fix this issue, use a value for the RECORD_TYPE parameter that specifies a valid record type other than type 0 (valid range is 1-16).

reference

Sunday, April 21, 2013

ORA-00223 Convert File is Invalid or Incorrect Version

Error Code
ORA-00223

Description
Convert file is invalid or incorrect version

Cause
Possible cause of this error is, 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
To fix this issue, 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.

reference