ORA-7445(qmurdBufOradbOpen)错误

这个bug比较奇怪，似乎是由于其他错误而导致了7445错误出现。

后台alert文件中的信息为：

Errors in file /u1/oracle/admin/repdb01/udump/repdb01_ora_23886.trc:
)@a&bmD?1sEF0ORA-07445: exception encountered: core dump [000000010073E5D4] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []
y4B#k#Q4w#G s0ORA-00932: inconsistent datatypes: expected  got

对应的TRACE文件中的详细信息为：

bash-2.03$ more /u1/oracle/admin/repdb01/udump/repdb01_ora_23886.trcITPUB个人空间$H9OjQ#wl
/u1/oracle/admin/repdb01/udump/repdb01_ora_23886.trcITPUB个人空间
`/a.E'~9b"H-D
n~
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionITPUB个人空间(d;w`C%?9k
With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间`&\vH3X9I4W
JServer Release 9.2.0.4.0 - ProductionITPUB个人空间.XS!`cR
ORACLE_HOME = /data/oracle/product/920ITPUB个人空间7z/? HePLOh
System name:    SunOSITPUB个人空间2?%H P5NDp
Node name:      newreport
v_&@-Csz"l0Release:        5.8ITPUB个人空间2TH-Pu*JcA ma
Version:        Generic_117350-26
:? x2w3j@.xJR0Machine:        sun4uITPUB个人空间1z'zVXq~6q9x9H | g
Instance name: repdb01
]/vxQ?/|0Redo thread mounted by this instance: 1
[}4@d+Y3g0Oracle process number: 25
o&m!a`6J5h3aCSB0Unix process pid: 23886, image: oracle@newreport (TNS V1-V3)

*** 2007-06-23 01:01:39.713
2Cv`$?*T*m0*** SESSION ID:(98.5044) 2007-06-23 01:01:39.676
|NX@A!`
@0Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x18, PC: [0x10073e5d4, 000000010073E5D4]
-opU%A1{-k7WF0*** 2007-06-23 01:01:39.717ITPUB个人空间2[1Z`5Ic J
ksedmp: internal or fatal error
2jeX#sxy(Cs0ORA-07445: exception encountered: core dump [000000010073E5D4] [SIGSEGV] [Address not mapped to object] [0x000000018] [] []
\3{ v~;e+[.e*jk0ORA-00932: inconsistent datatypes: expected  got
N7e8fM6E_*z8r0Current SQL statement for this session:
/o!BCv!y[0select dbms_metadata.get_ddl('VIEW','V_3_1','BIDUI') FROM DUALITPUB个人空间X!`1@#H*zaN1V[B"r
----- PL/SQL Call Stack -----
R*@ r2EJ~0  object      line  objectITPUB个人空间B!i!jT1E+Q
  handle    number  nameITPUB个人空间HH&t$M$bp%^At
427ae9ca0         0  package body SYS.UTL_XML
J/OBj'_xs#j?(b%@042ab71f50      3296  package body SYS.DBMS_METADATA_INTITPUB个人空间B&t:kQfK#x
42ab71f50      4148  package body SYS.DBMS_METADATA_INTITPUB个人空间[lBK8pH
42ab7c2a8       458  package body SYS.DBMS_METADATAITPUB个人空间 B Y&i q I\~
42ab7c2a8       615  package body SYS.DBMS_METADATA
J'x#g8aix[042ab7c2a8      1221  package body SYS.DBMS_METADATAITPUB个人空间X#D4mTj ^LN-H
46eac2458         1  anonymous block
2E9V dA1s0----- Call Stack Trace -----ITPUB个人空间\@`#? KoVW
calling              call     entry                argument values in hex     
h UWA.J1[n q aa6L0location             type     point                (? means dubious value)    
AMs.j,`'[] |.CT0-------------------- -------- -------------------- ----------------------------
Ir)E"u/dN0ksedmp()+328         CALL     ksedst()+0           FFFFFFFF7FFF3A60 ?
+Hrh }pfN Q-Gye0                                                   000000000 ? 000000000 ?
e-Ryp0~LG6]0                                                   00000003E ?ITPUB个人空间#M3~*L_nR3?n&i/J
                                                   FFFFFFFF7FFF42F8 ?ITPUB个人空间!T&dA{KxE
                                                   1031D56C8 ?
ReA(u+Z(|/\#`7S0ssexhd()+604         CALL     ksedmp()+0           000000000 ? 000103400 ?ITPUB个人空间V'K2[
YWzB
                                                   0001035D9 ?000102C00 ?
T[2SQK0                                                   1035D9000 ? 1035D9C28 ?ITPUB个人空间:p3~e+CMxQ$?v(S
sigacthandler()+44   PTR_CALL 0000000000000000     1035E1000 ?
ZuTy7DZ t)b/t0                                                   FFFFFFFF7FFF5290 ?ITPUB个人空间4U~i2|;in8x `
                                                   000000000 ? 000000001 ?
2G/K&QSt(h f&P Y9h-Y0                                                   1035DEDD8 ? 00000000B ?ITPUB个人空间R*V3E_/` BC!k^
qmurdBufOradbOpen()  PTR_CALL 0000000000000000     00000000B ?
Tj P
D5QN$o0+500                                               FFFFFFFF7FFF5290 ?
?;\/aW d0                                                   FFFFFFFF7FFF4FB0 ?ITPUB个人空间&B(SC s"k]n:L*|I
                                                   00000000B ? 000000000 ?ITPUB个人空间\$R4G R/Z
                                                   FFFFFFFF7FFF54B1 ?
a1xi-iQ R.RS0LpxbufPushSource()+  PTR_CALL 0000000000000000     FFFFFFFF7C560870 ?ITPUB个人空间1p2ui.z4q5}k-o
116                                                FFFFFFFF7FFF5700 ?
H9U)]"Lom^P0                                                   FFFFFFFF7FFF7B00 ?
h
iG"]a^r3p't3q;|'t(\0                                                   00000000E ?
Z}&|K;G0                                                   FFFFFFFF7FFF54B8 ?ITPUB个人空间.\6R$@4pf
                                                  00000000F?ITPUB个人空间.e*Oh$yzJb*s
LpxbufPushURL()+584  CALL     LpxbufPushSource()+  FFFFFFFF7C560870 ?
I L8x5|G"W a0                              0                    FFFFFFFF7C561DF8 ?
R"k#a-Ta,E0                                                   FFFFFFFF7FFF5700 ?
W%`$~2tQNaS0                                                   FFFFFFFF7C5B0CF0 ?
5}-q^!`(?\DW0                                                   000000000 ?
&V]&l ^oz'[(c)is0                                                   FFFFFFFF7C561250 ?

在metalink中仅查询到一条bug信息包含错误函数qmurdBufOradbOpen：Doc ID: Note:2469137.9。

这条记录的描述和当前情况的相似度还是比较高的，首先数据库的版本类似，都是920版本，且7445错误都是由于调用DBMS_METADATA.GET_DDL造成的。而且随后的一些错误函数名称都是一致的。

最大的不同在于，伴随7445错误出现的其他错误信息不同。当前环境下出现的错误是ORA-932：不一致的数据类型。而metalink文章中的错误是ORA-3237。

根据文档的描述和个人的推测，这种问题是在DBMS_METADATA.GET_DDL执行过程中引发的错误造成的不过Oracle在处理异常的时候有些小bug，从而引发了7445错误。

根据metalink的描述，这个问题在10g中解决。这个错误很难重现，而且对系统的影响不大。