ORA-07445: : תktspsrch_reset()+20] [SIGSEGV] [ADDR:0x2B5F4663AA68] [PC:0x11...

zilong198738

版本centos5.8+11.2.0.3
alterlog报错如下:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B5F4663AA68] [PC:0x111F076, ktspsrch_reset()+20] [flags: 0x0, count: 1]
Errors in file /oracle/diag/rdbms/dyfdb1/dyfdb1/trace/dyfdb1_ora_24886.trc  (incident=53561):
ORA-07445: : תktspsrch_reset()+20] [SIGSEGV] [ADDR:0x2B5F4663AA68] [PC:0x111F076] [Address not mapped to object] []
Incident details in: /oracle/diag/rdbms/dyfdb1/dyfdb1/incident/incdir_53561/dyfdb1_ora_24886_i53561.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Thu Feb 12 22:24:59 2015
Dumping diagnostic data in directory=[cdmp_20150212222459], requested by (instance=1, osid=24886), summary=[incident=53561].
Thu Feb 12 22:24:59 2015
Sweep [inc][53561]: completed
Sweep [inc2][53561]: completed
Thu Feb 12 22:25:09 2015
Error 3113 trapped in 2PC on transaction 3.17.7938. Cleaning up.
Error stack returned to user:
ORA-03113: ͨ

            ORA-02063: ine ( DL_POSP)

/oracle/diag/rdbms/dyfdb1/dyfdb1/incident/incdir_53561/dyfdb1_ora_24886_i53561.trc内容如下:

[oracle@dyfdb1 trace]$
[oracle@dyfdb1 trace]$ more /oracle/diag/rdbms/dyfdb1/dyfdb1/incident/incdir_53562/dyfdb1_ora_25525_i53562.trc
Dump file /oracle/diag/rdbms/dyfdb1/dyfdb1/incident/incdir_53562/dyfdb1_ora_25525_i53562.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/product/11.2.3
System name:    Linux
Node name:      dyfdb1
Release:        2.6.18-308.el5
Version:        #1 SMP Tue Feb 21 20:06:06 EST 2012
Machine:        x86_64
Instance name: dyfdb1
Redo thread mounted by this instance: 1
Oracle process number: 295
Unix process pid: 25525, image: oracle@dyfdb1


*** 2015-02-12 22:31:04.698
*** SESSION ID:(1380.47764) 2015-02-12 22:31:04.698
*** CLIENT ID:() 2015-02-12 22:31:04.698
*** SERVICE NAME:(dyfdb1) 2015-02-12 22:31:04.698
*** MODULE NAME:(oracle@dyfdb1 (TNS V1-V3)) 2015-02-12 22:31:04.698
*** ACTION NAME:() 2015-02-12 22:31:04.698

Dump continued from file: /oracle/diag/rdbms/dyfdb1/dyfdb1/trace/dyfdb1_ora_25525.trc
ORA-07445: : תktspsrch_reset()+20] [SIGSEGV] [ADDR:0x2B6BDD4E4058] [PC:0x111F076] [Address not mapped to object] []

========= Dump for incident 53562 (ORA 7445 [ktspsrch_reset()+20]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B6BDD4E4058] [PC:0x111F076, ktspsrch_reset()+20] [flags: 0x0, count: 1]
Registers:
%rax: 0x0000000000000000 %rbx: 0x00000004d5e3d9c0 %rcx: 0x00002b6bdd4e4058
%rdx: 0x0000000000000000 %rdi: 0x00002b6bdd4e4058 %rsi: 0x00000004c94e5620
%rsp: 0x00007fffe11fc720 %rbp: 0x00007fffe11fc740  %r8: 0x0000000000000001
%r9: 0x00000004c94e5620 %r10: 0x0000000000000001 %r11: 0x00000004c94e5620
%r12: 0x0000000000000000 %r13: 0x0000000000000000 %r14: 0x0000000000000000
%r15: 0x00000004d5e3d9c0 %rip: 0x000000000111f076 %efl: 0x0000000000010202
  ktspsrch_reset()+4 (0x111f066) sub $32,%rsp
  ktspsrch_reset()+8 (0x111f06a) mov %rdi,%rcx
  ktspsrch_reset()+11 (0x111f06d) test %rcx,%rcx
  ktspsrch_reset()+14 (0x111f070) jz 0x111f103
> ktspsrch_reset()+20 (0x111f076) movzwl (%rcx),%eax
  ktspsrch_reset()+23 (0x111f079) test $0x1,%al
  ktspsrch_reset()+25 (0x111f07b) jz 0x111f103
  ktspsrch_reset()+31 (0x111f081) mov 0xa9f3028(%rip),%rdx
  ktspsrch_reset()+38 (0x111f088) test %rdx,%rdx

*** 2015-02-12 22:31:04.702
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
skdstdst()+36        call     kgdsdst()            000000000 ? 000000000 ?
                                                   2B5A3B698098 ? 000000001 ?
                                                   000000001 ? 000000003 ?
ksedst1()+98         call     skdstdst()           000000000 ? 000000000 ?
                                                   2B5A3B698098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ksedst()+34          call     ksedst1()            000000001 ? 000000001 ?
                                                   2B5A3B698098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
dbkedDefDump()+2741  call     ksedst()             000000001 ? 000000001 ?
                                                   2B5A3B698098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ksedmp()+36          call     dbkedDefDump()       000000003 ? 000000003 ?
                                                   2B5A3B698098 ? 000000001 ?
                                                   000000000 ? 000000003 ?
ssexhd()+2458        call     ksedmp()             000000003 ? 000000003 ?
                                                   2B5A3B698098 ? 000000001 ?

zilong198738

刘大,有空帮忙看下,谢谢,之前发错具体trc,下面的是对的

Liu Maclean(刘相兵

ktspsrchcc_cbk => ktspsrch_reset

ktspsrch_reset      ktspsrch_reset - Reset a dba search cache

  ktspsrch.c - Kernel Transaction Segment Pagetable SeaRch CacHe

Liu Maclean(刘相兵

odm finding:

This note gives a brief overview of bug 14040124.
The content was last updated on: 28-JUN-2013
Click here for details of each of the sections below.
Affects:

Product (Component)        Oracle Server (Rdbms)
Range of versions believed to be affected        (Not specified)
Versions confirmed as being affected       
11.2.0.3
Platforms affected        Generic (all / most platforms affected)
Fixed:

The fix for 14040124 is first included in       
12.1.0.1 (Base Release)
11.2.0.4 (Server Patch Set)

Interim patches may be available for earlier versions - click here to check.
Symptoms:

Related To:

Process May Dump (ORA-7445) / Abend / Abort
Stack is likely to include ktcCommitTxn
Stack is likely to include ktspsrch_reset
ASSM Space Management (Bitmap Managed Segments)
Database Link / Distributed
Description

This bug is only relevant when using ASSM Space Management (Bitmap Managed Segments)
ORA-7445[ktspsrch_reset] occurs during commit when a local transaction has
been promoted to distributed.

Rediscovery Notes
1. Local transaction is promoted to distributed.
2. Stack trace is similar to:
  ktspsrch_reset() -- ORA-7445
  ktspsrchcc_cbk()
  ktcccdel()
  ktcCommitTxn()

Workaround
Any of:
1.  Issue a commit before starting a distributed DML operation
2.  Use MSSM
3.  Disable space search cache if no indexes are involved

Note:
For interim patches for this issue in 11.2 releases please request the fix under bug 14313519

Liu Maclean(刘相兵

该问题确认为bug ，发生 场景为 分布式DML的commit在MSSM表空间上。

oracle官方认为在11.2.0.4中修复了，其他版本可以打补丁 14313519

zilong198738

好的  thks

tlzybzwqlvmeinv

有什么办法避免吗