core dump info

[subrata Sur]

I have a application which loads the flat table data to one oracle table . We have only exe right now . Right now it is failed giving the core dump . We get the core dump info (file attched) Can any body tell me whats wrong in the application As i caould not able to debug this core dump info .

[RAC_1]

Looking at the attachment, you are 10.20
It has certain limitations on how much, stack, data and text.

What does "file core" returns??

Anil

[Fred Ruffet]

To have info, you can use "file" command on your system against this core file :
file core
Post the output here.

Regards,

Fred

[subrata Sur]

File core ruturns this info

uamtv007 $ file core
core: core file from 'fred' - received SIGSEGV

[B. Hulst]

Hi,

The command file on the binary that causes the fault could also be helpfull.

It could tell you if the binary is stripped or not. If not then there is debug information in the binary and sometimes you can use a debugger (gdb or dbg) to trace it.

Also running (strongly not recommended!)

#strings core > core_readable_output.log

and then view the log file...
might give you a clue. Might...

Regards,
Bob

[RAC_1]

SIGSEGV is a segmentation violation. What are your values for maxssiz, maxtsiz, maxdsiz and shmmax??

Also you can get a tool shmmax and run it before and after starting the program. You might be hitting one of those limits.

Anil

[subrata Sur]

Thanx for the suggestion..

Can u tell me how to check that maxssiz, maxtsiz, maxdsiz and shmmax.

And also tell me how to set this this tool to check shmmax...

Also i m sending the core dump readable info ...

[Dave Hutton]

Easiest way on a 10.20 server is looking in sam -> kernel Configuration -> configurable parameters.

Thats the sure fire way I know of doing it. I know /stand/system will also show some values (I think they would have to of been changed from the default to show up in that file). I guess it could also have pending changes too depending on who's messing around in the files.

[RAC_1]

Get shminfo from here.

ftp://contrib:9unsupp8@hprc.external.hp.com/sysadmin/programs/shminfo/shminfo

Start SAM and goto kernel configuration. There you will see configurable kernel parameters.

Anil

[subrata Sur]

We are providing the kernel info for checking

[A. Clay Stephenson]

It appears that all your tunables are at the default values.
I would set max_dbc_pct to ~ 10.
maxssiz to ~ 64MB.
maxdsiz to ~ 512MB.
maxtsiz to ~ 256MB.
shmmax to 1GB.

You really need to see the Oracle Installation instructions for your Oracle Version and OS Release and set the values according to their instructions. I'll bet that you haven't installed the Oracle reccomended patches as well. Your semaphore, shared memory, and messages values also appear to be default and they almost certainly need to be changed as well.
DO YOUR HOMEWORK when you install Oracle.

[RAC_1]

Your values, maxssiz, maxtsiz, maxdsiz and shmmax are too low. Set maxtsiz,maxdsiz and shmmax to 200 mb. Set maxssiz to 100mb

And check.

Anil