Q

Why am I getting the ORA-00381 error when initializing the parameter?

An Oracle user asks why they are getting the ORA-00381 error when initializing the parameter.

I am initializing the parameter db_keep_cache_sizing. After modifying the value while restarting my database, an error is occurring: ORA-00381: cannot use both new and old parameters for buffer cache size specification. Why am I getting this error?
The old parameters to size the buffer cache are:

DB_BLOCK_BUFFERS, BUFFER_POOL_KEEP, and BUFFER_POOL_RECYCLE

The new parameters to size the buffer cache components are:

DB_CACHE_SIZE, DB_KEEP_CACHE_SIZE, and DB_RECYCLE_CACHE_SIZE

You cannot mix and match these parameters. I would bet that you set DB_KEEP_CACHE_SIZE and also have DB_BLOCK_BUFFERS set. As the ORA-381 error states, you cannot use the old parameters with the new ones. So, change DB_BLOCK_BUFFERS to DB_CACHE_SIZE (but keep in mind that the old parm denotes the number of blocks, and the new parm denotes the number of bytes, so you will have to perform some conversion here).

This was first published in May 2008

Dig deeper on Oracle database administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close