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
Monday, April 29, 2013
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
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
Subscribe to:
Posts (Atom)