How to fix the Oracle error ORA-01162: block size string in file header does not match configured block sizes?

In this post, you’ll learn more about the Oracle ErrorORA-01162: block size string in file header does not match configured block sizes with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01162: block size string in file header does not match configured block sizes

Reason for the Error ORA-01162: block size string in file header does not match configured block sizes

CREATE CONTROLFILE discovered that the block size for this file is incompatible with any of the configured cache blocksizes in the INIT.ORA file.

How to fix the Error ORA-01162: block size string in file header does not match configured block sizes ?

You can fix this error in Oracle by following the below steps

Configure the appropriate cache for this block size using one of the various (db_2k_cache_size, db_4k_cache_size, db_8k_cache_size, db_16k_cache_size, db_32K_cache_size) parameters.