oracle numa map size mismatch,Oracle启动时提示map size mismatch; abort

Oracle启动时提示map size mismatch; abort

发布时间：2020-06-26 13:35:09

来源：51CTO

阅读：1370

作者：会说话的鱼

今天在DELL服务器的Redhat 6.4上安装Oracle10.2.0.4,用sqlplus 登陆数据库，会出现如下的提示：

map size mismatch; abort: Success，不过其他的功能都正常，只是有这个提示

解决方法：

alter system set "_enable_NUMA_optimization"= false scope=spfile;

alter system set "_db_block_numa"=1 scope=spfile;

SQL>shutdown immediate

SQL>startup

col name for a40

col value for a40

col describ for a40

set linesize 130

NUMA是CPU的一种技术，开启需要硬件的支持，关于这两个参数的解释：

SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describ

FROM SYS.x$ksppi x, SYS.x$ksppcv y

WHERE x.inst_id = USERENV ('Instance')

AND y.inst_id = USERENV ('Instance')

AND x.indx = y.indx

AND upper(x.ksppinm) like '%NUMA%';

NAME  VALUE   DESCRIB

---------------------------------------- ---------------------------------------- ----------------------------------------

_rm_numa_sched_enable  FALSE   Is Resource Manager (RM) related NUMA sc

heduled policy enabled

_NUMA_pool_size   Not specified   aggregate size in bytes of NUMA pool

_enable_NUMA_optimizationTRUE   Enable NUMA specific optimizations

_NUMA_instance_mapping  Not specified   Set of nodes that this instance should r

un on

_rm_numa_simulation_pgs   0   number of PGs for numa simulation in res

ource manager

NAME  VALUE   DESCRIB

---------------------------------------- ---------------------------------------- ----------------------------------------

_rm_numa_simulation_cpus  0   number of cpus per PG for numa simulatio

n in resource manager

_db_block_numa2   Number of NUMA nodes

7 rows selected.