1748108 Members
4913 Online
108758 Solutions
New Discussion юеВ

core dump on sqlplus

 
tom quach_1
Super Advisor

core dump on sqlplus

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

9 REPLIES 9
Matti_Kurkela
Honored Contributor

Re: core dump on sqlplus

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
MK
tom quach_1
Super Advisor

Re: core dump on sqlplus

Thanks MK for your advice.
Aneesh Mohan
Honored Contributor

Re: core dump on sqlplus

>>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
tom quach_1
Super Advisor

Re: core dump on sqlplus


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


Jean-Luc Oudart
Honored Contributor

Re: core dump on sqlplus

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
fiat lux
Eric Antunes
Honored Contributor

Re: core dump on sqlplus

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
Each and every day is a good day to learn.
tom quach_1
Super Advisor

Re: core dump on sqlplus

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

Dennis Handly
Acclaimed Contributor

Re: core dump on sqlplus

>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.
Eric Antunes
Honored Contributor

Re: core dump on sqlplus

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
Each and every day is a good day to learn.