Prompt map size mismatch; abort when Oracle starts

Shulou Source: shulou.com Published: 2022-06-01 15:18:12 11月08日 Update

Today, when you install Oracle10.2.0.4 on Redhat 6.4 of the DELL server and log in to the database with sqlplus, the following prompt will appear:

Map size mismatch; abort: Success, but all other functions are normal, except for this hint

Solution:

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 is a technology of CPU. Hardware support is required to enable it. Explain these two parameters:

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.