Hello,
I have read many forums on oracle.com & other sites for this error but, none of them helped me out.
ORACLE 10g R2
Windows Server 2003 32bit
My system has 4GB of RAM ( Hardware - 2 Ram's of 2GB in 2 slots on motherboard). The size of SGA is 584MB. Now I want to increase the size of SGA to 2GB, so i fired the command...
SQL>Shutdown immediate;
SQL>Startup Mount;
SQL>Alter system set sga_max_size=2G scope=spfile;
SQL>Startup open;
*ORA-27100:shared memory realm already exists*
I have tried all the solutions on the other forums i see but none of them worked for me.
Solution i tried -
+1) Restart the oracle service.+
+2) Restart the server machine.+
+3) Start the instance manually by command prompt.+
+4) Tried to create new spfile & startup with the new spfile.+
+.... many more.+
I want to understand the whole scenario of this problem. Why such kind of error occurs , as i have resized SGA of many system before in my carrier.
What is the perfect solution for the error ???