环境:CentOS 6.2 + Oracle 11.2.0.3 (非rac)
问题描述:数据库每天22点左右报错ora-07445,,之后几天就是每天两到三次的出现此错误,在MOS上查了,是补丁号为13901133的bug,上个星期在测试库上测试了此补丁,成功打上,需停机修复此bug。提前申请停机时刻和所需时间,此补丁只有96K,分分钟的时间就可以打上,所以很快,建议业务低峰期申请停机,将此打上,在此之前强烈建议做个全备,并在测试库上做反安装测试,以防补丁安装失败。
alert信息:
Sun Jan 13 10:06:23 2013
Archived Log entry 39857 added for thread 1 sequence 22185 ID 0xb9d6e315 dest 1:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x2F8AC2B, pmux_obj_xlate()+793] [flags: 0x0, count: 1]
Errors in file /u/oracle/diag/rdbms/cw/cw/trace/cw_j002_23920.trc (incident=192946):
ORA-07445: 出现异常错误: 核心转储 [pmux_obj_xlate()+793] [SIGSEGV] [ADDR:0x0] [PC:0x2F8AC2B] [Address not mapped to object] []
Incident details in: /u/oracle/diag/rdbms/cw/cw/incident/incdir_192946/cw_j002_23920_i192946.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
溢出错误:
下载补丁13901133,解压到/home/oracle目录下
[oracle@dac-vm02 ~]$ cd 13901133/
查看之前安装的产品和补丁信息