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

来源：互联网发布：淘宝假台湾回流紫砂壶编辑：程序博客网时间：2024/04/28 04:39

注：与本文有关的文章为：http://blog.csdn.net/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 = 0LICENSE_SESSIONS_WARNING = 0Initial number of CPU is 1Number of processor cores in the system is 8Number of processor sockets in the system is 2Shared memory segment for instance monitoring createdCELL 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 3Autotune 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 fixedNo Workarounds are available

0 0