Error Code
ORA-00223
Description
Convert file is invalid or incorrect version
Cause
Possible cause of this error is, an Oracle7 to Oracle8 convert file contains invalid data or was created with an different version of the migration utility. This error can also be caused by incorrect ORACLE_HOME environment variable when ALTER DATABASE CONVERT command is issued.
Action
To fix this issue, use a correct version of the convert file or regenerate it with the migration utility. Make sure that the migration utility is the same version as the Oracle8 RDBMS executable and that the ORACLE_HOME environment variable is properly set.
reference
Programming Tutorials on XHTML, CSS, JavaScript, JQuery, JSON, Python, Django, Amazon Web Services, ASP.NET, Web Forms, and SQL
Sunday, April 21, 2013
ORA-00222 Operation would Reuse Name of a Currently Mounted control file
Error Code
ORA-00222
Description
Operation would reuse name of a currently mounted control file
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 the specified currently mounted control file.
Action
To fix this issue, Retry the operation with a different filename.
reference
ORA-00222
Description
Operation would reuse name of a currently mounted control file
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 the specified currently mounted control file.
Action
To fix this issue, Retry the operation with a different filename.
reference
ORA-00221 Error on Write to Control File
Error Code
ORA-00221
Description
Error on write to control file
Cause
Possible cause of this error is, an error occurred when writing to one or more of the control files.
Action
To fix this issue, see accompanying messages.
reference
ORA-00221
Description
Error on write to control file
Cause
Possible cause of this error is, an error occurred when writing to one or more of the control files.
Action
To fix this issue, see accompanying messages.
reference
ORA-00220 Control File not Mounted by First Instance
Error Code
ORA-00220
Description
Control File not mounted by first instance, check alert log for more info
Cause
Possible cause of this error is, the specified control file has a different mount ID than the other control files that are being mounted. This means that the first instance to mount the database did not use this control file.
Action
To fix this issue, find and install the correct control file.
reference
ORA-00220
Description
Control File not mounted by first instance, check alert log for more info
Cause
Possible cause of this error is, the specified control file has a different mount ID than the other control files that are being mounted. This means that the first instance to mount the database did not use this control file.
Action
To fix this issue, find and install the correct control file.
reference
ORA-00219 Required Control File Size Exceeds Maximum Allowable Size
Error Code
ORA-00219
Description
Required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks).
Cause
Possible cause of this error is, an invocation of CREATE DATABASE or CREATE CONTROLFILE was executed specifying a combination of parameters that would require the control file size in blocks to exceed the maximum allowable value.
Action
To fix this issue, in the case of CREATE DATABASE or CREATE CONTROLFILE, use a different combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses.
reference
ORA-00219
Description
Required control file size (string logical blocks) exceeds maximum allowable size (string logical blocks).
Cause
Possible cause of this error is, an invocation of CREATE DATABASE or CREATE CONTROLFILE was executed specifying a combination of parameters that would require the control file size in blocks to exceed the maximum allowable value.
Action
To fix this issue, in the case of CREATE DATABASE or CREATE CONTROLFILE, use a different combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses.
reference
Subscribe to:
Comments (Atom)