1.75G SGA size limit on Solaris2.6 and Oracle8.0.5

1.75G SGA size limit on Solaris2.6 and Oracle8.0.5

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by 'Michael Revelette' on August 21, 2001 at 11:33:28 EST:

It appears we are hitting a 1.75G SGA limit on our 32-bit Solaris2.6 OS. The system has over 6G of memory, we are using ISM and have SHMMAX set at 4294967294 bytes. When we try to increase the SGA to something beyond 1.75G, we get this error:
ORA-27123
"unable to attach to shared memory segment"
// *Cause: shmat() call failed
// *Action: check permissions on segment, contact Oracle support

Some documentation I have seen suggests setting sgabeg and relinking the Oracle kernel but this appears to be risky.
Any additional info or suggestions on this would be appreciated.

Follow Ups:

shmmax too low Kenneth 17:19:28 9/12/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : It appears we are hitting a 1.75G SGA limit on our 32-bit Solaris2.6 OS. The system has over 6G of memory, we are using ISM and have SHMMAX set at 4294967294 bytes. When we try to increase the SGA to something beyond 1.75G, we get this error: : ORA-27123 : "unable to attach to shared memory segment" : // Cause: shmat() call failed : // Action: check permissions on segment, contact Oracle support : Some documentation I have seen suggests setting sgabeg and relinking the Oracle kernel but this appears to be risky. : Any additional info or suggestions on this would be appreciated.