Saturday, March 30, 2013

ORA-00212 Block Size String below Minimum Required Size of String Bytes

Error Code
ORA-00212

Description
Block size string below minimum required size of string bytes.

Cause
Possible cause of this error is, the block size specified was too small. Space for the system overhead is required.

Action
To fix this issue, specify a larger block size and retry the operation.

reference

ORA-00211 Control File does not Match Previous Control Files

Error Code
ORA-00211

Description
Control file does not match previous control files.

Cause
Possible cause of this error is, a control file was specified that belongs to another database.

Action
To fix this error, find and install the correct control file.

reference

ORA-00210 Cannot Open the Specified Control File

Error Code
ORA-00210

Description
Cannot open the specified control file.

Cause
Possible cause of this error is, cannot open the control file.

Action
To fix this issue, check to make sure the control file exists and is not locked by some other program.

reference

ORA-00209 Control File Blocksize Mismatch

Error Code
ORA-00209

Description
Control file blocksize mismatch, check alert log for more info.

Cause
Possible cause of this error is, the block size in the control file header does not match the size specified in the DB_BLOCK_SIZE parameter.

Action
To fix this issue, look at the alert log for more information.

reference

ORA-00208 Number of Control File Names Exceeds Limit of String

Error Code
ORA-00208

Description
Number of control file names exceeds limit of string.

Cause
Possible cause of this error is, an attempt was made to use more control files than Oracle supports.

Action
To fix this issue, 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.

reference