与xdb有关的ORA-07445错误

日志中报如下错误：

Mon Jun  8 08:57:43 2009

Thread 2 advanced to log sequence 1094

  Current log# 6 seq# 1094 mem# 0: +DG1/xxxx/onlinelog/group_6.286.688929453

  Current log# 6 seq# 1094 mem# 1: /dev/redo_disk6

Mon Jun  8 08:59:43 2009

Errors in file /u01/app/oracle/admin/xxxx/udump/xxxx2_ora_1185628.trc:

ORA-07445: exception encountered: core dump [] [] [] [] [] []

Mon Jun  8 08:59:44 2009

Trace dumping is performing id=[cdmp_20090608085944]

Mon Jun  8 08:59:47 2009

Errors in file /u01/app/oracle/admin/xxxx/udump/xxxx2_ora_254068.trc:

ORA-07445: exception encountered: core dump [] [] [] [] [] []

 

查看两个trace文件发现都有共同的错误信息：

ORACLE_HOME = /u01/app/oracle/product/10.2.0/db

System name: AIX

Node name:  bbbbb

Release: 3

Version: 5

Machine: 00CE63EF4C00

Instance name: xxxx2

Redo thread mounted by this instance: 2

Oracle process number: 1946

Unix process pid: 254068, image: oraclexxxx2@bbbb

 

*** SERVICE NAME:(xxxx) 2009-06-08 08:59:46.995

*** SESSION ID:(1016.13346) 2009-06-08 08:59:46.995

*** 2009-06-08 08:59:46.995

Exception signal: 11  0x1002f7434 (kgghstfel+0074) e89e0008

 

通常情况下发生ORA-07445错误都是SQL引起来的，检查trace文件，发现有如下SQL：

*** 2009-06-08 08:59:47.204

ksedmp: internal or fatal error

ORA-07445: exception encountered: core dump [] [] [] [] [] []

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)

 

查询Metalink发现这是一个Bug造成的（Bug 5161782），ORACLE没有给出单独的补丁来修正这个BUG，只有升级到10.2.0.4才解决这个问题。