00200-00249: Control Files

Cause:	The control file cannot be created, usually because of insufficient disk storage or filename conflicts.

Action:	Check that there is sufficient disk space and no conflicts in filenames and try to create the control file again.

ORA-00201 control file version num incompatible with Oracle version num

Cause:	The control file was created by a different version of Oracle.

Action:	Either

• Restart with version of Oracle used to create the control file.

• Use the CREATE CONTROLFILE command to create a new control file that is compatible with this release.

Cause:	This message reports the name of the file involved in other messages.

Action:	See the associated messages for a description of the problem.

ORA-00203 using the wrong control files

Cause:	The mount ID in the control file is not the same as the mount ID in the control file used by the first instance to mount this database. The control files are for the same database but are not the same files. The most likely cause is that one instance is using a backup of the control file. If you want to use a backed up control file, you can recover using the USING BACKUP CONTROLFILE option.

Action:	Check that all instances are using the correct version of the control file.

ORA-00204 error in reading control file name block num, # blocks num

Cause:	A disk read-failure occurred while attempting to read the specified control file. The block location of the failure is given.

Action:	Check that the disk is online. If it is not, bring it online and shut down and restart Oracle. If the disk is online, then look for operating system reasons for Oracle's inability to read the disk or control file. Refer to the Oracle7 Server Administrator's Guide for information about recovering from the loss of a control file. See also your operating system-specific Oracle documentation.

ORA-00205 error in identifying control file name

Cause:	The system could not find a control file of the specified name and size.

Action:	Either

• Check that the proper control filename is referenced in the CONTROL_FILES initialization parameter in the initialization parameter file and try again.

• When using mirrored control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file with a new filename in the initialization parameter file.

Cause:	A disk write-failure occurred while attempting to write to the specified control file. The block location of the failure is given.

Action:	Check that the disk is online. If it is not, bring it online and shut down and restart Oracle. If the disk is online, then look for operating system reasons for Oracle's inability to write to the disk or control file. See the Oracle7 Server Administrator's Guide for information on recovering from the loss of a control file. See also your operating system-specific Oracle documentation.

ORA-00207 control files are not for the same database

Cause:	The database ID in the control file is not the same as the database ID in the control file used by the first instance to mount this database. The most likely cause is either that one of the mounts used the wrong control file or there are two databases with the same name.

Action:

Check that the control file is for the correct database and not an old version. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new filename in the initialization parameter file.

ORA-00208 number of control file names exceeds limit of num

Cause:	An attempt was made to use more control files than Oracle supports. The limit is given in the message.

Action:	Shut down Oracle, reduce the number of control filenames specified in the CONTROL_FILES parameter in the initialization parameter file, and restart Oracle. Delete unused files.

ORA-00209 block size num exceeds limit of num bytes

Cause:	A block size larger than that allowed by the operating system was specified.

Action:	Reduce the block size to the amount specified in the message and try again.

ORA-00210 cannot open control file name

Cause:	The system was unable to open a control file.

Action:	Check that the control file exists, that the storage device is online, and that the file is not locked by some other program and try again. Also, check to see that the operating system limit on the number of open files per process has not been exceeded.

When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the parameter from the initialization parameter file referencing the control filename indicated in the message and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file using a new filename in the initialization parameter file.

Cause:	The specified control file is from another database.

Action:

Locate and specify the correct control file for this database, then retry the operation. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file, create another copy of the control file, and include the new filename in the initialization parameter file.

ORA-00212 block size num below minimum required size of num bytes

Cause:	The specified block size is too small. Additional space is needed for system overhead.

Action:	Specify a larger block size and retry the operation.

ORA-00213 cannot reuse control file name; old file size num, num required

Cause:	To reuse a control file, it must be the same size as the previous one used.

Action:	In the CREATE DATABASE statement, do not specify REUSE.

ORA-00214 control file name version num inconsistent with file name version num

Cause:	An inconsistent set of control files, datafiles, and redo log files was used.

Action:	Use a consistent set of control files, datafiles, and redo log files. That is, all the files must be for the same database and from the same time period.

ORA-00215 must be at least one control file

Cause:	No control file was specified, or the control file specified does not exist.

Action:	Specify at least one valid control file and retry the operation.

ORA-00216 unable to determine physical block size for control file name

Cause:	An error occurred while determining the physical block size of the specified control file.

Action:	Check the accompanying message stack for more detailed information.

ORA-00217 control file name physical block size num inconsistent with num

Cause:	The physical block size of the operating system is inconsistent with the block size of the control file.

Action:

The system will not operate with invalid control files. Either restore a valid control file or recreate the database. When using multiplexed control files, that is, more than one control file is referenced in the initialization parameter file, remove the control filename listed in the message from the initialization parameter file and restart the instance. If the message does not recur, remove the problem control file from the initialization parameter file and create another copy of the control file with a new filename in the initialization parameter file.

ORA-00218 control file name was created with block size num now is num

Cause:	The physical block size, stored in the control file header, was different in physical block size returned by the O/S. This usually indicates that the control file was corrupted.

Action:	Restore a good copy of the control file.

For more information about control files and recovery, see the index entries on "control files," "control files, backing up," "control files, recovery and" in Oracle7 Server Concepts.

Cause:	The CREATE DATABASE statement specified a combination of initialization parameters that results in the control file exceeding the internal maximum size.

Action:	You must recreate the database. In the CREATE DATABASE statement, use a value less than the maximum permissible value for clauses such as MAXDATAFILES and MAXLOGFILES as described in the Oracle7 Server Administrator's Guide.

ORA-00220 control file name not mounted by first instance

Cause:	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:	Find and use the correct control file.

ORA-00221 error on write to control file

Cause:	An error occurred when writing to one or more of the control files.

Action:	See accompanying messages.

ORA-00222 control file may not be queried using dispatcher

Cause:	Attempted to use client process connected to dispatcher. This is not allowed for queries to control file fixed tables due to the memory requirements.

Action:	Connect directly to the instance, then execute the query.

ORA-00223 conversion datafile is invalid or incorrect version

Cause:	A Version 6 to Oracle7 conversion datafile contains invalid data or was created with an old version of the migration utility.

Action:	Regenerate the conversion file with the correct version of the migration utility or use the correct file for converting the database.

ORA-00224 the specified file is not a control file

Cause:	The file specified in the initialization parameter file is not a control file.

Action:	Edit the initialization parameter file and specify the correct control filename.

ORA-00225 expected size num of controlfile name differs from actual size num

Cause:	The expected size of the control file as stored in its header was different than the actual operating system file size of the control file. This usually indicates that the control file was corrupted.

Action:	Restore a good copy of the control file.

For more information about control files and recovery, see the index entries on "control files," "control files, backing up," "control files, recovery and" in Oracle7 Server Concepts.