温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Oracle启动时提示map size mismatch; abort

发布时间:2020-06-26 13:35:09 来源:网络 阅读:1537 作者:会说话的鱼 栏目:关系型数据库

  今天在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.


向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI