Tuesday, April 30, 2013

ORA-00233 Copy Control File is Corrupt or Unreadable

Error Code
ORA-00233

Description
Copy control file is corrupt or unreadable.

Cause
Possible cause of this error is, the specified copy control file was found to be corrupt or unreadable during an invocation of cfileUseCopy.

Action
To fix this issue, before retrying cfileUseCopy, use the ALTER DATABASE BACKUP CONTROLFILE command and specify the same filename that was specified for cfileUseCopy.

reference

ORA-00232 Snapshot Control File is Nonexistent Corrupt or Unreadable

Error Code
ORA-00232

Description
Snapshot control file is nonexistent, corrupt, or unreadable.

Cause
Possible cause of this error is, the snapshot control file was found to be nonexistent, corrupt, or unreadable during an invocation of cfileUseSnapshot.

Action
To fix this issue, call cfileMakeAndUseSnapshot again or for the first time.

reference

Monday, April 29, 2013

ORA-00231 Snapshot Control File has not been Named

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

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-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