- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- HP Compiler bug affects all Oracle 9i releases
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 06:52 PM
тАО04-26-2004 06:52 PM
HP Compiler bug affects all Oracle 9i releases
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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 06:56 PM
тАО04-26-2004 06:56 PM
Re: HP Compiler bug affects all Oracle 9i releases
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-26-2004 06:57 PM
тАО04-26-2004 06:57 PM
Re: HP Compiler bug affects all Oracle 9i releases
"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."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 06:14 PM
тАО04-27-2004 06:14 PM
Re: HP Compiler bug affects all Oracle 9i releases
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 06:33 PM
тАО04-27-2004 06:33 PM
Re: HP Compiler bug affects all Oracle 9i releases
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 08:23 PM
тАО04-27-2004 08:23 PM
Re: HP Compiler bug affects all Oracle 9i releases
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2004 07:31 AM
тАО04-28-2004 07:31 AM
Re: HP Compiler bug affects all Oracle 9i releases
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.