In this post, you’ll learn more about the Oracle ErrorORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set
Reason for the Error ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set
SGA_TARGET or MEMORY_TARGET set with DB_BLOCK_BUFFERS set.
How to fix the Error ORA-00825: cannot set DB_BLOCK_BUFFERS if SGA_TARGET or MEMORY_TARGET is set ?
You can fix this error in Oracle by following the below steps
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.