How to fix the error ORA-00381: cannot use both new and old parameters for buffer cache size specification?

In this post, you’ll learn more about the Oracle ErrorORA-00381: cannot use both new and old parameters for buffer cache size specification with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00381: cannot use both new and old parameters for buffer cache size specification

Reason for the Error ORA-00381: cannot use both new and old parameters for buffer cache size specification

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), db_cache_advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_recycle }. This is illegal.

How to fix the Error ORA-00381: cannot use both new and old parameters for buffer cache size specification ?

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

Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don’t specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters.