|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
*********************
Wed May 27 13:11:47 2009
Errors
in
file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc:
ORA-07445: exception encountered: core dump [memset()+116] [SIGSEGV] [Address
not
mapped
to
object] [0] [] []
From
Trace file
********************
Dump file /u01/app/oracle/admin/proa021/udump/proa021_ora_9533.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With
the Partitioning
option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /u01/app/oracle/product/817proa021
System
name
: SunOS
Node
name
: v08k01
Release: 5.8
Version: Generic_117350-38
Machine: sun4u
Instance
name
: proa021
Redo thread mounted
by
this instance: 1
Process Info
******************
Oracle process number: 117
Unix process pid: 9533, image: oracle@v08k01 (TNS V1-V3)
Error
*********
2009-05-27 13:11:47.847
ksedmp: internal
or
fatal error
ORA-07445: exception encountered: core dump [memset()+116] [SIGSEGV] [Address
not
mapped
to
object] [0] [] []
Current
SQL(
Current
SQL statement
for
this session)
***********************************************************************
:
SELECT
COUNT
(PO_LINE_ID)
FROM
PO_LINES_INTERFACE
WHERE
PO_HEADER_ID = :b1
Call Stack functions
*************************
ksedmp <- ssexhd <- sigacthandler <- memset
#####################################################################################
From
Alert logfile
*********************
Wed May 27 13:18:39 2009
Errors
in
file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc:
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Wed May 27 13:18:56 2009
Errors
in
file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc:
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
From
Tracefile
*******************
Dump file /u01/app/oracle/admin/proa021/bdump/proa021_pmon_9584.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With
the Partitioning
option
JServer Release 8.1.7.4.0 - Production
ORACLE_HOME = /u01/app/oracle/product/817proa021
System
name
: SunOS
Node
name
: v08k01
Release: 5.8
Version: Generic_117350-38
Machine: sun4u
Instance
name
: proa021
Redo thread mounted
by
this instance: 1
Process Info
****************
Oracle process number: 2
Unix process pid: 9584, image: oracle@v08k01 (PMON)
Error
********
2009-05-27 13:18:39.766
ksedmp: internal
or
fatal error
ORA-00600: internal error code, arguments: [1115], [], [], [], [], [], [], []
Call Stack Functions:
****************************
ksedmp <- kgeriv <- kgesiv <- ksesic0 <- kssdch
<- ksuxds <- kssxdl <- kssdch <- ksudlp <- kssxdl
<- ksuxdl <- ksuxda <- ksucln <- ksbrdp <- opirip
<- opidrv <- sou2o <- main <- start
CURRENT
SESSION'S INSTANTIATION STATE
*********************************************************
current
session=8c8fdfbc
---- Cursor Dump ------
Current
cursor
: 0, pgadep: 0
Cursor
Dump:
End
of
cursor
dump
END
OF
PROCESS STATE
********************
Cursor
Dump ************************
Current
cursor
: 0, pgadep: 0
Cursor
Dump:
End
of
cursor
dump
ksedmp:
no
current
context area
|
ERROR: ORA-600 [1115] VERSIONS: versions 6.0 to 10.1 DESCRIPTION: We are encountering a problem while cleaning up a state object. The State Object is already on free list or has the wrong parent State Object. FUNCTIONALITY: Kernal Service State object manager IMPACT: POSSIBLE INSTANCE FAILURE PROCESS FAILURE NON CORRUPTIVE - No underlying data corruption. SUGGESTIONS: This error may be reported as a direct result of another earlier problem. Lot of bugs reported Bug 3837965 : Abstract: ORA-7445'S AND 600'S LEADING UP TO DB CRASH Comp Version: 8.1.7.4.0 Fixed In Version: 9.2.0. ------------------------------------------------------------- Bug 3134843 : Abstract: ORACLE PROCESSES CRASHING WITH ORA-7445 SEGVIO ON A NUMBER OF DATABASES Comp Version: 8.1.7.4 Status: Closed, could not be reproduced ---------------------------------------------------------------- Bug 2760836: Abstract: PMON cleanup of dead shared servers/dispatchers can crash instance(OERI:26599 / OERI 1115) -------------------------------------------------------------- Note 2760836.8 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI 26599 / OERI 1115) ---------------------------------------------------------------- PROPOSED SOLUTION JUSTIFICATION(S) ================================== 1. One-off patch for Bug 2760836 has fixed this issue...so after customer apply the one-off patch...then this issue will be solved. OR 2. 9.2.0.4 or later version has fixed this issue...so after customer upgrade to at least 9.2.0.4 version...then this issue will be solved. The solution can be justified by the followings: Note 2760836.8 PMON cleanup of dead shared servers/dispatchers can crash instance (OERI 26599 / OERI 1115)
本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1276752
