【翻译自mos文章】升级到11.2.0.4之后在alert日志中出现 NUMA 警告信息

Oracle数据库11.2.0.4升级后出现的NUMA警告信息解决方法

最新推荐文章于 2024-08-18 07:01:11 发布

翻译最新推荐文章于 2024-08-18 07:01:11 发布 · 2.6k 阅读

文章标签：

#11.2.0.4 #alert #numa

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

在将Oracle数据库升级至11.2.0.4后，可能会遇到关于NUMA的警告信息。文章详细解释了原因并提供了两种解决方案：应用补丁或升级到12.1版本，同时提供了详细的故障排查步骤。

注：与本文有关的文章为：http://blog.youkuaiyun.com/msdnchina/article/details/43763927

升级到11.2.0.4之后在alert日志中出现 NUMA 警告信息

翻译自mos文章：NUMA warning message appear after upgrade to 11.2.0.4 (文档 ID 1600824.1)1

适用于：
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

症状：
在升级到11.2.0.4之后，在database startup之后，下面的警告信息会生成：

Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 1
Number of processor cores in the system is 8
Number of processor sockets in the system is 2
Shared memory segment for instance monitoring created
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
    NUMA status: NUMA system w/ 2 process groups
    cellaffinity.ora status: cannot find affinity map at '/etc/oracle/cell/network-config/cellaffinity.ora' (see trace file for details)
CELL communication will use 1 IP group(s):
    Grp 0: 
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.

变化：
升级到11.2.0.4

原因：
默认情况下，在11.2中，NUMA是被关闭的，但是如果在你的os级别启用了NUMA，并且如果_enable_NUMA_support = FALSE 的话，Oracle 只会检测（detect）到NUMA 而不会使用NUMA。

这个在bugBug:17475024中讨论过。closed as duplicate of Bug:16613964 where alerts like below displayed on non-Exadata setup:

CELL IP affinity details:
    NUMA status: NUMA system w/ 2 process groups
    cellaffinity.ora status: cannot find affinity map at '...' (see trace file for details)
CELL communication will use 1 IP group(s):
    Grp 0:

解决方案：

- Apply Patch:16613964 if available for your DBVersion and Platform.

or Upgrade to 12.1 where the issus is fixed

No Workarounds are available