oracle asm实例修改db_cache_size参数和shared_pool_size触发oracle bug问题处理总结

1 问题描述Su - oracleExport ORACLE_SID=+ASMSqlplus “/as sysdba”Alter system set db_cache_size=100M scope=spfile直接报ORA-03113通信错误查看后台日志，报错如下:ORA-07445: exception encountered: core dump [kcbw_resize_handle_error+0114] [SIGSEGV] [Invalid permissions for mapped object] [0x00000053A] [] []2 处理过程查看trace文件，对应的报错如下:ORA-07445: exception encountered: core dump [kcbw_resize_handle_error+0114] [SIGSEGV] [Invalid permissions for mapped object] [0x00000053A] [] []通过查metalink文档，确认为bug bug号为4702771:文档介绍如下:Unable To Change The Asm Parameter Db_cache_size [ID 840817.1] --------------------------------------------------------------------------------修改时间 06-MAR-2012 类型 PROBLEM 状态 ARCHIVED In this DocumentSymptomsCauseSolutionReferences--------------------------------------------------------------------------------Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.4This problem can occur on any platform.SymptomsASM crashes when attempted to modify the parameter db_cache_size.Below errors are seen in the Alert log.Tue May 5 18:12:18 2009 ALTER SYSTEM SET shared_pool_size='148M' SCOPE=SPFILE; Tue May 5 18:12:31 2009 Errors in file /opt/oracle/admin/+ASM/udump/+asm1_ora_848068.trc: ORA-07445: exception encountered: core dump [kcbw_resize_handle_error+0114] [SIGSEGV] [Invalid permissions for mapped object] [0x00000053A] [] [] Errors in file /ade/xxliu_102v2/oracle/rdbms/log/hive2_mman_22953.trc: ORA-600: internal error code, arguments: [kmgs_pre_process_request_2], [6], [0], [6], [3], [0x2D355780], [], [] CauseThe issues are being discussed in bug 6276084 and Unpublished bug 4702771SolutionThe Unpublished bug 4702771 is still being worked upon by Dev team. Hence the below Workaround needs to be followed.** Create Pfile from the existing Spfile . ** Modify the value for the Db_cache_size as per requirement. ** Restart the database. ** Recreate the Spfile from the pfile created in the above step. ReferencesBUG:6276084 - ORA-7445[KCBW_CHECK_RESIZE_ERRORS] ON RESIZING ASM CACHE SIZE WITH SCOPE=SPFILE 解决方法:Create pfile from spfile;Vi init+ASM.ora添加db_cache_size=100MStartup pfile=init+ASM.oraShow parameter db_cache_size 确认是否修改成功Create spfile from pfileShutdown immediateStartup 3 总结Oracle 10.2.0.4和oracle 10.2.0.5版本直接在asm实例修改db_cache_size参数和shared_pool_size会触发oracle bug,必须手工添加到pfile参数文件的方式才生效,大家要注意。