[#QA-21] ORA-07445 [11]: SMON crashed.

Questions & Answers

ORA-07445 [11]: SMON crashed.

Created: 15/Jul/07 05:19 PM Updated: 16/Sep/07 04:27 PM

Fix Version/s:

None

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

Description

« Hide

ORA-07445 [11]: SMON crashed.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

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