- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: HP 11.31 with oracle 10g
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
тАО07-18-2008 04:35 AM
тАО07-18-2008 04:35 AM
Errors in file /apps/oracle/admin/pics01/udump/pics01_ora_13040.trc:
Errors in file /apps/oracle/admin/pics01/udump/pics01_ora_8159.trc:
ORA-00600: internal error code, arguments: [kxfpqsod_qc_sod], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kxfpqsod_qc_sod], [], [], [], [], [], [], []
I talked to oracle about this issue they couldn't help me, they wanted me to reproduce this error to wrong the same sql statement which I couldn't. Then they suggested me to upgrade to oracle 10.2.0.4, my current oracle version is 10.2.0.3.
Two nights ago, couple of our production line application were frozen, and there was an ORA-01013 user request cancel.
I checked the system, there has no locks and waiting, we rebooted the machine which runs the utility of applications, still couldn't resolve the problem. So i had to reboot the unix server, after that everything was running normal.
Has anyone else had this similar issue? Which Kernel parameters should I change? or which HP patches should I apply? Please help!
Leah
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-18-2008 05:05 AM
тАО07-18-2008 05:05 AM
Re: HP 11.31 with oracle 10g
HP IA64 HP Server RX6600
Leah
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-18-2008 09:07 AM
тАО07-18-2008 09:07 AM
SolutionI would suggest that you do further online monitoring using the Oracle Enterprise Manager Database Control.
if you are *lucky* you will be able to view the database performance when the problem occurs.
Normally, Ora-600 error are better handled by Oracle Support (Metalink).
Upgrade to 10.2.0.4 would not be a bad idea afterall.
good luck!
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-20-2008 11:21 AM
тАО07-20-2008 11:21 AM
Re: HP 11.31 with oracle 10g
I'd suggest to check if there are any invalid objects on DBA_OBJECTS or perhaps you might have any invalid indexes and reconstructing them might help.
But normally ORA-600 are very weird, and only Oracle Support can troubleshoot them.
BRs,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-21-2008 02:07 AM
тАО07-21-2008 02:07 AM
Re: HP 11.31 with oracle 10g
There is a one-off patch for a similar issue - patch 6954722 - but I agree with Yogeeraj and would upgrade to patchset 10.2.0.4.
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-21-2008 05:20 AM
тАО07-21-2008 05:20 AM
Re: HP 11.31 with oracle 10g
Leah