Thursday, May 2, 2013

ORA-00238 Operation would Reuse a Filename that is Part of the Database

Error Code
ORA-00238

Description
Operation would reuse a filename that is part of the database.

Cause
Possible cause of this error is, the filename supplied as a parameter to the ALTER DATABASE BACKUP CONTROLFILE command or to cfileSetSnapshotName matches the name of a file that is currently part of the database.

Action
To fix this issue, retry the operation with a different filename.

reference

Wednesday, May 1, 2013

ORA-00237 Snapshot Operation Disallowed Control File Newly Created

Error Code
ORA-00237

Description
Snapshot operation disallowed, control file newly created.

Cause
Possible cause of this error is, an attempt to invoke cfileMakeAndUseSnapshot with a currently mounted control file that was newly created with CREATE CONTROLFILE was made.

Action
To fix this issue, mount a current control file and retry the operation.

reference

Tuesday, April 30, 2013

ORA-00236 Snapshot Operation Disallowed Mounted Control File is a Backup

Error Code
ORA-00236

Description
Snapshot operation disallowed, mounted control file is a backup.

Cause
Possible cause of this error is, attempting to invoke cfileSetSnapshotName, cfileMakeAndUseSnapshot, or cfileUseSnapshot when the currently mounted control file is a backup control file.

Action
To fix this issue, mount a current control file and retry the operation.

reference

ORA-00235 Control File Fixed Table Inconsistent due to Concurrent Update

Error Code
ORA-00235

Description
Control file fixed table inconsistent due to concurrent update.

Cause
Possible cause of this error is, concurrent update activity on a control file caused a query on a control file fixed table to read inconsistent information.

Action
To fix this issue, retry the operation.

reference

ORA-00234 Error in Identifying or Opening Snapshot or Copy Control File

Error Code
ORA-00234

Description
Error in identifying or opening snapshot or copy control file

Cause
Possible cause of this error is, 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
To fix this issue, re-create the snapshot or copy control file using cfileMakeAndUseSnapshot or ALTER DATABASE BACKUP CONTROLFILE, respectively.

reference