ORA-00235: control file fixed table inconsistent due to concurrent update
Cause: Concurrent update activity on a control file caused a query on a control file fixed table to read inconsistent information.
Action: Retry the operation.
Category Archives: ORA Database Error Messages
ORA-00234: error in identifying or opening snapshot or copy control file
ORA-00234: error in identifying or opening snapshot or copy control file
Cause: A snapshot or copy control file of the specified name could not be found or opened during an invocation of cfileUseSnapshot, cfileMakeAndUseSnapshot, or cfileUseCopy.
Action: Re-create the snapshot or copy control file using cfileMakeAndUseSnapshot or ALTER DATABASE BACKUP CONTROLFILE, respectively.
ORA-00233: copy control file is corrupt or unreadable
ORA-00233: copy control file is corrupt or unreadable
Cause: The specified copy control file was found to be corrupt or unreadable during an invocation of cfileUseCopy.
Action: Before retrying cfileUseCopy, use the ALTER DATABASE BACKUP CONTROLFILE command and specify the same filename that was specified for cfileUseCopy.
ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable
ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable
Cause: The snapshot control file was found to be nonexistent, corrupt, or unreadable during an invocation of cfileUseSnapshot.
Action: Call cfileMakeAndUseSnapshot again (or for the first time).
ORA-00231: snapshot control file has not been named
ORA-00231: snapshot control file has not been named
Cause: During an invocation of cfileMakeAndUseSnapshot or cfileUseSnapshot it was detected that no filename for the snapshot control file had previously been specified.
Action: Specify a name for the snapshot control file by calling cfileSetSnapshotName.
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
ORA-00230: operation disallowed: snapshot control file enqueue unavailable
Cause: The attempted operation cannot be executed at this time because another process currently holds the snapshot control file enqueue.
Action: Retry the operation after the concurrent operation that is holding the snapshot control file enqueue terminates.
ORA-00229: operation disallowed: already hold snapshot control file enqueue
ORA-00229: operation disallowed: already hold snapshot control file enqueue
Cause: The attempted operation cannot be executed at this time because this process currently holds the snapshot control file enqueue.
Action: Retry the operation after calling cfileUseCurrent to release the snapshot control file enqueue.
ORA-00228: length of alternate control file name exceeds maximum of string
ORA-00228: length of alternate control file name exceeds maximum of string
Cause: The specified filename, which was supplied as a parameter to cfileSetSnapshotName or cfileUseCopy, exceeds the maximum filename length for this operating system.
Action: Retry the operation with a shorter filename.
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.
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.