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-24035: AQ agent string is not a subscriber for queue string

1 Answers  


ORA-00222: operation would reuse name of a currently mounted controlfile

1 Answers  


ORA-29367: object string does not exist

1 Answers  


LPX-00408: right parenthesis missing in the XSL file

1 Answers  


PCC-00073: Cursor is declared but never OPENed at line number in file string.

1 Answers  






LPX-00402: invalid axisname in the XSL file

1 Answers  


ORA-30659: too many locations specified for external table

1 Answers  


ORA-34359: (MXDSS11) string appears twice in the alias list.

1 Answers  


ORA-16038: log string sequence# string cannot be archived

4 Answers  


ORA-13863: Statistics aggregation for service(module/action) string is not enabled

1 Answers  


EXP-00084: Unexpected DbmsJava error number at step number

1 Answers  


TNS-12234: TNS:Redirect to destination

1 Answers  


Categories