使用正则表达式导致的错误。
错误信息为:
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平台下的补丁来解决这个问题。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-749441/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/4227/viewspace-749441/