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
Programming Tutorials on XHTML, CSS, JavaScript, JQuery, JSON, Python, Django, Amazon Web Services, ASP.NET, Web Forms, and SQL
Monday, April 29, 2013
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-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-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
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
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
Subscribe to:
Posts (Atom)