Memory Error Fault (coredump)

[Shahbaz_1]

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

[Steven Sim Kok Leong]

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

[Shahbaz_1]

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

[Steve Steel · Accepted solution]

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

[harry d brown jr]

Syed,

type in kmtune, and post the results here.

live free or die
harry

[Andreas D. Skjervold]

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

[Shahbaz_1]

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

[Steven Sim Kok Leong]

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

[Ravi_8]

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

[Shahbaz_1]

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

[Steven Sim Kok Leong]

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

[Ravi_8]

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