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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
Subject: ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX
Doc ID: Note:241160.1 Type: ALERT
Last Revision Date: 25-OCT-2005 Status: PUBLISHED
ALERT: ORA-7445 Signalled from Different Functions on 64-bit HP-UX
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Versions Affected
~~~~~~~~~~~~~~~~~
Oracle RDBMS 9i release 2
Platforms Affected
~~~~~~~~~~~~~~~~~~
64-bit HP-UX version B.11.00 or HP-UX B.11.11.
Description
~~~~~~~~~~~
Errors may be found in the alert.log signalling an ORA-7445 in one of the
functions listed in the 'Symptoms' section below. It is possible that the
instance may crash with these errors.
This is a problem related to the HP compiler.
Likelihood of Occurrence
~~~~~~~~~~~~~~~~~~~~~~~~
The likelihood of hitting this problem is high if you are using Oracle RDBMS
version 9i release 2 on 64-bit HP-UX. The problem is resolved in Oracle RDBMS
version 9.2.0.5, which was built using the fixed compiler.
Possible Symptoms
~~~~~~~~~~~~~~~~~
The symptoms are core dumps in various functions. The following
errors have been reported to date:
ORA-7445: [kkobrak]
ORA-7445: [kkofmx]
ORA-7445: [kkeics]
ORA-7445: [kkeits]
ORA-7445: [qctstin]
ORA-7445: [kdxd4ckf]
ORA-7445: [pdtmsc]
ORA-7445: [kxccsrw]
ORA-7445: [kxfqopn]
ORA-7445: [kkshlcu]
ORA-7445: [updini]
ORA-7445: [delexe]
ORA-7445: [qksopcopyinlist]
ORA-7445: [kprcrm0]
ORA-7445: [ktbgcl1]
ORA-7445: [kokacpc]
ORA-7445: [kkwpovld]
ORA-7445: [knpcdp2_ClearStats]
ORA-7445: [ldxstdnew]
ORA-7445: [koudcon]
ORA-7445: [kxfrgradistalo]
ORA-7445: [kudmpax]
ORA-7445: [ldxeti]
ORA-7445: [prsfsp]
ORA-7445: [horsham_hoadaddmapping]
ORA-7445: [ph2opf_pattern_formals]
ORA-7445: [kokqoxinit]
ORA-7445: [kxfpqrgeb]
While the above errors are the most common, it is possible that the problem
will occur in other modules as well. Please contact Oracle Support Services
if you believe that you are encountering this problem in a module other
than those listed.
To identify whether an ORA-7445 might be a manifestation of this problem do:
1. log onto an HP-UX 64bit machine.
2. select a 9.2 instance
3. cd $ORACLE_HOME/bin
4. gdb oracle
5. Take the argument to the ORA-7445, eg: kkeits and do:
gdb>disassemble kkeits
6. Scroll through the output until you reach the offset indicated in the
argument. In this case it was ORA-7445 [kkeits+228]
Offset 228 shows:
0x40000000018564c4 <kkeits+228>: stdby,e %r0,1(%r26)
If the line shows stdby (set double-byte), in versions up to and including 9.2.0.4, as
it does above then there is a strong possibility that this is an example of the compiler
problem. Please contact support who will log the problem with development.
If you encounter an ORA-7445 in 9.2.0.5 onwards and a disassemble of the failing
function shows stdby this does not indicate a reoccurrence of this problem.
Patches
~~~~~~~
One-off patches have been created for 9.2.0.2, 9.2.0.3 and 9.2.0.4. The
affected Oracle code modules have been rebuilt to workaround the compiler
problem in 9.2.0.2 and 9.2.0.3. The patch for 9.2.0.4 has been rebuilt
using a fix to the HP-UX compiler. The patches address errors in
different functions so please read the information below to determine
which patch to apply.
9.2.0.4
-------
If you are seeing the errors signalled in kkeits, kkeics, updini, delexe,
qksopcopyinlist, kprcrm0, ktbgcl1, kokacpc, ldxstdnew, ldxeti, kkxpovld, koudcon,
horsham_hoadadmapping, kxfrgradistalo, kudmpax, prsfsp, knpcdp2_ClearStats, kokqoxinit,
ph2opf_pattern_formals or kxfpqrget then please download Patch 3065127 for 9.2.0.4.
9.2.0.3
-------
If you are seeing the errors signalled in functions kdxd4ckf, qctstin,
pdtmsc, kkofmx, kkobrak, kkeits, kkeics, kxccsrw, kxfqopn,
kkshlcu, updini, delexe, qksopcopyinlist, ktbgcl1 or knpcdp2_ClearStats
then please download Patch 3065127 for 9.2.0.3. This incorporates the
modules included in the 9.2.0.3 version of 2925233. The fixes for
functions kdxd4ckf, qctstin, pdtmsc, kkofmx, kkobrak, kxccsrw, kxfqopn
and kkshlcu are also incorporated into patch set release 9.2.0.4.
9.2.0.2
-------
If you are seeing the errors signalled in functions
kdxd4ckf, qctstin or pdtmsc then please download Patch 2925233.
Any future fixes will be on top of patch set release 9.2.0.4.
Modification History
~~~~~~~~~~~~~~~~~~~~
2003-12-22 Updated possible symptoms and patches section to include latest
fixes (ph2opf_pattern_formals, kokqoxinit)
2003-12-10 Updated possible symptoms and patches section to include latest
fixes (koudcon, horsham_hoadaddmapping, kxfrgradistalo, kudmpax,
prsfsp, kkxpovld)
2003-11-12 Updated patches section to include details of compiler fix and
add ldxeti to list of possible arguments for 9.2.0.4
2003-08-22 Updated to clarify the issue is fixed in 9.2.0.4
2003-09-23 Updated to include errors encountered in 9.2.0.4 and details
of the patches to apply.
2003-09-29 Updated to include new modules in latest version of
9.2.0.3 patch and to reflect revised 9.2.0.4 patch.
2003-10-07 Updated to include modules ldxstdnew and knpcdp2_ClearStats
in 9.2.0.4 patch and knpcdp2_ClearStats in 9.2.0.3.
2004-03-26 Updated to include module kxfpqrget and information on 9.2.0.5.
KEYWORDS: ALERTINFO COREDUMP HP |
