ORA-7445(ACCESS_VIOLATION)(unable_to_trans_pc)(UNABLE_TO_WRITE)错误

标题比较长，没有办法，错误产生的时候出现的有意义的告警信息就是如此。

在同事的笔记本上出现，WindowsXP环境，在metalink上查询了一下，类似的错误还不少，而且基本上都是windows环境。这个错误发生之前只有一个操作，就是数据库建立。也就是说，在DBCA建库完成后，执行了一个SHUTDOWN操作，在SHUTDOWN快要结束的时候，出现了这个ORA-7445错误。

日志中的错误信息为：

Fri Jun 27 16:22:45 2008ITPUB个人空间Dg,HhiGm
E)qp
Shutting down instance: further logons disabled
9Q.w+\J"g%U3d8s1?0Fri Jun 27 16:22:46 2008ITPUB个人空间!]Td}9W1_/Y1o @-_'c
Stopping background process QMNC
:T&~"?*KAmT#@0Fri Jun 27 16:22:47 2008ITPUB个人空间l3\:G%l @N%NA
Stopping background process CJQ0
5^)U}0~c.J~R2FH.[0Fri Jun 27 16:22:48 2008ITPUB个人空间X;r4z[z&oU E']s
Stopping background process MMNLITPUB个人空间1P'jWU3Rj!Jg
Fri Jun 27 16:22:49 2008ITPUB个人空间]w|~r @J(s
Stopping background process MMONITPUB个人空间*Yf3Qn*w F4D
Fri Jun 27 16:22:50 2008ITPUB个人空间t l1X~ m(fx
Shutting down instance (immediate)ITPUB个人空间Z$R7@` r`6n
License high water mark = 15ITPUB个人空间n\Gi1Y @8K
Fri Jun 27 16:22:50 2008ITPUB个人空间,XY#kyl"GL-a bZ
Stopping Job queue slave processes, flags = 7
2P B6flX^0Fri Jun 27 16:22:50 2008
u!z(rp9m0Job queue slave processes stopped
)I{&~.r ]0_0Fri Jun 27 16:22:53 2008ITPUB个人空间P6|!w(gv!n8r&o!E
ALTER DATABASE CLOSE NORMAL
6LeG2V IU/L0Fri Jun 27 16:22:53 2008
-lNz$K.c&xh0T0SMON: disabling tx recoveryITPUB个人空间k-D3O2`:L
SMON: disabling cache recoveryITPUB个人空间#r;q&o k(dqg
Y
Fri Jun 27 16:22:54 2008
+o8b0|*s.W,M_0Shutting down archive processesITPUB个人空间g/RsL*V6S
Archiving is disabledITPUB个人空间*M6@%](J ite,X
Fri Jun 27 16:22:59 2008ITPUB个人空间`#a"v+gE SC-K
ARCH shutting downITPUB个人空间%ypM;{ h!G
ARC1: Archival stopped
$_viK;c(I.TF~fl0Fri Jun 27 16:23:04 2008
!ml2MeW!D`#_#P0ARCH shutting downITPUB个人空间iR3M)H$x f9`
ARC0: Archival stopped
6M(F)@y,ex:M
l1B)L0Fri Jun 27 16:23:05 2008ITPUB个人空间8^'?Iz!D poz
Thread 1 closed at log sequence 32
aq8p"pK0Successful close of redo thread 1ITPUB个人空间!?{8iO:F8t
T
Fri Jun 27 16:23:05 2008ITPUB个人空间q#n*MIG,k*I&Am
Completed: ALTER DATABASE CLOSE NORMAL
-d8`.w'_4Q,B(|'L\0Fri Jun 27 16:23:05 2008
U9u9d/jH3r0B0ALTER DATABASE DISMOUNTITPUB个人空间hy([:@"o(E
Completed: ALTER DATABASE DISMOUNT
{(kR~U0ARCH: Archival disabled due to shutdown: 1089ITPUB个人空间~@miH.h0W\$V
Shutting down archive processes
ZDo*i8[tc0~@ q0Archiving is disabledITPUB个人空间_P ?yn5~Mv
Archive process shutdown avoided: 0 active
(T`
s$r8tM}0ARCH: Archival disabled due to shutdown: 1089ITPUB个人空间;Zl Y)X"mP6H
Shutting down archive processesITPUB个人空间 dB*\:SKp,\7_m#g
Archiving is disabled
*l3M U&W:Zc J0Archive process shutdown avoided: 0 activeITPUB个人空间2v2JxG3Oo(u
Fri Jun 27 16:28:13 2008
C"j(fJy0Errors in file e:\oracle\product\10.2.0\db_1\rdbms\trace\jssweb_ora_5588.trc:ITPUB个人空间9i|?,k;|\t%S8K
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C9306C3] [ADDR:0x650051] [UNABLE_TO_WRITE] []

而对应的trace文件中的信息为：

Oracle Database10gEnterprise Edition Release10.2.0.4.0 - ProductionITPUB个人空间.C|6S6[B{3`+^5p
With the Partitioning, OLAP, Data Mining and Real Application Testing options
9b:k"N9s2ew
d;Z0Windows XP Version V5.1 Service Pack 2ITPUB个人空间8E4o#A#V du
CPU                 : 2 - type 586ITPUB个人空间9fdA%_N,^
Process Affinity    : 0x00000000ITPUB个人空间!E N
K1me)Ol
Memory (Avail/Total): Ph:1042M/2030M, Ph+PgF:3022M/3906M, VA:1902M/2047MITPUB个人空间t w'} w"A2m r
Instance name: jssweb

Redo thread mounted by this instance: 0 <none>

Oracle process number: 0

Windows thread id: 5588, image: ORACLE.EXE (SHAD)

ITPUB个人空间/d8lR,qg"gr;v$n J
*** 2008-06-27 16:28:13.109
0TW ?I/G
\8o.b0ksedmp: internal or fatal error
U5|5j!lZ;p cs2S0ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [unable_to_trans_pc] [PC:0x7C9306C3] [ADDR:0x650051] [UNABLE_TO_WRITE] []
7VF-R#uNo4]R
vST3O0Current SQL information unavailable - no SGA.ITPUB个人空间3rWK
t7q
check trace file e:\oracle\product\10.2.0\db_1\rdbms\trace\jssweb_ora_0.trc for preloading .sym file messages
AB^ zj0----- Call Stack Trace -----
#E
quA%kD0calling              call     entry                argument values in hex     
#Jj0N:L3?p#XW
i0location             type     point                (? means dubious value)    ITPUB个人空间|hn3r|)By
-------------------- -------- -------------------- ----------------------------
(o5o0sxqP7Zw7u07C9306C3                      00000000            ITPUB个人空间%kGeRx0CG-]6b
77E58179             CALL???  00000000            ITPUB个人空间 Q q
T]x%w*y0BO3e[
77E5814B             CALLrel  77E58157            
|7WK5{L'xd3Pm077E5E272             CALLrel  77E58143            ITPUB个人空间:^7A}9Ts7Mr
77E5EB6B             CALLrel  77E5E251            ITPUB个人空间4~e-Hj)? {9L.w;u
77E5E946             CALLrel  77E5E2A6            
N*{MYk\(|6u076EF3320             CALLreg  00000000            ITPUB个人空间0kJ RR ~kB)MR|
77E5EA17             CALLreg  00000000            ITPUB个人空间-o]f7{T0A,{~-}
77E5EA42             CALLrel  77E5E995            
V|-^tn&SDm
L077ED4588             CALLrel  77E59843            
/NO@'x m0YpK;g076EF7F97             CALLrel  76EF2D78             76EF2E88 76EF2B68 6D97410ITPUB个人空间^
k!EMj3I L
76EF7F37             CALLrel  76EF7F81            
.v!t|8tQs M,~076EF7EE3             CALLrel  76EF7F0F            ITPUB个人空间;rpJ2Fv9VqE u~
76EF7D21             CALLrel  76EF7DF7            ITPUB个人空间Z?;RW:ck2R
76EF2E26             CALLrel  76EF7CF0            ITPUB个人空间]*D,B8b"F&h z
719CA1E0             CALLrel 719C17AB            
#o:p$y0S/}$~dBh0719CA336             CALLrel  719CA0ED            ITPUB个人空间,lY$KoeF&~%Z I
71A22FC5             CALLreg  00000000            

h-e9S+\3C7|,k071A22FA3             CALLrel 71A22FB1            ITPUB个人空间~6k*~/c w?'J
71A22F6D             CALLrel 71A22F8C            ITPUB个人空间4c0ONT4? I(?/k;y
71A22F0B             CALLrel 71A22F25            
7t2?~'v+tL"v9X7U
w$xyz071A2576C             CALLrel 71A22E99            
B w~k6D)U.y#WM071A25263             CALLrel 71A2570E            ITPUB个人空间.oQ%bC*DM]Cg
71A2516A             CALLrel 71A251F8            
qBDkB!H'i$j ^062984CED             CALL???  00000000            
(j$vzv_[.s [ Am062982202             CALLrel  62984CCC            81885A0 68D9E0CITPUB个人空间/{B{ZL+[d_
609C4476             CALL???  00000000            ITPUB个人空间-V@4^p:O?S
609AB019             CALLrel 609C436C            ITPUB个人空间r~-kOUE0MF&VG_5O
609B5F6E             CALLrel  609AA858             6D98020 5 6D980E8 6D982F8
*{Gh mf+CQ0                                                   688EC50ITPUB个人空间/g [Q4bGo+g
609B9EF1             CALLrel  609B5E88            ITPUB个人空间dB
v^,fhECpe
609B98E8             CALLrel  609B9EB4            ITPUB个人空间g8J'Jh;|\ h
609BA51D             CALLrel  609B942C            
+N[O"A#\I nC&}06097C425             CALLrel  609BA234            68AC0A4 688EBEC 0 6D99674
hpkdHqg tWUa0                                                  688F1C4 688EC50ITPUB个人空间^UQrF c-u
60978F10             CALLreg  00000000             6D9B048 A60A59F54 10808
v;F&oP-Jc.N0                                                   6D9D7C0 9BFE5E4 9BFE5DCITPUB个人空间Z&^*uye_n0`
                                                   9BFE568 15432949C08AD8 0
M1o&uV't F;QH0                                                   6D99F3860A59FD8ITPUB个人空间"t-usQB1j3CY9rpV
_kpkiadef+73         CALLrel  _osncon+0            6D9FE2D A 10808 6D9D7C0ITPUB个人空间:\9qN-@Q
                                                   9BFE5E4 9BFE5DC 9BFE568ITPUB个人空间2R6\Wjk;`#R
                                                   9BFE618 15432949C08AD8ITPUB个人空间v;I;}^8vd1t
_xupiini+643         CALLreg  00000000            ITPUB个人空间#s"c4V4P1f
_xupiah0+49          CALLrel  _xupiini+0           9BFE540 6D9FE2D A 400 68873D0ITPUB个人空间},ixW?o1?p7R
                                                   68873D0 9BF7EE0
*l1j2j{-~mZ0c\-P0_upiah0+71           CALLrel  _xupiah0+0           9BFE540 6D9FE2D A 400 68873D0
F-?bZ$\C%sN+pm0                                                   68873D0 9BF7EE0
3r0p [-^\
x[P0_kpuatch+1007        CALLrel  _upiah0+0           
@9C0Z(BA&I0_OCIServerAttach+99  CALLrel  _kpuatch+0          ITPUB个人空间&J
FPU
@c
_opiino+622          CALLrel  _OCIServerAttach+0   9BFE4C0 6886D38 6D9FE2D A 400ITPUB个人空间5wp#Q0T:Aa(n
_opiodr+1286         CALLreg  00000000            3C4 6D9FC24
.w2LjU@v0_opidrv+819          CALLrel  _opiodr+0           3C4 6D9FC24 0
*I:[w
h|-pQH^0_sou2o+45            CALLrel  _opidrv+0           3C4 6D9FC24
fO3rcy*w)wx$|_0_opimai_real+112     CALLrel  _sou2o+0             6D9FC183C4 6D9FC24ITPUB个人空间mU_)v k.A
_opimai+92           CALLrel  _opimai_real+0       2 6D9FC50ITPUB个人空间^5B}Z4G g ~ DIZ
_OracleThreadStart@  CALLrel  _opimai+0           ITPUB个人空间7Ag-mlm C\DS
4+726                                             
x c| yS07C80B680             CALLreg  00000000            

METALINK上的解释也包括很多种。个人感觉Doc ID: Note:466370.1这篇文档的现象和描述比较接近。怀疑是操作系统本身的问题导致了Oracle的bug。

这个bug属于偶然出现的，再次重启，关闭数据库并未出现，可能和当时操作系统的状态有关，总的来说，对系统影响不大。