How to fix the error ORA-00385: cannot enable Very Large Memory with new buffer cache parameters?

In this post, you’ll learn more about the Oracle ErrorORA-00385: cannot enable Very Large Memory with new buffer cache parameters with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

Reason for the Error ORA-00385: cannot enable Very Large Memory with new buffer cache parameters

User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32) } AND use_indirect_data_buffers is set to TRUE. This is illegal.

How to fix the Error ORA-00385: cannot enable Very Large Memory with new buffer cache parameters ?

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

Very Large Memory can only be enabled with the old (pre-Oracle_8.2) parameters.