- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- core dump on sqlplus
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2009 10:42 AM
тАО11-19-2009 10:42 AM
core dump on sqlplus
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2009 10:58 AM
тАО11-19-2009 10:58 AM
Re: core dump on sqlplus
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2009 11:03 AM
тАО11-19-2009 11:03 AM
Re: core dump on sqlplus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2009 11:08 AM
тАО11-19-2009 11:08 AM
Re: core dump on sqlplus
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-19-2009 11:34 AM
тАО11-19-2009 11:34 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2009 03:36 AM
тАО11-20-2009 03:36 AM
Re: core dump on sqlplus
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-20-2009 04:42 AM
тАО11-20-2009 04:42 AM
Re: core dump on sqlplus
Is there any ORA error message on alert
What is the database exect version? 10...? Do you have RAC?
Why do you think it is a kernel issue?
Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2009 11:34 AM
тАО11-24-2009 11:34 AM
Re: core dump on sqlplus
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2009 04:50 PM
тАО11-24-2009 04:50 PM
Re: core dump on sqlplus
>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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-02-2009 03:22 AM
тАО12-02-2009 03:22 AM
Re: core dump on sqlplus
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