Tuesday, April 30, 2013

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

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