Critical Patch Update for April 2007
p5948242 - 10.2.0.3 patch 4 for MS Win32
I'd think about holding off testing this patch for a few days (wait
for the re-issue).
SMON is taking down the database instance right after startup.
I'll post again if I see what the source of this is but for right now,
this is an opatch rollback and a restore.
ora-7445 lookup and call stack trace lookup are a swing and a miss.
Paul
Dump file d:\oracle\admin\mytest\bdump\mytest_smon_684.trc
Tue Apr 17 17:46:17 2007
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Release 10.2.0.3.0 - Production
Process Id: 0x00000ffc Thread Id : 0x000002ac Time : Tue Apr 17 17:46:17
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000
Registers ----------------------------
eip = 00498d45 esp = 065ca7c8 ebp = 065ca804 edi = c817d1ac esi = 065ccd50
eax = 6cdba610 ebx = 00000001 ecx = 900029d8 edx = 065ca7e4
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 0000003b
eflags = 00010a86
End of Registers ---------------------
Oracle Database 10g Release 10.2.0.3.0 - Production
Windows NT Version V5.2 Service Pack 1
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:6552M/8191M, Ph+PgF:10589M/12076M, VA:1145M/3071M
Instance name: mytest
Redo thread mounted by this instance: 1
Oracle process number: 16
Windows thread id: 684, image: ORACLE.EXE (SMON)
SERVICE NAME:() 2007-04-17 17:46:17.458
SESSION ID:(51.1) 2007-04-17 17:46:17.458
2007-04-17 17:46:17.458
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION]
[_kcbzww+329] [PC:0x498D45] [ADDR:0x70AFC188] [UNABLE_TO_READ] []
Current SQL statement for this session:
select o.owner#,o.obj#,decode(o.linkname,null,
decode(u.name,null,'SYS',u.name),o.remoteowner),
o.name,o.linkname,o.namespace,o.subname from user$ u, obj$ o where
u.user#(+)=o.owner# and o.type#=:1 and not exists (select p_obj# from
dependency$ where p_obj# = o.obj#) order by o.obj# for update
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_kcbzww+329 00000000
_kcbzgb+4728 CALLrel _kcbzww+0 65CCD50
_kcbzib+437 CALLrel _kcbzgb+0
_kcbgtcr+9343 CALLrel _kcbzib+0
_ktrget+445 CALLrel _kcbgtcr+0
_kdifxs1+1879 CALLrel _ktrget+0 970B214 970B0E4 271
_kdifxs+17 CALLrel _kdifxs1+0 970B210 1 0 0 0 0
_qerixtFetch+257 CALLrel _kdifxs+0
_qertbFetchByRowID+ CALL??? 00000000 5A78BEE0 0 65CDB20 1
475
_qerjoFetch+491 CALL??? 00000000 5A78BCC4 0 0 1
_qerflFetchOutside+ CALL??? 00000000 5A755D50 0 0 1
93
_qerfuStart+351 CALL??? 00000000 5A755CD8 0 0 1
_selexe+1568 CALL??? 00000000 5A755C08 1
_opiexe+11440 CALLrel _selexe+0 5AFD24D4 65CE2D0 65CE298
_opiodr+1099 CALLreg 00000000 4 4 65CEC18
_rpidrus+178 CALLrel _opiodr+0 4 4 65CEC18 2
_rpidru+88 CALLrel _rpidrus+0 65CE7A4
_rpiswu2+426 CALLreg 00000000 65CEB6C
_rpidrv+1461 CALLrel _rpiswu2+0 90040490 0 65CEB40 2 65CEB60
0 65CEB40 0 86401C 8640DC
65CEB6C 8
_rpiexe+70 CALLrel _rpidrv+0 2 4 65CEC18 8
_kqlclo1+965 CALLrel _rpiexe+0 2
_kqlclo+155 CALLrel _kqlclo1+0
_ktmmon+5254 CALLrel _kqlclo+0
_ktmSmonMain+21 CALLrel _ktmmon+0 3D49C18
_ksbrdp+808 CALLreg 00000000 3D49C18
_opirip+674 CALLrel _ksbrdp+0
_opidrv+857 CALLrel _opirip+0 32 4 65CFEA8
_sou2o+45 CALLrel _opidrv+0 32 4 65CFEA8
_opimai_real+227 CALLrel _sou2o+0 65CFE9C 32 4 65CFEA8
_opimai+92 CALLrel _opimai_real+0 3 65CFED4
_BackgroundThreadSt CALLrel _opimai+0
art_at_4+495
77E66088 CALLreg 00000000
