ORA-00824: cannot set sga_target due to existing internal settings,
Hi all,
I have Oracle RAC 3 nodes with ASM recently i did command in node 1 the command is
alter system set db_block_buffers = 10000 scope =spfile;
after restart the node 1 i got the following error
ORA-00824: cannot set sga_target due to existing internal settings
after search in google i found the solution like
1. create pfile from spfile
2. update pfile as text and remove db_block_buffers
3. startup database from pfile
4. create spfile='location the spfile ASM' from pfile
then i tray to startup database but still give me same error but when i started it from pfile its work fine
please help me for this situation