SGA_MAX_SIZE limit for Oracle 10g 32BIT on Linux Red Hat
Hi all,
We have a 32 Bit 10g database installed on Linux Redhat. The server has 4GB physical memory and only runs Oracle. Our SGA_MAX_SIZE parameter was set to 1.4GB, we need to increase this to 2GB. However when we tried to do restart the instance after the change, we got the following error:
ORA-27123: unable to attach to shared memory segment
Now i have checked the kernel parameters and these seem to be set fine, so i am wondering if i am hitting a limit for a 32 bit Oracle install?
Any advice will be much appreciated.
Thanks in advance,
Chucks