topic Re: core dump on sqlplus in Operating System - HP-UX

core dump on sqlplus

tom quach_1 — Thu, 19 Nov 2009 18:42:02 GMT

Dear,

when developer ran a query on db 10g HPUX 11.31
he received a coredump. if i modify (reduce what he want to retrieve) the query and run it, then it is fine.
Would someone please advise which kernel parameter i need to adjust to fix the coredump issue.
Thanks in advance.
Tom

Re: core dump on sqlplus

Matti_Kurkela — Thu, 19 Nov 2009 18:58:38 GMT

A well-behaved program should never dump core because of too much data; it should display a clear error message instead.

You may have found a bug in sqlplus.

Have Oracle support analyze the case, so that a real fix can be developed. They can also tell you if a workaround is possible.

Depending on the root causes of the core dump, the workaround may be a kernel parameter adjustment or something completely different.

MK

Re: core dump on sqlplus

tom quach_1 — Thu, 19 Nov 2009 19:03:51 GMT

Thanks MK for your advice.

Re: core dump on sqlplus

Aneesh Mohan — Thu, 19 Nov 2009 19:08:22 GMT

>>if i modify (reduce what he want to retrieve) the query and run it, then it is fine

a few thoughts ..

a) Could be the user profile limitting the resources .

b)Check the active resource_manager_plan in your database and confirm this is not limiting your queries

c) what was the message in alert log at the time of core dump.

d) How is the system resources ?

Aneesh

Re: core dump on sqlplus

tom quach_1 — Thu, 19 Nov 2009 19:34:21 GMT

Thanks Aneesh,

i ran the same query on the database server itself, the query ran fine, ran the query on the test database and it also ran fine.
but when running the same query from a remote client (hpux 11.31) i got the coredump.
i was thinking about some kernel parameter that i need to adjust on remote client.

Thanks,
Tom

Re: core dump on sqlplus

Jean-Luc Oudart — Fri, 20 Nov 2009 11:36:53 GMT

Tom

there was a recent thread on this subject.
Not sure if this is similar but would be worth checking.
http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=1376992

Regards
Jean-Luc

Re: core dump on sqlplus

Eric Antunes — Fri, 20 Nov 2009 12:42:25 GMT

Hi Tom,

Is there any ORA error message on alert.log?

What is the database exect version? 10...? Do you have RAC?

Why do you think it is a kernel issue?

Regards,

Eric Antunes

Re: core dump on sqlplus

tom quach_1 — Tue, 24 Nov 2009 19:34:05 GMT

Thanks Jean-luc the link was not relevant to this case.
Thanks Eric, --there were not errors in alert.log, i am using 10g R2 10.2.0.4 with RAC

Why do you think it is a kernel issue?<--not sure about this, but most of the coredump was related to resource???
it run fine on the same server connection but not for remote connection...
Thanks for your helps.
Tom

Re: core dump on sqlplus

Dennis Handly — Wed, 25 Nov 2009 00:50:50 GMT

>Eric:Why do you think it is a kernel issue?

>not sure about this, but most of the coredump was related to resource?

Do you know what signal cause the coredump?
Various signals could be related to limitations or more likely bad programming.

Signal 6, SIGABRT, is most likely a software error or configuration issue. There may be a message to stderr explaining the problem.

Re: core dump on sqlplus

Eric Antunes — Wed, 02 Dec 2009 11:22:30 GMT

Hi Tom,

Go to the core file directory and execute:

"file core"

What do you get?

What is the size of your physical memory?

What values/formulas do you have for kernel parameters bufpages, dbc_min_pct, dbc_max_pct, maxfiles, maxfiles_lim, nfile, nflocks, ninode, maxswapchunks, maxswapchunks, swapmem_on, swchunk, vps_ceiling, maxdsiz and maxdsiz_64bit, maxssiz and maxssiz_64bit, maxtsiz and maxtsiz_64bit, maxuprc
, max_thread_proc, nkthread and nproc?

Best Regards,

Eric Antunes