dbaplus Community

Oct 21, 2015 · Databases

Why Oracle RAC Queries Fail with ORA-04030 on AIX: The Hidden Shell Limits Issue

An Oracle RAC 11g installation on AIX failed intermittent queries with ORA‑04030 errors, and a deep dive revealed that missing shell limits for the grid user capped process memory at 128 MB, causing PGA allocation failures despite ample system resources.