cancel
Showing results for 
Search instead for 
Did you mean: 

Memory Error Fault (coredump)

SOLVED
Go to solution
Shahbaz_1
Regular Advisor

Memory Error Fault (coredump)

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
Let's share the great thing "THE KNOWLEDGE"
11 REPLIES
Steven Sim Kok Leong
Honored Contributor

Re: Memory Error Fault (coredump)

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Shahbaz_1
Regular Advisor

Re: Memory Error Fault (coredump)

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



Let's share the great thing "THE KNOWLEDGE"
Steve Steel
Honored Contributor
Solution

Re: Memory Error Fault (coredump)

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
If you want truly to understand something, try to change it. (Kurt Lewin)
harry d brown jr
Honored Contributor

Re: Memory Error Fault (coredump)

Syed,

type in kmtune, and post the results here.

live free or die
harry
Live Free or Die
Andreas D. Skjervold
Honored Contributor

Re: Memory Error Fault (coredump)

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
Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Shahbaz_1
Regular Advisor

Re: Memory Error Fault (coredump)

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
Let's share the great thing "THE KNOWLEDGE"
Steven Sim Kok Leong
Honored Contributor

Re: Memory Error Fault (coredump)

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Ravi_8
Honored Contributor

Re: Memory Error Fault (coredump)


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

never give up
Shahbaz_1
Regular Advisor

Re: Memory Error Fault (coredump)

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
Let's share the great thing "THE KNOWLEDGE"
Steven Sim Kok Leong
Honored Contributor

Re: Memory Error Fault (coredump)

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Ravi_8
Honored Contributor

Re: Memory Error Fault (coredump)

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
never give up