使用正则表达式导致的错误。
错误信息为:
Fri DEC 16 15:37:51 2011 Exception [TYPE: SIGSEGV, Invalid permissions FOR mapped object] [ADDR:0x2AFEA42A4000] [PC:0x9016222, lxsCntChar()+210] [flags: 0x0, COUNT: 1] Errors IN file /u01/app/oracle/diag/rdbms/orcl/ods1/trace/orcl1_ora_12150.trc (incident=41375): ORA-07445: exception encountered: core dump [lxsCntChar()+210] [SIGSEGV] [ADDR:0x2AFEA42A4000] [PC:0x9016222] [Invalid permissions FOR mapped object] [] Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_41375/orcl1_ora_12150_i41375.trc USE ADRCI OR Support Workbench TO package the incident. See Note 411.1 at My Oracle Support FOR error AND packaging details. |
数据库的版本为11.2.0.2 RAC on Exadata v2,查询MOS发现,这个问题和正则表达式有关。详细文档为Bug 14173447 – ORA-7445 [lxsCntChar] under lxregmatch using REGEXP_REPLACE [ID 14173447.8],这个问题确认影响的版本为11.2.0.3,Oracle计划在11.2.0.4和12.1中解决该错误。
除了通过补丁集解决该问题外,Oracle还提供了HP-UX和Linux X86-64平台下的补丁来解决这个问题。