ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...

ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...

原创 Linux操作系统 作者:xz43 时间:2013-10-21 18:07:42 0 删除 编辑
数据库无缘无故不能使用,检查发现是监听停掉了,马上启动监听先保证可以使用。检查警告日志,发错报错如下

Mon Oct 21 17:37:21 2013
Errors in file /oracle/admin/orcl/udump/orcl_ora_7485.trc:
ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []

再找到上面的trace文件,里面错误如下:

*** SERVICE NAME:(orcl) 2013-10-21 17:37:21.705
*** SESSION ID:(429.9319) 2013-10-21 17:37:21.705
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x18, PC: [0x3c3ef01, kgghstfel()+15]
*** 2013-10-21 17:37:21.777
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []
Current SQL statement for this session:
 select count(*)  from user$ u, xdb.xdb$schema s  where u.user# = :1  and   u.name  = s.xmldata.schema_owner  and  (xdb.xdb$Extname2Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0xf23af1c0         1  function XDB.XDB$EXTNAME2INTNAME
0xf21c2e28         1  anonymous block
0xe8d3b758        17  package body SYS.XML_SCHEMA_NAME_PRESENT
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
Cannot find symbol
Cannot find symbol
Cannot find symbol
ksedst()+31          call     ksedst1()            000000001 ? 000000001 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000001 ?
ksedmp()+610         call     ksedst()             000000001 ? 000000001 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000001 ?
ssexhd()+630         call     ksedmp()             000000003 ? 000000001 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000001 ?
<0x396380dd40>       call     ssexhd()             00000000B ? 2AAAAC79CD70 ?
                                                   2AAAAC79CC40 ? 000000000 ?
                                                   000000000 ? 000000001 ?
 
--------------------- Binary Stack Dump ---------------------
...
...
...

----- End of Call Stack Trace -----
===================================================
PROCESS STATE
-------------
Process global information:
     process: 0xf371bc78, call: 0xead82998, xact: (nil), curses: 0xf3997780, usrses: 0xf3997780
  ----------------------------------------
  SO: 0xf371bc78, type: 2, owner: (nil), flag: INIT/-/-/0x00
  (process) Oracle pid=329, calls cur/top: 0xead82998/0xead8b470, flag: (0) -
            int error: 0, call error: 0, sess error: 0, txn error 0
  (post info) last post received: 0 0 0
              last post received-location: No post
              last process to post me: none
              last post sent: 0 0 0
              last post sent-location: No post
              last process posted by me: none
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: 0xf3771200
    O/S info: user: oracle, term: UNKNOWN, ospid: 7485
    OSD pid info: Unix process pid: 7485, image: oracleorcl@localhost.localdomain
Dump of memory from 0x00000000F36637F8 to 0x00000000F3663A00
0F36637F0                   00000006 00000000          [........]
0F3663800 EAC86600 00000000 00000010 0003139D  [.f..............]
0F3663810 EAD8B470 00000000 00000003 0003139D  [p...............]
0F3663820 F3D25D58 00000000 0000000B 0003139D  [X]..............]
0F3663830 F3997780 00000000 00000004 00031291  [.w..............]
0F3663840 F0580E18 00000000 00000007 0003139D  [..X.............]
0F3663850 F0580EF8 00000000 00000007 0003139D  [..X.............]
0F3663860 00000000 00000000 00000000 00000000  [................]
  Repeat 25 times
    (FOB) flags=2 fib=0xf09d84b0 incno=0 pending i/o cnt=0
     fname=/oracle/oradata/orcl/system02.dbf
     fno=17 lblksz=4 fsiz=86309856
    (FOB) flags=2 fib=0xf09d4a50 incno=0 pending i/o cnt=0
     fname=/oracle/oradata/orcl/system01.dbf
     fno=1 lblksz=4 fsiz=86309856
    ----------------------------------------
    SO: 0xf3997780, type: 4, owner: 0xf371bc78, flag: INIT/-/-/0x00
    (session) sid: 429 trans: (nil), creator: 0xf371bc78, flag: (8000041) USR/- BSY/-/-/-/-/-
              DID: 0001-0149-000001AC, short-term DID: 0000-0000-00000000
              txn branch: (nil)
              oct: 3, prv: 0, sql: 0xf29a2938, psql: 0xf221c6f8, user: 0/SYS
    O/S info: user: zyw, term: DELL-PC, ospid: 6528:6828, machine: WORKGROUP\DELL-PC
              program: plsqldev.exe
    application name: plsqldev.exe, hash value=0
    last wait for 'latch: shared pool' blocking sess=0x(nil) seq=249 wait_time=121 seconds since wait started=0
                address=600e3d08, number=d5, tries=1
    Dumping Session Wait History
     for 'latch: shared pool' count=1 wait_time=121
                address=600e3d08, number=d5, tries=1
     for 'latch: shared pool' count=1 wait_time=10
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=5
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=941
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=14
                address=600e3d08, number=d5, tries=0
     for 'latch: library cache' count=1 wait_time=6
                address=eff3e460, number=d6, tries=0
     for 'latch: shared pool' count=1 wait_time=127
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=107
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=93
                address=600e3d08, number=d5, tries=0
     for 'latch: shared pool' count=1 wait_time=80
                address=600e3d08, number=d5, tries=0
    temporary object counter: 0
      ----------------------------------------
      Virtual Thread:
      kgskvt: 0xf27439b0, sess: 0xf3997780, vc: (nil), proc: 0xf371bc78
      consumer group cur: OTHER_GROUPS (upd? 0), mapped: DEFAULT_CONSUMER_GROUP, orig: 
      vt_state: 0x200, vt_flags: 0x30, blkrun: 0
      is_assigned: 1, in_sched: 0 (0)
      vt_active: 0 (pending: 1)
      used quanta: 0 (cg: 0)
      cpu start time: 0, quantum status: 0x0
      quantum checks to skip: 0, check thresh: 0
      idle time: 0, active time: 0 (cg: 0)
      cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0 (cg: 0)
      queued time outs: 0, time: 0 (cur 0, cg 0)
      calls aborted: 0, num est exec limit hit: 0
      undo current: 0k max: 0k
      ----------------------------------------
      UOL used : 0
      KGX Atomic Operation Log 0xe8eaab60
       Mutex (nil)(0, 0) idn 0 oper NONE
       Cursor Parent uid 429 efd 47 whr 13 slp 0
       oper=NONE pt1=0xecb43998 pt2=0xecb43a00 pt3=(nil)
       pt4=(nil) u41=0 stt=0
      KGX Atomic Operation Log 0xe8eaaba8
       Mutex 0xf27c3c78(0, 1) idn 0 oper NONE
       Cursor Stat uid 429 efd 65 whr 1 slp 0
       oper=NONE pt1=0xf27c3b48 pt2=(nil) pt3=(nil)
       pt4=(nil) u41=0 stt=8
      KGX Atomic Operation Log 0xe8eaabf0
       Mutex (nil)(0, 0) idn 0 oper NONE
       Cursor Stat uid 429 efd 0 whr 0 slp 0
       oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
       pt4=(nil) u41=0 stt=0
      ----------------------------------------
      SO: 0xea838cc0, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=ea838cc0 handle=f250d200 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xea838d40[0xedad6b88,0xedad6b88] htb=0xedad6b88 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1
      LIBRARY OBJECT HANDLE: handle=f250d200 mutex=0xf250d330(0)
      name=XDB.XDB$DERIVATIONCHOICE 
      hash=835b639a7ca7231b761b05003b2e12b5 timestamp=10-22-2005 22:08:23
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=0714 hlc=0714
      lwt=0xf250d2a8[0xf250d2a8,0xf250d2a8] ltm=0xf250d2b8[0xf250d2b8,0xf250d2b8]
      pwt=0xf250d270[0xf250d270,0xf250d270] ptm=0xf250d280[0xf250d280,0xf250d280]
      ref=0xf250d2d8[0xf250d2d8,0xf250d2d8] lnd=0xf250d2f0[0xe8d6f0e8,0xf23e9358]
        LIBRARY OBJECT: bject=e7927780
        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0
        DEPENDENCIES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 f25e3170 e79278d8 I/-/A/-/-    0 NONE   00 
            6 e7927a30 e71f73f0 I/-/A/-/-    0 NONE   00 
      ----------------------------------------
      SO: 0xdedf1980, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=dedf1980 handle=f25de0f8 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xdedf1a00[0xedad6238,0xedad6238] htb=0xedad6238 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1
      LIBRARY OBJECT HANDLE: handle=f25de0f8 mutex=0xf25de228(0)
      name=XDB.XDB$XMLTYPE_REF_LIST_T 
      hash=4bfe6f9a3d8968775b28533e119ffd20 timestamp=10-22-2005 22:08:23
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=4 hpc=08ec hlc=08ec
      lwt=0xf25de1a0[0xf25de1a0,0xf25de1a0] ltm=0xf25de1b0[0xf25de1b0,0xf25de1b0]
      pwt=0xf25de168[0xf25de168,0xf25de168] ptm=0xf25de178[0xf25de178,0xf25de178]
      ref=0xf25de1d0[0xf25de1d0,0xf25de1d0] lnd=0xf25de1e8[0xe8186688,0xf21ff290]
        LIBRARY OBJECT: bject=e7a945d0
        type=TYPE flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
        DEPENDENCIES: count=2 size=16
        ACCESSES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 e8dd70b8 e7a94728 I/-/A/-/-    0 NONE   00 
            6 e7a94160 e43d1000 I/-/A/-/-    0 NONE   00 
      ----------------------------------------
      SO: 0xedd40158, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=edd40158 handle=f22c6b70 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xedd401d8[0xedad6cc8,0xedad6cc8] htb=0xedad6cc8 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1
      LIBRARY OBJECT HANDLE: handle=f22c6b70 mutex=0xf22c6ca0(0)
      name=XDB.XDB$UNION_T 
      hash=458611b793105ccdb7148290ba3993c9 timestamp=10-22-2005 22:08:24
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=1 hpc=00d0 hlc=00d0
      lwt=0xf22c6c18[0xf22c6c18,0xf22c6c18] ltm=0xf22c6c28[0xf22c6c28,0xf22c6c28]
      pwt=0xf22c6be0[0xf22c6be0,0xf22c6be0] ptm=0xf22c6bf0[0xf22c6bf0,0xf22c6bf0]
      ref=0xf22c6c48[0xf22c6c48,0xf22c6c48] lnd=0xf22c6c60[0xe8255e00,0xe83d3b28]
        LIBRARY OBJECT: bject=ecdb2f90
        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0
        DEPENDENCIES: count=4 size=16
        ACCESSES: count=3 size=16
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 e8329028 ecdb30e8 I/-/A/-/-    0 NONE   00 
            6 ecdb2bd8 e7d29e78 I/-/A/-/-    0 NONE   00 
      ----------------------------------------
      SO: 0xeef22950, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=eef22950 handle=e8285d40 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xeef229d0[0xedad6a38,0xedad6a38] htb=0xedad6a38 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1
      LIBRARY OBJECT HANDLE: handle=e8285d40 mutex=0xe8285e70(0)
      name=XDB.XDB$QNAME 
      hash=0dd4ddb94dedc16622c112ff2f4dfca0 timestamp=10-22-2005 22:08:23
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=2 hpc=0dc0 hlc=0dc0
      lwt=0xe8285de8[0xe8285de8,0xe8285de8] ltm=0xe8285df8[0xe8285df8,0xe8285df8]
      pwt=0xe8285db0[0xe8285db0,0xe8285db0] ptm=0xe8285dc0[0xe8285dc0,0xe8285dc0]
      ref=0xe8285e18[0xe8285e18,0xe8285e18] lnd=0xe8285e30[0xf26feb50,0xe8286040]
        LIBRARY OBJECT: bject=e723cae8
        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0
        DEPENDENCIES: count=1 size=16
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 f279ba88 e723cc40 I/-/A/-/-    0 NONE   00 
            6 e723cd98 ec8989a0 I/-/A/-/-    0 NONE   00 
      ----------------------------------------
      SO: 0xea796c30, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=ea796c30 handle=f22c6d80 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xea796cb0[0xedad67c8,0xedad67c8] htb=0xedad67c8 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=0 flags=LRU/[4000] savepoint=0x1ad1
      LIBRARY OBJECT HANDLE: handle=f22c6d80 mutex=0xf22c6eb0(0)
      name=XDB.XDB$LIST_T 
      hash=9d0fb30f16e92c9e243a0be6729b7379 timestamp=10-22-2005 22:08:24
      namespace=TABL flags=KGHP/TIM/SML/[02000000]
      kkkk-dddd-llll=0000-0041-0041 lock=N pin=0 latch#=3 hpc=0150 hlc=0150
      lwt=0xf22c6e28[0xf22c6e28,0xf22c6e28] ltm=0xf22c6e38[0xf22c6e38,0xf22c6e38]
      pwt=0xf22c6df0[0xf22c6df0,0xf22c6df0] ptm=0xf22c6e00[0xf22c6e00,0xf22c6e00]
      ref=0xf22c6e58[0xf22c6e58,0xf22c6e58] lnd=0xf22c6e70[0xe8cee7f8,0xf21695d0]
        LIBRARY OBJECT: bject=e7160e18
        type=TYPE flags=EXS/LOC[0005] pflags=/PRP[0080] status=VALD load=0
        DEPENDENCIES: count=4 size=16
        ACCESSES: count=4 size=16
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 e82ace10 e7160f70 I/-/A/-/-    0 NONE   00 
            6 e7160a78 e73ec458 I/-/A/-/-    0 NONE   00 
      ---------------------------------------- 
...
...
      SO: 0xeddaf208, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=eddaf208 handle=f2a86088 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xeddaf288[0xedad6b98,0xedad7a10] htb=0xedad6b98 ssga=0xedad5f30
      user=f3997780 session=f384b1f8 count=1 flags=[0000] savepoint=0x14e2
      LIBRARY OBJECT HANDLE: handle=f2a86088 mutex=0xf2a861b8(5)
      name=
select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.flags,i.property,i.pctfree$,i.initrans,i.maxtrans,i.blevel,i.leafcnt,i.distkey,i.lblkkey,i.dblkkey,i.clufac,i.cols,i.analyzetime,i.samplesize,i.dataobj#,nvl(i.degree,1),nvl(i.instances,1),i.rowcnt,mod(i.pctthres$,256),i.indmethod#,i.trunccnt,nvl(c.unicols,0),nvl(c.deferrable#+c.valid#,0),nvl(i.spare1,i.intcols),i.spare4,i.spare2,i.spare6,decode(i.pctthres$,null,null,mod(trunc(i.pctthres$/256),256)),ist.cachedblk,ist.cachehit,ist.logicalread from ind$ 
      hash=1d4a51a2c89ab6b07a3c64bebc5573b6 timestamp=09-10-2013 16:49:23
      namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/KST/DBN/MTX/[100100d4]
      kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=2 hpc=c8c6 hlc=c8c6
      lwt=0xf2a86130[0xf2a86130,0xf2a86130] ltm=0xf2a86140[0xf2a86140,0xf2a86140]
      pwt=0xf2a860f8[0xf2a860f8,0xf2a860f8] ptm=0xf2a86108[0xf2a86108,0xf2a86108]
      ref=0xf2a86160[0xf2a86160,0xf2a86160] lnd=0xf2a86178[0xf2a34a78,0xf2a9cb60]
        LIBRARY OBJECT: bject=ecf07178
        type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
        CHILDREN: size=16
        child#    table reference   handle
        ------ -------- --------- --------
             0 ecf06c40  ecf068b0 f2a85e60
             1 ecf06c40  ecf06b50 f2a7c200
             2 ecf06c40  ecf88d38 f2a3e620
             3 ecf06c40  ecd64fa8 f24a7e80
             4 ecf06c40  e4228c28 e83237f0
             5 ecf06c40  e7a4dd60 e8c9d4b0
             6 ecf06c40  e7c111c8 e89bfe58
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 f2a85fc8 ecf07290 I/P/A/-/-    0 NONE   00 
      ----------------------------------------
...
...
      SO: 0xedad7488, type: 53, owner: 0xf3997780, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=edad7488 handle=e8997f10 mode=N
      call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
      htl=0xedad7508[0xedad6b58,0xea826e50] htb=0xedad6b58 ssga=0xedad5f30
      user=f3997780 session=f3997780 count=1 flags=[0000] savepoint=0x14d9
      LIBRARY OBJECT HANDLE: handle=e8997f10 mutex=0xe8998040(1)
      name=select value(p$) from "XDB"."XDB$ELEMENT"                 as of snapshot(:2) p$ where SYS_NC_OID$ = :1
      hash=7fe95d7e6f370b394c1f932d9b587ab2 timestamp=10-21-2013 10:41:57
      namespace=CRSR flags=RON/KGHP/TIM/KEP/PN0/MED/KST/DBN/MTX/[500100d4]
      kkkk-dddd-llll=0001-0001-0001 lock=N pin=0 latch#=5 hpc=0002 hlc=0002
      lwt=0xe8997fb8[0xe8997fb8,0xe8997fb8] ltm=0xe8997fc8[0xe8997fc8,0xe8997fc8]
      pwt=0xe8997f80[0xe8997f80,0xe8997f80] ptm=0xe8997f90[0xe8997f90,0xe8997f90]
      ref=0xe8997fe8[0xe8997fe8,0xe8997fe8] lnd=0xe8998000[0xe8a9ed58,0xf26fed60]
        LIBRARY OBJECT: bject=e4d77b50
        type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
        CHILDREN: size=16
        child#    table reference   handle
        ------ -------- --------- --------
             0 e78a8638  e78a82a8 f21fe830
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 e81f1668 e4d77c68 I/P/A/-/-    0 NONE   00 
      ----------------------------------------
...

没看出问题出在哪里。通过网络,找到这个是Oracle的bug引起的
 

主题: ORA-7445 (kgghstfel)   文档 ID: 549480.1 类型: REFERENCE   Modified Date: 23-OCT-2008 状态: PUBLISHED
Note: For additional ORA-7445 related information please read Note 211909.1

PURPOSE:

This article provides information on one or more bugs that are
known to result in the given ORA-7445 error.

SUGGESTIONS:

If the Known Issues section below does not help in terms of identifying
a solution, please submit the trace files and alert.log to Oracle
Support Services for further analysis.

Known Issues:
Bug# 5161782 See Note 5161782.8
Dump installing XDB
Fixed: 10.2.0.4

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9399028/viewspace-774757/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-16

  • 博文量
    407
  • 访问量
    1730997