The alert log will contain specific information on actions to
take to rectify the condition causing the ORA-00824 error.
Let's assume the alert.log contains the following message:
Cannot set
sga_target with db_block_buffers set
The obvious answer is to not set db_block_buffers when
using sga_target. Enabling automatic SGA Management
by setting sga_target>0 in the same init.ora file
when using the obsolete db_block_buffers parameter, pretty
much guarantees an ORA-00824 error.
Either set sga_target=0 to disable SGA Management or
remove the db_block_buffer paramenter from your spfile.
Since the db_block_buffer parameter is obsolete, it makes
sense to remove it. Attempting to edit the spfile directly
with a text editor can cause a corruption issue. To safely
remove the db_block_buffer parameter, do the following:
- Create a pfile from the spfile
- Remove the line containing the
db_block_buffer parameter using a text editor
- Create a new spfile from the updated pfile
- Startup the database
The ORA-00824 should no longer be an issue.
