All posts by mpbod

ORA-00217: control file could not be resized for new record types

ORA-00217: control file could not be resized for new record types

ORA-00217: control file could not be resized for new record types
Cause: The control file was missing some new record types supported by this release. These record types are automatically added by resizing the contol file during mount. The resize has failed.
Action: Look in the alert log for the reason that the resize has failed. If indicated in the alert log, give the control file more space. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00216: control file could not be resized for migration from 8.0.2

ORA-00216: control file could not be resized for migration from 8.0.2

ORA-00216: control file could not be resized for migration from 8.0.2
Cause: The control file created by release 8.0.2 was missing some record types. These record types are automatically added by resizing the control file during mount. The resize has failed.
Action: Look in the alert log for the reason that the resize has failed. If indicated in the alert log, give the control file more space. Otherwise, use the CREATE CONTROLFILE script dumped to the trace file to create a new control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00215: must be at least one control file

ORA-00215: must be at least one control file

ORA-00215: must be at least one control file
Cause: No control file is specified or the control file specified does not exist.
Action: Specify at least one valid control file and retry the operation

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00214: control file ‘string’ version string inconsistent with file ‘string’ version string

ORA-00214: control file ‘string’ version string inconsistent with file ‘string’ version string

ORA-00214: control file ‘string’ version string inconsistent with file ‘string’ version string
Cause: An inconsistent set of control files, datafiles/logfiles, and redo files was used.
Action: Use a consistant set of control files, datafiles/logfiles, and redo log files. That is, all the files must be for the same database and from the same time period.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00213: cannot reuse control file; old file size string, string required

ORA-00213: cannot reuse control file; old file size string, string required

ORA-00213: cannot reuse control file; old file size string, string required
Cause: To reuse a control file, it must be the same size as the one previously used.
Action: Either do not specify REUSE, or specify a matching combination of MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES clauses in the CREATE DATABASE or CREATE CONTROLFILE statement.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00212: block size string below minimum required size of string bytes

ORA-00212: block size string below minimum required size of string bytes

ORA-00212: block size string below minimum required size of string bytes
Cause: The block size specified was too small. Space for the system overhead is required.
Action: Specify a larger block size and retry the operation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00211: control file does not match previous control files

ORA-00211: control file does not match previous control files

ORA-00211: control file does not match previous control files
Cause: A control file was specified that belongs to another database.
Action: Find and install the correct control file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00210: cannot open the specified control file

ORA-00210: cannot open the specified control file

ORA-00210: cannot open the specified control file
Cause: Cannot open the control file.
Action: Check to make sure the control file exists and is not locked by some other program.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00209: control file blocksize mismatch, check alert log for more info

ORA-00209: control file blocksize mismatch, check alert log for more info

ORA-00209: control file blocksize mismatch, check alert log for more info
Cause: The block size in the control file header does not match the size specified in the DB_BLOCK_SIZE parameter.
Action: Look at the alert log for more information.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00208: number of control file names exceeds limit of string

ORA-00208: number of control file names exceeds limit of string

ORA-00208: number of control file names exceeds limit of string
Cause: An attempt was made to use more control files than Oracle supports.
Action: Shut down Oracle. Reduce the number of control files specified in the CONTROL_FILES parameter in the initialization parameter file, and restart Oracle. Delete usused files.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/