一篇ORA-4031处理服务文档
背景: **保险核心业务系统数据库使用Oracle 10.2.0.5 版本 RAC(Real Application Cluster)集群,集群构建在IBM Aix系统上,包含两个节点:【node1,node2】。 在较长一段时间内,node2会每间隔20天左右,出现ORA-04031错误,导致该节点数据库系统不再可用,需重启该节点上Oracle 实例方能解决问题。 ORA-04031错误解释: 04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")"// *Cause: More shared memory is needed than was allocated in the shared// pool or Streams pool.// *Action: If the shared pool is out of memory, either use the// DBMS_SHARED_POOL package to pin large