千家信息网

Oracle启动时提示map size mismatch; abort

发表于:2025-01-20 作者:千家信息网编辑
千家信息网最后更新 2025年01月20日,今天在DELL服务器的Redhat 6.4上安装Oracle10.2.0.4,用sqlplus 登陆数据库,会出现如下的提示:map size mismatch; abort: Success,不过其
千家信息网最后更新 2025年01月20日Oracle启动时提示map size mismatch; abort

今天在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_optimization TRUE 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_numa 2 Number of NUMA nodes

7 rows selected.


0