ges resource dynamic 和 ges enqueues较高导致数据库宕机

最新推荐文章于 2025-07-16 17:01:48 发布

原创

最新推荐文章于 2025-07-16 17:01:48 发布 · 499 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#oracle

本文描述了一次Oracle RAC数据库因所有PDB处于MOUNT状态导致业务中断的故障。通过打开PDB并检查告警日志，发现ORACLE实例因内存不足引发ORA-29770错误。后续分析了AWR报告，确认为内存分配问题，并提供了补丁解决方案和临时配置调整建议。

数据库版本：
Oracle RAC 12.1.0.2
数据库架构
ODA

客户反应业务系统连不上数据库，登上数据库检查数据库状态，发现所有PDB均为MOUNT状态。

[oracle@node0 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Mon Jun 7 01:51:18 2021

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ALTH                         MOUNTED
         4 YDHEL                           MOUNTED
         5 MAALA                        MOUNTED
         6 TTECL                       MOUNTED
         7 DARE                         MOUNTED
         8 DOC                        MOUNTED
         9 BAAE                           MOUNTED
        10 EIEQ                           MOUNTED
        11 LILD                        MOUNTED
        12 NS                          MOUNTED

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        13 IAEG                            MOUNTED
        14 OGL                           MOUNTED
        15 EGEQB                          MOUNTED

先把pdb打开，让业务跑起来。


SQL> alter pluggable database all open;

Pluggable database altered.


SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ALTH                         READ WRITE
         4 YDHEL                           READ WRITE
         5 MAALA                        READ WRITE
         6 TTECL                       READ WRITE
         7 DARE                         READ WRITE
         8 DOC                        READ WRITE
         9 BAAE                           READ WRITE
        10 EIEQ                           READ WRITE
        11 LILD                        READ WRITE
        12 NS                          READ WRI

最低0.47元/天解锁文章