Today I got an issue from a DBA as they were unable to increase SGA_MAX_SIZE in SQL Oracle – then they were suspecting the issue is from Windows OS (Windows Server 2003).
Below Error they were getting while increase SGA_MAX_SIZE in SQL Oracle
SQL> ALTER SYSTEM SET SGA_MAX_SIZE=1400M;
ALTER SYSTEM SET SGA_MAX_SIZE=1400M *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
Let me go though you How to increase SGA_MAX_SIZE in SQL Oracle?
You need to login to SQL from CLI
Now you need run Show SGA
Now you need to show parameter spfile
After that create pfile from spfile;
Now you need to alter system set sga_max_size=20m scope=spfile;
Ok Now shutdown immediate;
Increase the Oracle SGA_MAX_SIZE setting in your pfile that you created from your spfile. Then in SQL*Plus start up the database using that pfile as follows.
Then re-create your spfile