Oracle启动时提示mapsizemismatch;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.

网站题目：Oracle启动时提示mapsizemismatch;abort
路径分享：http://shouzuofang.com/article/igepgd.html