ErrorCode
ORA-00231
Description
Snapshot control file has not been named.
Cause
Possible cause of this error is, during an invocation of cfileMakeAndUseSnapshot or cfileUseSnapshot it was detected that no filename for the snapshot control file had previously been specified.
Action
To fix this issue, specify a name for the snapshot control file by calling cfileSetSnapshotName.
reference
Monday, April 29, 2013
ORA-00230 Operation Disallowed Snapshot Control File Enqueue Unavailable
Error Code
ORA-00230
Description
Operation disallowed, snapshot control file enqueue unavailable.
Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because another process currently holds the snapshot control file enqueue.
Action
To fix this issue, retry the operation after the concurrent operation that is holding the snapshot control file enqueue terminates.
reference
ORA-00230
Description
Operation disallowed, snapshot control file enqueue unavailable.
Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because another process currently holds the snapshot control file enqueue.
Action
To fix this issue, retry the operation after the concurrent operation that is holding the snapshot control file enqueue terminates.
reference
ORA-00229 Operation Disallowed Already Hold Snapshot Control File Enqueue
Error Code
ORA-00229
Description
Operation disallowed already hold snapshot control file enqueue.
Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because this process currently holds the snapshot control file enqueue.
Action
To fix this issue, retry the operation after calling cfileUseCurrent to release the snapshot control file enqueue.
reference
ORA-00229
Description
Operation disallowed already hold snapshot control file enqueue.
Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because this process currently holds the snapshot control file enqueue.
Action
To fix this issue, retry the operation after calling cfileUseCurrent to release the snapshot control file enqueue.
reference
ORA-00228 Length of Alternate Control File Name Exceeds Maximum of String
Error Code
ORA-00228
Description
Length of alternate control file name exceeds maximum of string.
Cause
Possible cause of this error is, the specified filename, which was supplied as a parameter to cfileSetSnapshotName or cfileUseCopy, exceeds the maximum filename length for this operating system.
Action
To fix this issue, retry the operation with a shorter filename.
reference
ORA-00228
Description
Length of alternate control file name exceeds maximum of string.
Cause
Possible cause of this error is, the specified filename, which was supplied as a parameter to cfileSetSnapshotName or cfileUseCopy, exceeds the maximum filename length for this operating system.
Action
To fix this issue, retry the operation with a shorter filename.
reference
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-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
Subscribe to:
Posts (Atom)