General
cancel
Showing results for 
Search instead for 
Did you mean: 

HP Compiler bug affects all Oracle 9i releases

Stephen Andreassend
Regular Advisor

HP Compiler bug affects all Oracle 9i releases

Has anyone got any experience with this issue?

Please consider the following note from Oracle:

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 : 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.
6 REPLIES
Stephen Andreassend
Regular Advisor

Re: HP Compiler bug affects all Oracle 9i releases

It has also been reported that:

DIAGNOSTIC ANALYSIS:
--------------------
It was found the problem were centered around MACRO CLRSTRUCT() ==> memset()
HP provided the compiler patches for this issue , But PLE has not included
this into 9.2 patchsets . Due to other issues found with the provided compiler
patch.

WORKAROUND:
-----------
Compile the source files without +Olibcalls compiler options
Stephen Andreassend
Regular Advisor

Re: HP Compiler bug affects all Oracle 9i releases

It has also been reported that:

"The kernel/compiler patch fix for this issue is not available in the B.11.01.21
(version used for 9ir2) and is available only with the later version. In the
version B.11.11.04 which is used for 10i we have fix."
Sathish C
Frequent Advisor

Re: HP Compiler bug affects all Oracle 9i releases

Hi
You need to download a patch which is particularly for HP-Compiler problem with oracle 9i , I have attached the document for you . After I have patched this the problem was solved .


SC
Some cause happiness wherever they go; others, whenever they go
Stephen Andreassend
Regular Advisor

Re: HP Compiler bug affects all Oracle 9i releases

Thanks but your document was copied and pasted above in the first post, and the patch is already installed.

We are getting these errors specifically, which causes the PMON to spin and DBWR to abort the instance:

ORA-07445: exception encountered: core dump [kghispih()+28] [SIGSEGV] [unknown code] [0x20000160012] [] []
ORA-07445: exception encountered: core dump [kghuph_flg()+116] [SIGSEGV] [unknown code] [0x20000160012] [] []

These modules do not appear to be listed in the fixed module list in the patch however.
Zeev Schultz
Honored Contributor

Re: HP Compiler bug affects all Oracle 9i releases

1)Did you try to debug (acc. to Oracle doc)
and check the offsets you posted here:

ORA-07445: exception encountered: core dump [kghispih()+28] [SIGSEGV] [unknown code] [0x20000160012] [] []
ORA-07445: exception encountered: core dump [kghuph_flg()+116] [SIGSEGV] [unknown code] [0x20000160012] [] []

With gdb?

2)SIGSEGV usually comes after segment violation (ie size is not big enough),this is shouldn't be a problem with 64bit hp-ux,
are you sure this is the one you have there?
A nice idea would be :
1)check that you have 64bit OS
2)use tool like Glance to monitor memory regions of pmon (one that crashes?) and check that is not going over its limits.
So computers don't think yet. At least not chess computers. - Seymour Cray
Stephen Andreassend
Regular Advisor

Re: HP Compiler bug affects all Oracle 9i releases

Some good clues, thanks for that!

Tried gdb, the "stdby" was not found, the lines referred to a "ldd" call instead. So it may not be this particular HP/Oracle bug but rather an environmental bug as you suggest.