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

Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

Yogeeraj
Advisor

Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

Hello experts,

I am running Oracle 8.1.7 on HP-UX 11 64-bits. I see core files generated almost everyday on my system because of some process crash.
(see details below)

I really don't know what to do.

Anyone Please advise.
Thanks for you replies
Regards
Yogeeraj
===============================================
L-oracle8i: d01/app/oracle/admin/cmtdb/cdump>date
Wed Jan 9 13:31:13 MRU 2002
L-oracle8i: d01/app/oracle/admin/cmtdb/cdump>ll -rtl
total 0
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:42 core_26667
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:46 core_8929
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:51 core_26595
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:51 core_8931
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:51 core_9825
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:51 core_8927
drwxrwxrwx 2 oracle8i dba 96 Sep 19 11:51 core_9929
drwxrwxrwx 2 oracle8i dba 96 Sep 27 17:11 core_25816
drwxrwxrwx 2 oracle8i dba 96 Oct 22 17:05 core_19652
drwxrwxrwx 2 oracle8i dba 96 Dec 20 16:56 core_3175
drwxrwxrwx 2 oracle8i dba 96 Dec 21 09:17 core_3179
drwxrwxrwx 2 oracle8i dba 96 Dec 22 10:20 core_3037
drwxrwxrwx 2 oracle8i dba 96 Dec 24 10:46 core_13705
drwxrwxrwx 2 oracle8i dba 96 Dec 29 09:01 core_3181
drwxrwxrwx 2 oracle8i dba 96 Dec 31 08:47 core_13076
drwxrwxrwx 2 oracle8i dba 96 Jan 3 15:48 core_2279
drwxrwxrwx 2 oracle8i dba 96 Jan 5 11:59 core_2281
drwxrwxrwx 2 oracle8i dba 96 Jan 7 10:40 core_27248
drwxrwxrwx 2 oracle8i dba 96 Jan 7 11:22 core_17752
drwxrwxrwx 2 oracle8i dba 96 Jan 7 12:43 core_18554
drwxrwxrwx 2 oracle8i dba 96 Jan 7 13:23 core_2283
drwxrwxrwx 2 oracle8i dba 96 Jan 8 11:16 core_20212
L-oracle8i: d01/app/oracle/admin/cmtdb/cdump>
______________________________________________________________

L-oracle8i: d01/app/oracle/admin/cmtdb/cdump>file core*/*
core_13076/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_13705/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_17752/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_18554/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_19652/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_20212/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_2279/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_2281/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_2283/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_25816/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_26595/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_26667/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_27248/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_3037/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_3175/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_3179/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_3181/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_8927/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_8929/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_8931/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_9825/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
core_9929/core: ELF-64 core file - PA-RISC 2.0 from 'oracle' - received SIGABRT
L-oracle8i: d01/app/oracle/admin/cmtdb/cdump>
4 REPLIES
Helen French
Honored Contributor

Re: Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

A. Clay Stephenson
Acclaimed Contributor

Re: Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

Hi:

I have been running 8.1.7 on 11x for quite a while withiut problems. The first things I would check are:

1) required patches
Oracle suggests these but make sure that they are not superceded:
PHSS_21947 (ld(1) and linker tools cumulative patch)
PHNE_20316 (Cumulative STREAMS Patch)
PHKL_21392 (VxFS performance, hang, icache DPFs)
PHKL_22145 (signal, threads, spinlock, scheduler, IDS)
PHKL_22266 (LVM Cumulative Patch)


2) Make sure that you have tuned the kernel to the minumum suggested in the Installation Guide.

You will probably find more helpful information at http://suport.oracle.com.
If it ain't broke, I can fix that.
Wodisch
Honored Contributor

Re: Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

Hello,

you have to relink Oracle every time you have installed patches for system libraries used by the Oracle runtime:
$ORACLE_HOME/bin/relink

My guess is that you have installed Oracle earlier (and perhaps not re-linked at all) and hence your Oracle is using the old (and hence invalid) versions hard-linked into it...

Just my $0.02,
Wodisch
Yogeeraj
Advisor

Re: Frequent Core dumps on my oracle 8.1.7 on HP-UX 11 64bits

Hi A.Clay Stephenson and Wodisch,

thanks very much for your replies.

I think i will look in the direction that you are guiding me.

I will repost my observations later.

Any more observations will be most welcomed.

thanks again
Yogeeraj