cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set

Solution ID:ORA-00825

Type: Oracle

Cause

SGA_TARGET or MEMORY_TARGET set with DB_BLOCK_BUFFERS set.

Actions

Do not set SGA_TARGET, MEMORY_TARGET or use new cache parameters, and do not use DB_BLOCK_BUFFERS which is an old cache parameter.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e0.htm


https://community.oracle.com/message/3278300


https://community.oracle.com/message/4551958


Browse all solutions to database errors from Oracle, MS SQL, or MySQL