Applies to:
________________________________________________________________________________
Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Symptoms:
________________________________________________________________________________
The following error is encountered
in the alert log and trace file:
ORA-07445: exception encountered:
core dump [msqcol()+754] [SIGSEGV] [ADDR:0x10] [PC:0x201AE46] [Address not
mapped to object] []
The trace file shows that the
process is executing the following SQL:
----- Beginning of Customized
Incident Dump(s) -----
Exception [type: SIGSEGV, Address
not mapped to object] [ADDR:0x10] [PC:0x20472CE, msqcol()+754] [flags: 0x0,
count: 1]
Registers:
%rax: 0x00007ff29ade6160 %rbx:
0x00007ff29ac21db8 %rcx: 0x0000000000000004%rdx: 0x00007ff29b17e4c0 %rdi: 0x00007ff29b0253c6 %rsi: 0x00007ff29b1da458
%rsp: 0x00007fff70cc25a0 %rbp: 0x00007fff70cc2600 %r8: 0x0000000000000001
%r9: 0x0000000031305f2e %r10: 0x0000000000000b33 %r11: 0x00000000047edc2f
%r12: 0x0000000000000000 %r13: 0x00007fff70cc2d00 %r14: 0x00007ff29b1ba440
%r15: 0x000000000000001e %rip: 0x00000000020472ce %efl: 0x0000000000010246
msqcol()+741 (0x20472c1) mov (%r12),%r12
msqcol()+745 (0x20472c5) add $1,%r15d
msqcol()+749 (0x20472c9) test %r12,%r12
msqcol()+752 (0x20472cc) jne 0x20472ba
> msqcol()+754 (0x20472ce) mov 0x10(%r12),%rcx
msqcol()+759 (0x20472d3) test %rcx,%rcx
msqcol()+762 (0x20472d6) je 0x20472e1
msqcol()+764 (0x20472d8) cmp $0x2710,%r15d
msqcol()+771 (0x20472df) jl 0x2047302
----- Current SQL Statement for this session -----
/* SQL Analyze(653,1) */ SELECT..
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xc2e4f7e0 11816 package body SYS.DBMS_SQLTUNE_INTERNAL
0xbe3ddc78 7 SYS.WRI$_ADV_SQLTUNE
0xdd80bdb0 587 package body SYS.PRVT_ADVISOR
0xdd80bdb0 2655 package body SYS.PRVT_ADVISOR
0xde4c8808 241 package body SYS.DBMS_ADVISOR
0xbe42a300 821 package body SYS.DBMS_SQLTUNE
0xbe622760 4 anonymous block
The 'Call Stack' section of the
trace file includes functions like:
... msqcol msqopnws
msqsellst msqsel kkzgctdrv
kkzgctcb kkzpcbk opikkzprs1 ...
________________________________________________________________________________
ORA-7445 [msqcol] can occur when there are redaction rules, but redaction is set to none, and the table object is being accessed via a view.
The cause of the issue has been identified in unpublished bug 14078030.
The issue is fixed in
- 12.1.0.1 (Base release)
- 11.2.0.4 (Server Patch Set)
To solve the issue, use any of below alternatives
Upgrade to 11.2.0.4 or higher
- OR -
Apply interim Patch 14078030 if available for your platform and Oracle release.
References:
_________________________________________________________________________________
Oracle (Doc ID 1662219.1)
