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-15133: instance recovery required for diskgroup string

1 Answers  


TNS-00298: Request to Navigator: string

1 Answers  


ORA-06518: PL/SQL: Probe version string incompatible with version string

1 Answers  


ORA-07282: sksaprd: string overflow.

1 Answers  


ORA-28672: UPDATE BLOCK REFERENCES may not be used on a global index

1 Answers  






ORA-01135: file string accessed for DML/query is offline

1 Answers  


ORA-37035: (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.

1 Answers  


DRG-10598: invalid parallel operation

1 Answers  


ORA-22607: image handle already generated

1 Answers  


PLS-00108: declarative units must be a single variable declaration

1 Answers  


ORA-36997: (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.

1 Answers  


ORA-28023: must revoke grants of this role to other user(s) first

1 Answers  


Categories