Today, installing Oracle10.2.0.4 on the Dell server's Redhat 6.4 and logging into the database with Sqlplus, you will receive the following prompt:
Map size mismatch; Abort:success, but the other functions are normal, just have this hint
Workaround:
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 the CPU that opens the need for hardware support, explaining 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, 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.
This article is from the "Small Fish Blog" blog, please be sure to keep this source http://395469372.blog.51cto.com/1150982/1730386
Oracle startup hint map size mismatch; Abort