Max SGA limit on Oracle 9.2.0.8 on Win Server 2003 SP2 (32 bit)
650217Sep 11 2008 — edited Sep 11 2008I am trying to increase the total SGA to 4Gb on a Oracle 9.2.0.8 instance on Win Server 2003, SP2 32 bit version. Is that possible? I have tried to find something on google and metalink but could not find any post answering my question.
In my attempts:
I made over 4 to 5 attempts each time trying one additional step as explained below. On issuing a startup command, each time I get the following error and the instance would not start.
ORA-27100: shared memory realm already exists
1) I changed the sga_max_size in the spfile to 4GB using
*"alter system set sga_max_size=4294967296 scope=spfile"*
& successfully shutdown the instance. It would not restart and I got ORA-27100.
2) I stopped and re-started the Oracle Windows service using Task Manager but no luck and I saw the same error.
3) I tried rebooting the server but that did not help either and I got same error.
Each time I have to start the instance with the init ORA file (pfile) and recreate the spfile to restore the old settings.
Any links or suggestions?