ORA-07445: exception encountered: core dump [kgghstfel()+15] [SIGSEGV] ...
数据库无缘无故不能使用，检查发现是监听停掉了，马上启动监听先保证可以使用。检查警告日志，发错报错如下
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
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博客 ” ，链接：https://blog.itpub.net/9399028/viewspace-774757/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
