ORA-00218: block size string of controlfile 'string' does
not match DB_BLOCK_SIZE (string)



ORA-00218: block size string of controlfile 'string' does not match DB_BLOCK_SIZE (string..

Answer / guest

Cause: The block size as stored in the controlfile header is
different from the value of the initialization parameter
DB_BLOCK_SIZE. This might be due to an incorrect setting of
DB_BLOCK_SIZE, or else might indicate that the controlfile
has either been corrupted or belongs to a different database.

Action: Restore a good copy of the controlfile. If the
controlfile is known to be clean set the DB_BLOCK_SIZE to
match controlfile headers block size value.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.

1 Answers  


NNL-00800: Query requests received: number

1 Answers  


ORA-24071: cannot perform operation string, queue table string is being migrated

1 Answers  


ORA-01164: MAXLOGFILES may not exceed string

1 Answers  


ORA-19574: output filename must be specified

1 Answers  






ORA-28176: incorrect certificate version

1 Answers  


ORA-28557: unknown string for database link to non-Oracle system

1 Answers  


ORA-01699: tablespace 'string' is being imported for point in time recovery

1 Answers  


NNL-00986: Reforwarded requests expired: number

1 Answers  


ORA-23448: duplicate user parameter value

1 Answers  


ORA-32313: REFRESH FAST of "string"."string" unsupported after PMOPs

1 Answers  


ORA-07618: $IDTOASC failed translating a secrecy level

1 Answers  


Categories