- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- ora-3113 Error
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
тАО09-27-2002 02:50 PM
тАО09-27-2002 02:50 PM
ora-3113 Error
Oracle's expected response was that it indicated an HP-UX O/S problem.
I have worked with HP Response Center and scanned the Forums. It appears all kernel parameters are fine bot from our perspective and HP Response. (I compared with those mentioned in the forum as well.)
It appears the basics in Oracle, like the env, init, etc. are fine.
In most posts to the forums the issue was resolved via a kernel change or correction of user error.
My question to the forums is -
Aside from the basics what other Oracle related resolutions were discovered.
This db has been running for more than a year on an 11.0 RP7400. Last kernel change was May 2002.
Additional info -
We have noticed memory leak withing the last two months and have scheduled a weekly reboot for this problem. This we know to be oracle related but as yet have not found the exact source.
Oracle 8.1.740
Appreciate any insight. Please forgive me if the points assignments are late since I need to review any responses with the DBA's to assess the level of assistance given.
Regards,
dl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2002 06:02 PM
тАО09-27-2002 06:02 PM
Re: ora-3113 Error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 01:57 PM
тАО09-29-2002 01:57 PM
Re: ora-3113 Error
UNIX95= ps -e -o vsz,pid,ruser,args | sort -rn | more
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2002 03:03 PM
тАО09-29-2002 03:03 PM
Re: ora-3113 Error
Thanks for the starting point.
Our recovery was to go back to a version on business copy from the prior day. Since we lost an entire day's of online business, (batch was recovered), and having no answer from Oracle or HP ( no one resonably expects it to be an O/S problem at this point), we know this will happen again.
As noted, I apoligize for late points postings, but will certainly do so when we can follow up on suggested corrections (no way to change points assignments once done).
Thanks again, as DBA's and SA remain on hot seat for a solution.
Regards,
"Newby SA not ready for retirement."
dl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-30-2002 11:56 AM
тАО09-30-2002 11:56 AM
Re: ora-3113 Error
ipcs
If you see segments owned by oracle, and there is only one database on the system, you can remove the segments with 'ipcrm' with a '-s' for semaphore segments and a '-m' for shared memory segments.
If you have more than one database on the system, you will want to go to svrmgrl in each database, and run "oradebug" to generate a trace, and find the semaphore and shared memory segments associated with the databases running, and find the one that should not be there.
Hope this helps,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2002 01:53 AM
тАО10-01-2002 01:53 AM
Re: ora-3113 Error
It must be that the shared memory segments are not properly cleaned up and there are also some defunct processes running on the machine.
YOu have you check your memory segments using ipcs to see the shared memory,semaphores owned by oracle.
remove them by using ipcrm.
Also
check your semmns parameter
It might be the no. of processes defined in the init.ora file of the instance is exceeding semmns.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2002 01:55 AM
тАО10-01-2002 01:55 AM
Re: ora-3113 Error
It must be that the shared memory segments are not properly cleaned up and there are also some defunct processes running on the machine.
YOu have you check your memory segments using ipcs to see the shared memory,semaphores owned by oracle.
remove them by using ipcrm.
Also
check your semmns parameter
It might be the no. of processes defined in the init.ora file of the instance is exceeding semmns.
Try reducing the value for the processes parameter.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-01-2002 08:18 AM
тАО10-01-2002 08:18 AM
Re: ora-3113 Error
Thanks for the input. We are still digging as is HP and Oracle Support.
We did check with ipcs; it was clean.
The init.ora and semmns were verified by both Oracle and HP to be correct for our instance and environment.
If and when this is solved, I will post HP's/Oracles findings. Cirrently the case has been escalated to the highest HP level; not sure about Oracle.
Again, my apologies for not posting points until we can tie all responses together to give the forum the best audit trail for this problem.
Regards,
dl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2002 11:26 AM
тАО10-04-2002 11:26 AM
Re: ora-3113 Error
HP and Oracle agreed on changes to shmmax and maxssiz_64bit. (Even though they were in place and working for a year as defined with no significant Oracle or HP-UX changes.)
These were put into place last night (10/03) and we will continue to monitor.
No one has a clear definition of the cause so we are doing the "one step at a time".
Will keep this thread updated as events occur.
dl
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-11-2002 11:09 AM
тАО10-11-2002 11:09 AM
Re: ora-3113 Error
Should this be resolved I will post results.
In the meantime, we are expecting a reoccurrence.
Thanks for all the valid answers of things to check.
dl