Initial number of CPU is 40
Number of processor cores in the system is 20
Number of processor sockets in the system is 2
Could not use cellaffinity.ora (cannot find affinity map at ‘/etc/oracle/cell/network-config/cellaffinity.ora’)
Dumping configuration file ‘/etc/oracle/cell/network-config/cellaffinity.ora’:
Could not open ‘/etc/oracle/cell/network-config/cellaffinity.ora’
OS system dependent operation:open failed failed with status: 2
OS failure message: No such file or directory
failure occurred at: SlfFopen1
“Could not open ‘/etc/oracle/cell/network-config/cellaffinity.ora’”
# whoami # ls -l /etc/oracle/cell/network-config/cellaffinity.ora # ls -l $ORACLE_HOME/bin/oracle复制
评论
有用 1At start time on an 8-socket system, each database server generates a cellaffinity.ora configuration file. The cellaffinity.ora file resides in the /etc/oracle/cell/network-config directory, and must be readable by the Oracle Database software.
The cellaffinity.ora file contains a mapping between the NUMA node numbers and the IP address of the network interface card closest to each node. Oracle Database uses the file to select the closest network interface card when communicating with the storage servers, thereby optimizing performance. This file is only generated and used on an 8-socket system. On a 2-socket system, there is no performance to be gained in this manner, and no cellaffinity.ora file. The file is not intended to be directly edited with a text editor.
在8-socekt Oracle XD一体机环境中，该文件是用于NUMA和IP地址的映射，用于oracle访问cell 存储节点时优化访问性能。
评论 有用 0
