暂无图片
oracle 启动数据库nomount都起不来,trc日志如下,alert日志没有明显报错
我来答
分享
伤城
2021-05-06
oracle 启动数据库nomount都起不来,trc日志如下,alert日志没有明显报错

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

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
weizhao.zhang (anbob)

“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 

暂无图片 评论
暂无图片 有用 1
伤城

cellaffinity.ora这个文件是干啥的?我不知道oracle启动到nomount还需要这个参数啊

暂无图片 评论
暂无图片 有用 0
weizhao.zhang (anbob)

At 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
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏