FAQ
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

Search Discussions

  • Paul Drake at Apr 17, 2007 at 11:42 pm
    Now that I think about it, I was going to download and update opatch
    prior to applying the patchset. Sorry for the premature post there.

    From the very fine readme.html:

    3.2 OPatch Utility Information

    You must use the OPatch utility release 10.2.0.3.1 or later. You can
    download it from Oracle MetaLink with patch 4898608. NOTE: Download
    the 10.2.0.3 version, not the 10.2.0.1 or 10.2.0.2 version.

    Animated cursors still don't belong in OUI.

    Paul
    On 4/17/07, Paul Drake wrote:
    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.
    --
    http://www.freelists.org/webpage/oracle-l
  • Paul Drake at Apr 18, 2007 at 4:19 pm
    reproduced the error, but this time the ora-7445 was [_ksbasend_internal+33].
    database instance will not open after running catcpu.sql and being
    shutdown/restarted.

    avoid this patch.

    (ms w2k3 r2 32 bit, 10g R2 standard edition, 10.2.0.3 patchset,
    10.2.0.3 patch 1 applied, 10.2.0.3 patch 4 applied with opatch
    10.2.0.3.1).

    Paul
    On 4/17/07, Paul Drake wrote:
    Now that I think about it, I was going to download and update opatch
    prior to applying the patchset. Sorry for the premature post there.

    From the very fine readme.html:

    3.2 OPatch Utility Information

    You must use the OPatch utility release 10.2.0.3.1 or later. You can
    download it from Oracle MetaLink with patch 4898608. NOTE: Download
    the 10.2.0.3 version, not the 10.2.0.1 or 10.2.0.2 version.

    Animated cursors still don't belong in OUI.

    Paul


    On 4/17/07, Paul Drake wrote:
    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.
    --
    -----------------------------------------------------------------
    USADA and WADA are broken and not worth fixing. Boycott professional
    sports. Avoid patronizing their advertisers. Don't buy tickets to NBA,
    NFL, MLBB, NHL and especially Pro Cycling.
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedApr 17, '07 at 11:07p
activeApr 18, '07 at 4:19p
posts3
users1
websiteoracle.com

1 user in discussion

Paul Drake: 3 posts

People

Translate

site design / logo © 2022 Grokbase