<< Back to previous view

[QA-21] ORA-07445 [11]: SMON crashed. Created: 15/Jul/07  Updated: 16/Sep/07

Status: Closed
Project: Questions & Answers
Fix Version/s: None

Type: Oracle - Internals Priority: Major
Reporter: ubTools Support Assignee: ubTools Support
Resolution: Answered Votes: 0

Product Version: 8.1.7.1.0
Operating System: HP-UX
Operating System Version: B.11.00

 Description   
ORA-07445 [11]: SMON crashed.

 Comments   
Comment by ubTools Support [ 15/Jul/07 05:23 PM ]

Error code:

 
ORA-07445: exception encountered: core dump [11] [3221212616] [240] [0] [] []

Oracle kernel function from which the problem is raised:

 
kdb4_dup_keys().

This is a function of Oracle Data Layer.

Cursor dump:

 
********************   Cursor Dump   ************************
Current cursor: 1, pgadep: 1
  pgactx: c00000014e736d90 ctxcbk: c00000014e776720 ctxqbc: 0 ctxrws: c00000014e7253c8
Cursor Dump:
----------------------------------------
Cursor 1 (80000001000befe8): CURBOUND  curiob: 80000001000c1358
curflg: 5 curpar: 0 curusr: 0 curses c00000012c18a070
cursor name: delete from uet$ where ts#=:1 and segfile#=:2 and segblock#=:3 and ext#=:4
child pin: c00000013511e670, child lock: c00000013511d630, parent lock: c00000013511d6a0
xscflg: 20100466, parent handle: c00000014e748b20, xscfl2: 5100400
 nxt: 3.0x00000560  nxt: 2.0x000005e0  nxt: 1.0x000005e0
Cursor frame allocation dump:
frm: -------- Comment --------  Size  Seg Off
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
  bfp=80000001000d2470 bln=22 avl=02 flg=05
  value=1
bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
  bfp=80000001000d2440 bln=24 avl=02 flg=05
  value=2
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
  bfp=80000001000d2410 bln=24 avl=02 flg=05
  value=2
bind 3: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
  bfp=80000001000d23e0 bln=24 avl=02 flg=05
  value=59
End of cursor dump

Recomendation:

Check if sys.uet$ is corrupted.

Bug:

Bug:2106455 SMON CRASHES WITH ORA-07445 IN KDB4_DUP_KEYS

Generated at Mon Sep 15 23:20:06 UTC 2025 using JIRA Standard Edition, Version: 3.12.3-#302.