Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

PLS-00216: NUMBER precision constraint must be in range (1 .. 38)

1 Answers  


ORA-38448: Indexing predicates with "string" operator is not supported.

1 Answers  


NID-00138: Block verification failed for datafile string (number)

1 Answers  


ORA-12001: cannot create log: table 'string' already has a trigger

1 Answers  


O2F-00314: AS expected but not seen in the INTYPE file

1 Answers  






ORA-19031: XML element or attribute string does not match any in type string.string

1 Answers  


ORA-30488: argument should be a function of expressions in PARTITION BY

1 Answers  


TNS-02514: Invalid packet received

1 Answers  


PCC-02203: found end of file when not expected

1 Answers  


QSM-02050: subquery using the ALL clause in mv

1 Answers  


ORA-16812: apply service not running on the apply instance recorded by the broker

1 Answers  


ORA-02155: invalid DEFAULT tablespace identifier

2 Answers  






Categories