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-24302: host connection in use by another thread

1 Answers  


PLS-00154: An object type may have only 1 MAP or 1 ORDER method.

1 Answers  


PLS-00737: LIBRARY file specification exceeds the maximum allowed length

1 Answers  


TNS-01302: nr err code: number

1 Answers  


SQL*Loader-00902: Error opening cursor: [number]

1 Answers  


ORA-16614: object has an ancestor that is disabled

1 Answers  


ORA-01609: log string is the current log for thread string - cannot drop members

1 Answers  


ORA-14270: table is not partitioned by Range or Hash or List method

1 Answers  


RMAN-08551: recovering datafilecopy fno=string name=string

1 Answers  


DRG-11204: user filter command is too long

1 Answers  


ORA-36722: (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.

1 Answers  


ORA-36991: (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.

1 Answers  


Categories