今天发现数据库的ALERT文件中出现了ORA-07445错误,不知道什么原因。
数据库版本:ORACLE 10.2.4
操作系统:AIX 5.3
ORA-07445: exception encountered: core dump [kgghstfel+0074] [SIGSEGV] [Address not mapped to object] [0x106D72715F6370] [] []
生成的跟踪文件信息如下:
$ more /home/oracle10g/admin/pcrm/udump/pcrm_ora_434426.trc
/home/oracle10g/admin/pcrm/udump/pcrm_ora_434426.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /home/oracle10g/product/10.2.0/
System name:AIX
Release:3
Version:5
Machine:00C45D344C00
Instance name: pcrm
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 434426, image:
*** 2009-09-16 09:41:50.635
*** ACTION NAME
SQL Window - New) 2009-09-16 09:41:50.624
*** MODULE NAME
PL/SQL Developer) 2009-09-16 09:41:50.624
*** SESSION ID
282.65019) 2009-09-16 09:41:50.624
Exception signal: 11 (SIGSEGV), code: 50 (Address not mapped to object), addr: 0x106d72715f6370, PC: [0x100313494, kgghstfel+0074]
Registers:
iar: 0000000100313494, msr: a00000000000d0b2
lr: 0000000100832538,cr: 0000000044242444
r00: 0000000000008758, r01: 0ffffffffffe9770, r02: 000000011022ac30,
r03: 000000010508e570, r04: 0000000000043ac0, r05: 0000000000008758,
r06: 000000000000002b, r07: 00000000000002de, r08: 0000000000000000,
r09: 0000000000000000, r10: 00000001106239a0, r11: 0000000000000000,
r12: 0000000028242484, r13: 0000000110264fd8, r14: 070000001a4bf69c,
r15: 000000000000001d, r16: 0000000000001638, r17: 0000000000000000,
r18: 0000000000000000, r19: 0000000000000000, r20: 0000000000000000,
r21: 0000000000000000, r22: 0000000000000000, r23: 0ffffffffffebf38,
r24: 0ffffffffffe9b98, r25: 0000000110423bec, r26: 0000000110423bed,
r27: 0000000000000000, r28: 00000000000001a8, r29: 000000010508e570,
r30: 00106d72715f6368, r31: 0000000000000000,
*** 2009-09-16 09:41:50.635
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kgghstfel+0074] [SIGSEGV] [Address not mapped to object] [0x106D72715F6370] [] []
Current SQL statement for this session:
select count(*)from user$ u, xdb.xdb$schema swhere u.user# = :1and u.name= s.xmldata.schema_ownerand(xdb.xdb$Extname2
Intname(s.xmldata.schema_url, s.xmldata.schema_owner) = :2)
|