- 论坛徽章:
- 0
|
原帖由 numenhuang 于 2007-9-13 14:02 发表 ![]()
把gzwdb1_m000_21194.trc做附件发上来
不行呀，无法上传呀。一下是文件中的一部分信息：
/oracle/app/oracle/admin/gzwdb/bdump/gzwdb1_m000_21194.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
ORACLE_HOME = /oracle/app/oracle/product/10.2.0/db_10g
System name: Linux
Node name: gzwzzdb2
Release: 2.6.9-34.20AX
Version: #1 SMP Wed May 17 22:15:16 EDT 2006
Machine: ppc64
Instance name: gzwdb1
Redo thread mounted by this instance: 1
Oracle process number: 39
Unix process pid: 21194, image: oracle@gzwzzdb2 (m000)
*** ACTION NAME Remote-Flush Slave Action) 2007-09-11 17:00:06.511
*** MODULE NAMEMMON_SLAVE) 2007-09-11 17:00:06.511
*** SERVICE NAMESYS$BACKGROUND) 2007-09-11 17:00:06.511
*** SESSION ID1589.5710) 2007-09-11 17:00:06.511
Exception signal: 11 (SIGSEGV), code: 1 (unknown code), addr: 0xc00000001f577bd8, PC: [0x12abbc3c, qerfxFetch()+2896]
Registers:
%pc: 0x12abbc3c %lr: 0x12abc368 %dar: 0x1f577bd8 %cr: 0x222c288d
%xer: 0x20000018 %msr: 0x0200d032 %ctr: 0x9ef0fe80 %dsisr: 0x08000000
%r0: 0x00000000 %r1: 0xffff2310 %r2: 0x1622dd38 %r3: 0x00000000
%r4: 0x77175d48 %r5: 0x00000004 %r6: 0x14acd5d0 %r7: 0x084e554d
%r8: 0xfea85000 %r9: 0x00000000 %r10: 0x0000000d %r11: 0x0157b000
%r12: 0x12abc368 %r13: 0x013a9ba0 %r14: 0x1f577bd8 %r15: 0x161199b8
%r16: 0x00007fff %r17: 0x00007fff %r18: 0x00000003 %r19: 0x6b53fcb0
%r20: 0x20008fb0 %r21: 0x01563ad8 %r22: 0x15e4ff48 %r23: 0x00000000
%r24: 0x20006f00 %r25: 0x20007998 %r26: 0x01563a98 %r27: 0x14f4c0c0
%r28: 0x01563a80 %r29: 0x14f09428 %r30: 0x15dcae38 %r31: 0x6b53fcd0
%softe: 0x00437080 %trap: 0x00000300 %result: 0x00000000 %orig_gpr3: 0x01876000
*** 2007-09-11 17:00:06.524
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [qerfxFetch()+2896] [SIGSEGV] [unknown code] [0xC00000001F577BD8] [] []
Current SQL statement for this session:
SELECT COUNT(*) FROM (SELECT OSSTAT_ID, STAT_NAME FROM V$OSSTAT MINUS SELECT STAT_ID, STAT_NAME FROM WRH$_OSSTAT_NAME WHERE d
bid = :dbid)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+36 bl ksedst1()+0
qerfxFetch()+2896 ? (nil)
rwsfcd()+120 ? (nil)
qeruaFetch()+340 ? (nil)
qervwFetch()+172 ? (nil)
qersoFetch()+312 ? (nil)
qerseFetch()+232 ? (nil)
qervwFetch()+172 ? (nil)
qergsFetch()+724 ? (nil)
opifch2()+5056 ? (nil)
kpoal8()+5652 bl opifch2()+0
opiodr()+2996 ? (nil)
kpoodrc()+36 bl opiodr()+0
rpiswu2()+916 ? (nil)
kpoodr()+568 bl rpiswu2()+0
upirtrc()+1300 ? (nil)
kpurcsc()+112 bl upirtrc()+0
kpuexecv8()+4420 bl kpurcsc()+0
kpuexec()+4756 bl kpuexecv8()+0
OCIStmtExecute()+32 bl kpuexec()+0
kewrose_oci_stmt_ex bl printf()+172
ec()+72
kewrgwxf1_gwrsql_ex bl kewrose_oci_stmt_ex
ft_1()+528 ec()+0
kewrgwxf_gwrsql_exf bl kewrgwxf1_gwrsql_ex
t()+1060 ft_1()+0
kewrcnc_check_name_ bl kewrgwxf_gwrsql_exf
changes()+380 t()+0
Cannot find symbol in /lib64/tls/libc.so.6.
Cannot find symbol in /lib64/tls/libc.so.6.
Cannot find symbol in /lib64/tls/libc.so.6.
Cannot find symbol in /lib64/tls/libc.so.6.
Cannot find symbol in /lib64/tls/libc.so.6.
Cannot find symbol in /lib64/tls/libc.so.6.
kewrfat_flush_all_t bl kewrcnc_check_name_
ables()+416 changes()+0
kewrfsr_flush_snaps bl kewrfat_flush_all_t
hot_r()+212 ables()+0
kewrrfs_remote_flus bl kewrfsr_flush_snaps
h_slave()+608 hot_r()+0
kebm_slave_main()+3 ? (nil)
04
ksvrdp()+2940 ? (nil)
opirip()+1452 bl ksvrdp()+0
opidrv()+1200 bl opirip()+0
sou2o()+152 bl opidrv()+0
opimai_real()+344 bl sou2o()+0
main()+140 bl opimai_real()+0
0x809eeb4018 ? (nil)
0x809eeb41a0 bl 0x809eeb3eec
(FOB) flags=512 fib=0x6fdd3ff0 incno=0 pending i/o cnt=0
fname=+GZWASM/gzwdb/datafile/sysaux.274.630684087
fno=3 lblksz=8192 fsiz=130560
----------------------------------------
SO: 0x77c2ae18, type: 4, owner: 0x77175d48, flag: INIT/-/-/0x00
(session) sid: 1589 trans: (nil), creator: 0x77175d48, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-0027-00000017, short-term DID: 0001-0027-00000018
txn branch: (nil)
oct: 0, prv: 0, sql: (nil), psql: (nil), user: 0/SYS
last wait for 'gc current request' blocking sess=0x(nil) seq=5 wait_time=519 seconds since wait started=0
file#=3, block#=1150, id#=2000001
Dumping Session Wait History
for 'gc current block 2-way' count=1 wait_time=519
=3, =1150, =2000001
for 'gc cr block 2-way' count=1 wait_time=515
=3, =1175, =1
for 'row cache lock' count=1 wait_time=646
cache id=16, mode=0, request=3
for 'enq: WF - contention' count=1 wait_time=249
name|mode=57460004, 0=0, 0=0
for 'enq: WF - contention' count=1 wait_time=55
name|mode=57460004, 0=0, 0=0
for 'class slave wait' count=1 wait_time=4883771
slave id=5, =0, =0
temporary object counter: 0
----------------------------------------
UOL used : 0
KGX Atomic Operation Log 0x6197c5d8
Mutex (nil)(0, 0) idn 0 oper NONE
Cursor Parent uid 1589 efd 10 whr 22 slp 0
oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
pt4=(nil) u41=0 stt=0
KGX Atomic Operation Log 0x6197c620
Mutex (nil)(0, 0) idn 0 oper NONE
Cursor Stat uid 1589 efd 0 whr 0 slp 0
oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
pt4=(nil) u41=0 stt=0
KGX Atomic Operation Log 0x6197c668
Mutex (nil)(0, 0) idn 0 oper NONE
Cursor Stat uid 1589 efd 0 whr 0 slp 0
oper=NONE pt1=(nil) pt2=(nil) pt3=(nil)
pt4=(nil) u41=0 stt=0
----------------------------------------
SO: 0x76fde1d0, type: 53, owner: 0x77c2ae18, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=76fde1d0 handle=782236a8 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x76fde250[0x6d6ebe38,0x6d6ebe38] htb=0x6d6ebe38 ssga=0x6d6eb320
user=77c2ae18 session=77c66460 count=0 flags=LRU/[4000] savepoint=0x169819
LIBRARY OBJECT HANDLE: handle=782236a8 mutex=0x782237d8(0)
name=SYS.WRH$_OSSTAT_NAME
hash=72a38a4d83aab0a62f20b75eeaf77da1 timestamp=08-15-2007 14:10:27
namespace=TABL flags=KGHP/TIM/XLR/[00000020]
kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
lwt=0x78223750[0x78223750,0x78223750] ltm=0x78223760[0x78223760,0x78223760]
pwt=0x78223718[0x78223718,0x78223718] ptm=0x78223728[0x78223728,0x78223728]
ref=0x78223780[0x78223780,0x78223780] lnd=0x78223798[0x619ad688,0x78225b68]
LOCK INSTANCE LOCK: id=LB72a38a4d83aab0a6
PIN INSTANCE LOCK: id=NB72a38a4d83aab0a6 mode=S release=F flags=[00]
INVALIDATION INSTANCE LOCK: id=IV000023670f0f0b1c mode=S
LIBRARY OBJECT: object=6ca9d950
type=TABL flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 789c4340 6ca9da68 I/-/A/-/- 0 NONE 00
8 6ca9dc50 6ca9d6e0 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 0x6de1edc0, type: 53, owner: 0x77c2ae18, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=6de1edc0 handle=78225a78 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x6de1ee40[0x6d6eb4a8,0x6d6eb4a8] htb=0x6d6eb4a8 ssga=0x6d6eb320
user=77c2ae18 session=77c66460 count=0 flags=LRU/[4000] savepoint=0x169819
LIBRARY OBJECT HANDLE: handle=78225a78 mutex=0x78225ba8(0)
name=SYS.V$OSSTAT
hash=ad5c439b9fd345f32be5d047cbd49608 timestamp=01-02-1991 00:00:00
namespace=TABL flags=KGHP/FIX/TIM/XLR/[00040020]
kkkk-dddd-llll=0000-0101-0101 lock=N pin=0 latch#=1 hpc=0022 hlc=0022
lwt=0x78225b20[0x78225b20,0x78225b20] ltm=0x78225b30[0x78225b30,0x78225b30]
pwt=0x78225ae8[0x78225ae8,0x78225ae8] ptm=0x78225af8[0x78225af8,0x78225af8]
ref=0x78225b50[0x78225b50,0x78225b50] lnd=0x78225b68[0x78223798,0x78226398]
LOCK INSTANCE LOCK: id=LBad5c439b9fd345f3
PIN INSTANCE LOCK: id=NBad5c439b9fd345f3 mode=S release=F flags=[00]
LIBRARY OBJECT: object=6ccf6ea8
type=VIEW flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change whr
----- -------- -------- --------- ---- ------ ---
0 783e56b0 6ccf6fc0 I/-/A/-/- 0 NONE 00
8 6ccf71a8 6ccf6ca8 I/-/A/-/- 0 NONE 00
----------------------------------------
SO: 0x6d79d0a0, type: 54, owner: 0x77c2ae18, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=6d79d0a0 handle=61e0c280 mode=S lock=0
user=77c2ae18 session=77c66460 count=1 mask=0041 savepoint=0x169819 flags=[04]
----------------------------------------
SO: 0x6d776f68, type: 53, owner: 0x77c2ae18, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=6d776f68 handle=61e0c280 mode=N
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x6d776fe8[0x4db42508,0x6d6eb738] htb=0x6d6eb738 ssga=0x6d6eb320
user=77c2ae18 session=77c66460 count=1 flags=[0000] savepoint=0x0
LIBRARY OBJECT HANDLE: handle=61e0c280 mutex=0x61e0c3b0(0)
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=N pin=S latch#=1 hpc=0002 hlc=0002
lwt=0x61e0c328[0x61e0c328,0x61e0c328] ltm=0x61e0c338[0x61e0c338,0x61e0c338]
pwt=0x61e0c2f0[0x61e0c2f0,0x61e0c2f0] ptm=0x61e0c300[0x61e0c300,0x61e0c300]
ref=0x61e0c358[0x6c10d4b8,0x6c10d4b8] lnd=0x61e0c370[0x61e0c370,0x61e0c370]
LIBRARY OBJECT: object=6cac4bf8
type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
DEPENDENCIES: count=5 size=16
READ ONLY DEPENDENCIES: count=1 size=16
AUTHORIZATIONS: count=1 size=16 minimum entrysize=16
ACCESSES: count=2 size=16
TRANSLATIONS: count=2 size=16
DATA BLOCKS: |
|
免费注册
发表于 2007-09-13 11:25
