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 |
Partager