第三次 - ORA-07445: exception encountered: core dump [pfrinstr_BRNCNULL()+58]
alter 日志报警：Thu Apr 09 16:32:45 2015Exception
Errors in file /u01/app/oracle/diag/rdbms/sanguo/SANGUO/trace/SANGUO_ora_6859.trc (incident=122753):
ORA-07445: exception encountered: core dump []
Incident details in: /u01/app/oracle/diag/rdbms/sanguo/SANGUO/incident/incdir_122753/SANGUO_ora_6859_i122753.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Apr 09 16:33:09 2015
Dumping diagnostic data in directory=, requested by (instance=1, osid=6859), summary=.
Thu Apr 09 16:33:10 2015
Sweep : completed
Sweep : completedtrace文件在附件中。
这是我之前遇到的：应该同一个错误，但根源可能不同。
https://community.oracle.com/thread/2460154?tstart=0
http://t.askmaclean.com/thread-3494-1-1.html
这次没有 create or replace package 这个操作。
Dump continued from file: /u01/app/oracle/diag/rdbms/sanguo/SANGUO/trace/SANGUO_ora_6859.trc
ORA-07445: exception encountered: core dump []
11.2.0.2.0 + LINUX
flags: 0x0, count: 1]
Registers:
%rax: 0x00000000bf514bdc %rbx: 0x00002b7b92f03e78 %rcx: 0x00002b7b92efd950
%rdx: 0x00002b7b92f03ee8 %rdi: 0x00002b7b92f03e78 %rsi: 0x00000000bf514bd8
%rsp: 0x00007fff0be7bb50 %rbp: 0x00007fff0be7bb60 %r8: 0x0000035401040009
%r9: 0x0000000000000001 %r10: 0x00007fff0be7baf8 %r11: 0x00002b7b92d92c20
%r12: 0x00002b7b92f03ee8 %r13: 0x00002b7b92eef730 %r14: 0x00000000000085f0
%r15: 0x00002b7b92f03e78 %rip: 0x00000000091636c0 %efl: 0x0000000000010246
pfrinstr_BRNCNULL()+41 (0x91636af) mov %rax,-0x10(%rbp)
pfrinstr_BRNCNULL()+45 (0x91636b3) cmp $1,%r9d
pfrinstr_BRNCNULL()+49 (0x91636b7) jnz 0x916382a
pfrinstr_BRNCNULL()+55 (0x91636bd) mov (%rcx),%r8
> pfrinstr_BRNCNULL()+58 (0x91636c0) movzwl 0xa(%r8),%ecx
pfrinstr_BRNCNULL()+63 (0x91636c5) test $0x6,%cl
pfrinstr_BRNCNULL()+66 (0x91636c8) jnz 0x9163864
pfrinstr_BRNCNULL()+72 (0x91636ce) mov (%r8),%rcx
pfrinstr_BRNCNULL()+75 (0x91636d1) test %rcx,%rcx
*** 2015-04-09 16:32:46.037
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=frv4ksphxkx4k) -----
begin :1 := PKG_GATEWAY.unbind(:2, :3, :4);end;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x35cb643a8 114 package body ERATING_SWGLXH.PKG_OPTION
0x325e70ac0 594 package body ERATING_SWGLXH.PKG_GATEWAY
0x35b3c4f60 1 anonymous block
stack call
pfrrun=> pfrrun_no_tool=>pfrinstr_BRNCNULL
odm finding:
Hdr: 10065549 11.2.0.1 PLSQL 11.2.0.1 PRODID-11 PORTID-46
Abstract: ORA-3113 AND ORA-7445
*** 08/27/10 02:33 am ***
*** 08/27/10 02:33 am ***
BUG TYPE CHOSEN
===============
Code
*** 08/27/10 02:35 am ***
Customers application crashes with ORA-3113.
In the alert.log there is a ORA-7445: exception encountered: core dump
[Address not
mapped to object] []
Patch 9210925 for 11.2.0.1 is already applied.
Set "_disable_fast_validate"=TRUE does not help.
Problem isn't reproducible with a testcase.
After the crash customer recreates the failing package/procedure and it works
fine again for a while. This issue occurs with different procedures or
functions.
没有找到一个“confirm 为real bug"的bug note，就以往的案例来看：
1、考虑重建问题plSQL程序 即PKG_GATEWAY.unbind
2、尝试设置_disable_fast_validate=true
页:
[1]