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-13417: null or invalid layerNumber for get functions

1 Answers  


NZE-29049: Unknown record

1 Answers  


NZE-29140: Cannot create certificate object.

1 Answers  


ORA-24905: invalid recepient protocol attribute passed into OCI call

1 Answers  


ORA-12464: invalid characters in label component string

1 Answers  






ORA-02223: invalid OPTIMAL storage option value

1 Answers  


NNO-00267: warning: configuration database contains no data for server "string"

1 Answers  


ORA-12045: invalid ALTER MATERIALIZED VIEW LOG option

1 Answers  


ORA-00326: log begins at change string, need earlier change string

1 Answers  


TNS-00535: Failed to send or receive disconnect message

1 Answers  


PLS-00233: function name used as an exception name in when clause

1 Answers  


PCC-00054: Expected End-of-Statement at column number in line number of file string

1 Answers  


Categories