All posts by mpbod

ORA-00237: snapshot operation disallowed: control file newly created

ORA-00237: snapshot operation disallowed: control file newly created

ORA-00237: snapshot operation disallowed: control file newly created
Cause: An attempt to invoke cfileMakeAndUseSnapshot with a currently mounted control file that was newly created with CREATE CONTROLFILE was made.
Action: Mount a current control file and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00236: snapshot operation disallowed: mounted control file is a backup

ORA-00236: snapshot operation disallowed: mounted control file is a backup

ORA-00236: snapshot operation disallowed: mounted control file is a backup
Cause: Attempting to invoke cfileSetSnapshotName, cfileMakeAndUseSnapshot, or cfileUseSnapshot when the currently mounted control file is a backup control file.
Action: Mount a current control file and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00235: control file fixed table inconsistent due to concurrent update

ORA-00235: control file fixed table inconsistent due to concurrent update

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00234: error in identifying or opening snapshot or copy control file

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00233: copy control file is corrupt or unreadable

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00232: snapshot control file is nonexistent, corrupt, or unreadable

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00231: snapshot control file has not been named

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00230: operation disallowed: snapshot control file enqueue unavailable

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00229: operation disallowed: already hold snapshot control file enqueue

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00228: length of alternate control file name exceeds maximum of string

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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/