topic Re: Memory Error Fault (coredump) in Operating System - HP-UX

Memory Error Fault (coredump)

Shahbaz_1 — Wed, 20 Feb 2002 09:54:42 GMT

Hi,
we are running one of our test instnace (oracle database) on HP - K Server with
HP - Unix 11.0. I am able to goto SVRMGRL> but when I try to login to SQLPLUS, I am getting the follwing error

Memory Fault (coredump)
Why so happing any idea ?

Thanks & Regards
Syed

Re: Memory Error Fault (coredump)

Steven Sim Kok Leong — Wed, 20 Feb 2002 10:06:01 GMT

Hi,

What does the output show for:

# file core

Did you re-link your Oracle after installation ie. run root.sh?

Check also your memory-related kernel parameters that they have been finetuned properly to the necessary values eg. maxdsiz, maxssiz, maxtsiz, shmseg, semmni etc etc.

Hope this helps. Regards.

Steven Sim Kok Leong

Re: Memory Error Fault (coredump)

Shahbaz_1 — Wed, 20 Feb 2002 10:34:13 GMT

Hi Steven,
Thanks lot for your help.

# file core
(I got the following output)

core: core file from 'sqlplus' - received SIGSEGV

Well I don't know whether the oracle exe file was re-link or not. I am first time working on this particular server machine.
And where should I check the values for maxdsiz, maxssiz,maxtsix, shmseg,semmni etc
And how should we know that these are properly tuned?

So could you pls ...

Thanks & Regards
Syed

Re: Memory Error Fault (coredump)

Steve Steel — Wed, 20 Feb 2002 11:33:24 GMT

Hi

I would also talk to oracle

A known Oracle problem requires a patch from Oracle with id/number :
"SQLPLUS core dumps after a clean install ..Oracle bug number 1194937

Also known about 8.0.1.5

The answer for Oracle is " This problem is documented in bug 1069320" the
solution is :

upgrade oracle from 8.1.5 to 8.1.7 where the problem is already fixed"

Steve Steel

Re: Memory Error Fault (coredump)

harry d brown jr — Wed, 20 Feb 2002 11:50:24 GMT

Syed,

type in kmtune, and post the results here.

live free or die
harry

Re: Memory Error Fault (coredump)

Andreas D. Skjervold — Wed, 20 Feb 2002 12:20:56 GMT

Hi

I belive to remeber that this might happpen if the maxdsiz parameter is set at a to low value. Should be more than 256M.
If less there is a error when linking the oracle executable.

And ofcourse all the Required Kernel paramteres MUST be set, as well as the requiret patches applied before running Oracle.

Refer to the Release Note:
http://technet.oracle.com/docs/products/oracle8i/pdf/hp-ux_relnotes_817.pdf

http://technet.oracle.com/docs/products/oracle9i/pdf/9i_hp_relnotes.pdf

Andreas

Re: Memory Error Fault (coredump)

Shahbaz_1 — Thu, 21 Feb 2002 04:33:33 GMT

Thanks Everybody
Hi Harry,
First I thank you. You had asked me for the output of kmtune, here I've attached the file.

Regards
Syed

Re: Memory Error Fault (coredump)

Steven Sim Kok Leong — Thu, 21 Feb 2002 05:18:54 GMT

Hi,

Your kernel parameter values from kmtune seem on the low side. Your maxdsiz is 256M, shmmax is 512M etc etc.

Refer to the OS section in the Oracle installation guide which provides the list of recommended values for memory-related kernel parameters.

Hope this helps. Regards.

Steven Sim Kok Leong

Re: Memory Error Fault (coredump)

Ravi_8 — Thu, 21 Feb 2002 05:47:42 GMT

Hi,

Memory fault fault raises due to incorrect kernel tuning.
to avoid this you need to tune the kernel to oracle specified values.
i.e shammax=4GB(4294967295)
shmmin=1
shmmni=100
shmseg=10
semmns=200
semmni=70

then restart the database.

hope this helps

Re: Memory Error Fault (coredump)

Shahbaz_1 — Thu, 21 Feb 2002 06:02:22 GMT

Thanks body,

Can any one please let me know, how should I change the value for maxdsiz and shared memory and semaphres values.
I understand that it is not like solaris where we can change directly in /etc/system and reboot the server.

Regards
Syed

Re: Memory Error Fault (coredump)

Steven Sim Kok Leong — Thu, 21 Feb 2002 06:14:47 GMT

Hi,

The easiest way is to run sam.

# /usr/sbin/sam

Look under kernel configuration.

Please look into the Oracle installation documentation on recommended values for OS kernel parameters before proceeding.

Hope this helps. Regards.

Steven Sim Kok Leong

Re: Memory Error Fault (coredump)

Ravi_8 — Thu, 21 Feb 2002 10:57:46 GMT

Hi,
#sam
-->kernel configuration-->tunable parameters--> choose the parameter you need to change(maxsiz/maxdsiz)-->press tab-->action -->modify -->enter the new values-->ok.

system will build the kernel and reboot