- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Shared memory probelm with oracle
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
тАО06-21-2005 10:18 PM
тАО06-21-2005 10:18 PM
We've got a strange problem here. We have a 11.11 sysetm running a very lareg Oracle RAC.
We had a situation when our machine crashed. From the dump analysis, it seems as if the DB tried to start and allocate the shared memory twice - hence causing the machine a sever depletion of memory - and a crash.
When we tried to see what happens on shutdown, it seems that sometimes, upon database shutdown, not all DB processes (oracleXXXX) die with the database. Also, the shared memory segment asociated with the database is not removed. We had to manually kill them sometimes.
My question is: does anyone know of this phenomenon? Is it a normal behaviour of oracle to leave active processes after shutdown was completed? how would you solve this? plant a kill in the script?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 11:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 11:37 PM
тАО06-21-2005 11:37 PM
Re: Shared memory probelm with oracle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 11:46 PM
тАО06-21-2005 11:46 PM
Re: Shared memory probelm with oracle
Yes, it's bug n.├В┬║ 3305683. See here: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=3305683.8 and http://metalink.oracle.com/metalink/plsql/showdoc?db=Bug&id=3305683
Best Regards,
Eric Antun
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 11:55 PM
тАО06-21-2005 11:55 PM
Re: Shared memory probelm with oracle
After reading the notes, I'm not sure this is our problem, for several reasons:
1. The situation occurs both on shutdown normal, immediaet and abort
2. It does not hang the script. We the script continues after the shutdown, but there are some living server processes.
3. It's not a consistent behaviour - happens only sometimes.
...Am I wrong?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-21-2005 11:59 PM
тАО06-21-2005 11:59 PM
Re: Shared memory probelm with oracle
If it happens only sometimes, then it may be not that bug but this one: http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=2495540.8
Do you get any "ORA-" error message in alert-
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2005 12:13 AM
тАО06-22-2005 12:13 AM
Re: Shared memory probelm with oracle
It is also not uncommon to have modules not release shared memory segments during a shutdown. But the underlying reason is poor programming and not anything to do with the system. It seems many programmers grab shared memory thinking that somehow the system will know what to do with orphaned programs.
It is VERY important to have the shutdown procedure never use kill -9 as the -9 GUARENTEES orphaned shared memory segments as well as possible corrupted indexes and data elements. If a process hangs and cannot be killed with kill -15 or kill -1, flag that program as needing a patch or rewrite.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2005 12:20 AM
тАО06-22-2005 12:20 AM
Re: Shared memory probelm with oracle
You may have a problem with ownership of the oracle program binaries, and therefore the shared memory they allocate.
This can be as a result of the bug mentioned above.
You should have /etc/rc.config.d/savecrash configured to save crash dumps and you should send the next crash dump to HP for Q4 analysis.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2005 12:27 AM
тАО06-22-2005 12:27 AM
Re: Shared memory probelm with oracle
There were no ORA-600 from what I can see in the alert log. Simple an active server process that tusc showed to be stuck in a read() function. probably from a socket. normal kill (-15) made him die nicely.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-22-2005 12:30 AM
тАО06-22-2005 12:30 AM
Re: Shared memory probelm with oracle
At one time, the server hanged than was TOC'ed.
Afterwards , we put into the script a ps to search for living server processes, and we found on several times a process still existing after the shutdown was completed. a normal kill removed it and freed the shared memory.
The question is why such processes still exist after the shutdown?