ORA-07445: exception encountered: core dump [kkslpli()+199] [SIGSEGV] [ADDR:0x2B5BEC7F5EA0] [PC:0x1E

1 查看告警日志

 

Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x2B5748DC1EA0] [PC:0x1E7D119, kkslpli()+199] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/dms/dms1/trace/dms1_ora_22697.trc  (incident=1080449):
ORA-07445: exception encountered: core dump [kkslpli()+199] [SIGSEGV] [ADDR:0x2B5748DC1EA0] [PC:0x1E7D119] [Invalid permissions for mapped object] []
Incident details in: /u01/app/oracle/diag/rdbms/dms/dms1/incident/incdir_1080449/dms1_ora_22697_i1080449.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Nov 11 11:10:05 2013
Dumping diagnostic data in directory=[cdmp_20131111111005], requested by (instance=1, osid=22697), summary=[incident=1080449].
Mon Nov 11 11:10:05 2013
Sweep [inc][1080449]: completed

 

2 查看文件/u01/app/oracle/diag/rdbms/dms/dms1/incident/incdir_1080449/dms1_ora_22697_i1080449.trc内容

 

Dump file /u01/app/oracle/diag/rdbms/dms/dms1/incident/incdir_1080449/dms1_ora_22697_i1080449.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/RAC11g
System name:    Linux
Node name:      dmsdb1
Release:        2.6.18-274.el5
Version:        #1 SMP Fri Jul 8 17:36:59 EDT 2011
Machine:        x86_64
Instance name: dms1
Redo thread mounted by this instance: 1
Oracle process number: 56
Unix process pid: 22697, image: oracle@dmsdb1 (TNS V1-V3)

*** 2013-11-11 11:10:04.335
*** SESSION ID:(5710.36527) 2013-11-11 11:10:04.335
*** CLIENT ID:() 2013-11-11 11:10:04.335
*** SERVICE NAME:(SYS$USERS) 2013-11-11 11:10:04.335
*** MODULE NAME:(rman@dmsdb1 (TNS V1-V3)) 2013-11-11 11:10:04.335
*** ACTION NAME:(0000001 FINISHED70) 2013-11-11 11:10:04.335
 
Dump continued from file: /u01/app/oracle/diag/rdbms/dms/dms1/trace/dms1_ora_22697.trc
ORA-07445: exception encountered: core dump [kkslpli()+199] [SIGSEGV] [ADDR:0x2B5748DC1EA0] [PC:0x1E7D119] [Invalid permissions for
mapped object] []

========= Dump for incident 1080449 (ORA 7445 [kkslpli()+199]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x2B5748DC1EA0] [PC:0x1E7D119, kkslpli()+199] [flags: 0x0, co
unt: 1]
Registers:
%rax: 0x000000075cdec8e0 %rbx: 0x0000000000000017 %rcx: 0x0000000000000026
%rdx: 0x000000075cdec8e0 %rdi: 0x00002b5748cc1f20 %rsi: 0x0000000000000012
%rsp: 0x00007fff5a8870c0 %rbp: 0x00007fff5a887100  %r8: 0x00000000000fff80
 %r9: 0x0000000000000016 %r10: 0x0000000000000000 %r11: 0x0000000000000000
%r12: 0x00000007b4ced5f0 %r13: 0x000000000000002a %r14: 0x0000000000000016
%r15: 0x00002b5748cc2378 %rip: 0x0000000001e7d119 %efl: 0x0000000000010206
  kkslpli()+182 (0x1e7d108) shl $0x4,%r8
  kkslpli()+186 (0x1e7d10c) mov 0x128(%r15),%rdi
  kkslpli()+193 (0x1e7d113) mov 0x4(%rdx),%esi
  kkslpli()+196 (0x1e7d116) add $1,%ebx
> kkslpli()+199 (0x1e7d119) mov %esi,(%rdi,%r8)
  kkslpli()+203 (0x1e7d11d) movzwl %bx,%r9d
  kkslpli()+207 (0x1e7d121) cmp %r9d,%ecx
  kkslpli()+210 (0x1e7d124) jle 0x1e7d1a4
  kkslpli()+212 (0x1e7d126) test %rdx,%rdx

*** 2013-11-11 11:10:04.337
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=8ync3szayz89f) -----
select db.version_time, db.controlfile_change#, db.controlfile_sequence#, dbinc.resetlogs_time, df.last_recid, tf.last_recid, ts.las
t_recid, rl.last_recid, rm.last_recid, dc.last_recid, al.last_recid, bp.last_recid, do.last_recid, offr.last_recid, pc.last_recid, b
s.last_recid, ldbinc.resetlogs_change#, ldbinc.resetlogs_time, ic.last_recid, rt.last_recid, grsp.last_recid, nrsp.last_recid, bcr.l
ast_recid, decode(dc.records_used, :"SYS_B_00", :"SYS_B_01", dc.last_recid - dc.records_used + :"SYS_B_02"), decode(al.records_used,
 :"SYS_B_03", :"SYS_B_04", al.last_recid - al.records_used + :"SYS_B_05"), decode(bp.records_used, :"SYS_B_06", :"SYS_B_07", bp.last
_recid - bp.records_used + :"SYS_B_08"), decode(bs.records_used, :"SYS_B_09", :"SYS_B_10", bs.last_recid - bs.records_used + :"SYS_B
_11"), decode(do.records_used, :"SYS_B_12", :"SYS_B_13", do.last_recid - do.records_used + :"SYS_B_14"), decode(offr.records_used, :
"SYS_B_15", :"SYS_B_16", offr.last_recid - offr.records_used + :"SYS_B_17"), decode(pc.records_used, :"SYS_B_18", :"SYS_B_19", pc.la
st_recid - pc.records_used + :"SYS_B_20")into   :vertime, :cfscn, :cfseq, :rltime, :dfhwm, :tfhwm, :tshwm, :rlhwm, :rmhwm, :dchwm, :
alhwm, :bphwm, :dohwm, :offrhwm, :pchwm, :bshwm, :lrstscn, :lrsttime, :ichwm, :rthwm, :grsphwm, :nrsphwm, :bcrhwm, :dclwm, :allwm, :
bplwm, :bslwm, :dolwm, :offrlwm, :pclwm from   v$database db, v$controlfile_record_section df, v$controlfile_record_section tf, v$co
ntrolfile_record_section ts, v$controlfile_record_section rt, v$controlfile_record_section rl, v$controlfile_record_section rm, v$co
ntrolfile_record_section dc, v$controlfile_record_section al, v$controlfile_record_section bp, v$controlfile_record_section do, v$co
ntrolfile_record_section offr, v$controlfile_record_section pc, v$controlfile_record_section bs, v$controlfile_record_section ic, v$
controlfile_record_section grsp, v$controlfile_record_section nrsp, v$controlfile_record_section bcr, v$database_incarnation dbinc,
v$database_incarnation ldbinc where df.type   = :"SYS_B_21" and   tf.type   = :"SYS_B_22" and   ts.type   = :"SYS_B_23" and   rt.typ
e   = :"SYS_B_24" and   rl.type   = :"SYS_B_25" and   rm.type   = :"SYS_B_26" and   dc.type   = :"SYS_B_27" and   al.type   = :"SYS_
B_28" and   bp.type   = :"SYS_B_29" and   do.type   = :"SYS_B_30" and   offr.type = :"SYS_B_31" and   pc.type   = :"SYS_B_32" and  
bs.type   = :"SYS_B_33" and   ic.type   = :"SYS_B_34" and   grsp.type = :"SYS_B_35" and   nrsp.type = :"SYS_B_36" and   bcr.type  =
:"SYS_B_37" and   dbinc.incarnation#=db.recovery_target_incarnation# and   ldbinc.incarnation#=db.last_open_incarnation#

----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------

 

 

3 解决方案

        metalink并没有查看到有此解决方案，大家有遇到过这种情况吗？？分享下

 

  现在处理设置 了游标参数cursor_sharing为exact,观察