set SGA_MAX_size too large, can not startup database?
s9225Jul 16 2007 — edited Jul 17 2007Hi, buddy:
I have a problem a little urgent...
I set SGA_MAX_size too large(2.5G), so when I bounce the database, it can not startup (ORA-27102: out of memory, Linux Error: 12: Cannot allocate memory
Additional information: 1 Additional information: 2654219)
so buddy can tell me how could I reset the sga back to 1G, and restart up the database.
My os is linux.
thank you very much.