sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 21 00:39:50 2009
Copyright 1982, 2005, Oracle. All rights reserved.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug dump systemstate 266
ORA-03113: end-of-file on communication channel
ORA-24323: value not allowed
alert:
ORA-07445: exception encountered: core dump [kgldmp()+1177] [SIGSEGV] [Address not mapped to object] [0x18] [] []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+27 call ksedst1() 1 ? 1 ?
ksedmp()+557 call ksedst() 1 ? B7489F84 ? B7489F84 ?
B7489F8C ? FFFFFFFF ?
B7489F84 ?
ssexhd()+863 call ksedmp() 3 ? AE92925 ? 646C676B ?
2928706D ? 3731312B ? 37 ?
kgldmp()+1177 signal 00000000 B ? B748BC90 ? B748BD10 ?
kgllkd()+1112 call kgldmp() CBC2A40 ? 30AD841C ? 3 ? 1 ?
kssdmp1()+206 call 00000000 CBC2A40 ? 2EB37A78 ? 3 ?
kssdmh()+191 call kssdmp1() 2EB37A78 ? 3 ?
ksudms()+834 call kssdmh() 30F12C34 ? 2 ? 30F12C34 ? 2 ?
kssdmp1()+98 call 00000000 30F12C34 ? 2 ?
kssdmh()+191 call kssdmp1() 30F12C34 ? 2 ?
ksudmp_proc()+683 call kssdmh() 30E184B4 ? 1 ? 30E0840C ?
184 ? 1 ?
ksudss()+2815 call ksudmp_proc() 30E184B4 ? 1 ? 0 ?
ksdxfdmp()+1382 call 0C95AEEA A ? BFFFCAEC ? BFFFC664 ?
CB740C0 ? B7FF4F39 ?
BFFFCEF7 ?
ksdxen()+2771 call 00000000 BFFFD8D4 ? 14 ? 3 ?
BFFFCAD0 ? BFFFCB20 ?
opiodr()+2347 call 00000000 56 ? 11 ? BFFFED44 ?
ttcpip()+4227 call 00000000 56 ? 11 ? BFFFED44 ? 0 ?
CC2ABA6 ? 17 ?
opitsk()+1991 call ttcpip() CBCA240 ? 56 ? BFFFED44 ? 0 ?
BFFFE224 ? BFFFEE68 ?
opiino()+1387 call opitsk() 0 ? 0 ?
opiodr()+2347 call 00000000 3C ? 4 ? BFFFF930 ?
opidrv()+915 call opiodr() 3C ? 4 ? BFFFF930 ? 0 ?
sou2o()+113 call opidrv() 3C ? 4 ? BFFFF930 ?
opimai_real()+212 call sou2o() BFFFF914 ? 3C ? 4 ?
BFFFF930 ?
main()+111 call opimai_real() 2 ? BFFFF960 ?
__libc_start_main() call 00000000 2 ?
Bug 4119264 - Dump kgldmp during a SYSTEMSTATE dump
Doc ID: 4119264.8
A dump can occur in kgldmp when taking a library cache or
system state dump during a time when 'shutdown immediate' is hung.
但是Bug 4119264只在9206下有patch.
QL> alter system flush shared_pool;
System altered.
SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit;
Statement processed.
SQL> oradebug dump systemstate 266
Statement processed.
根据metalink描述,flush shared_pool后问题ok
: | . |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9533994/viewspace-1027978/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9533994/viewspace-1027978/