- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ipcs shows deleted shared segments, Oracle 9.2...
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
тАО02-09-2005 12:36 AM
тАО02-09-2005 12:36 AM
ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
Example :
$ ipcs -m -b -p
IPC status from /dev/kmem as of Wed Feb 9 15:24:14 2005
T ID KEY MODE OWNER GROUP SEGSZ CPID LPID
Shared Memory:
m 0 0x411c0534 --rw-rw-rw- root root 348 556 556
m 1 0x4e0c0002 --rw-rw-rw- root root 61760 556 556
m 2 0x41200b6d --rw-rw-rw- root root 8192 556 568
m 90115 0x0c6629c9 --rw-r----- root root 17905056 1278 23990
m 4 0x06347849 --rw-rw-rw- root root 77384 1278 1322
m 8197 0x49145006 --rw-r--r-- root root 22908 1274 1322
m 98310 0x5e180024 --rw------- root root 512 1425 1425
m 671751 0x00000000 D-rw-r----- oracle oinstall 656367616 4812 4827
m 73736 0x00000000 D-rw-r----- oracle oinstall 555704320 17378 28749
m 57353 0xc4f6ea5c --rw-r----- oracle oinstall 757030912 19457 26511
m 32778 0xee7eabfc --rw-r----- oracle oinstall 656367616 4827 26645
m 1540107 0x444d568c --rw-r----- oracle oinstall 555704320 28749 25490
m 8204 0xb5721248 --rw-r----- oracle oinstall 555704320 23698 23698
It's enough to start the instance ( no application was started, only the db ) then stop it and some segments are left allocated ( with D flag )
If you exit from sqlplus session ( that issued shutdown command ) those segments disapear but not always.
CPID/LPID indicates non existent processes.
I've found this about my problem :
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=611062
but is not enough.
Does anyone encounter this problem ?
Is there an Oracle or HP-UX patch ?
HP guys don't want to help us if we don't proced applying all current HP-UX patches.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 01:00 AM
тАО02-09-2005 01:00 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
If it does not happen, investigate two areas:
Memory leaks for your oracle version at metalink.
shared memory patches at itrc.hp.com
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
тАО02-09-2005 01:42 AM
тАО02-09-2005 01:42 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 02:03 AM
тАО02-09-2005 02:03 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
But our Oracle admins app. consultants say oracle9.2.0.5 does not work ( or isn't certified ) with their application.
I/we want to make sure first that this can be solved by patching befor proceding to patch oracle/hp-ux. It's a production env.
Andrei
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 06:47 AM
тАО02-09-2005 06:47 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
Down to a recommendation - well, you can get out of this easily by writing a script to delete the shared memory areas yourself. You can write a script to delete by ID or by Key using ipcrm - *IF* this is the only Oracle database on the box. Just make a script to find them, and delete them on shutdown, and make it part of your shutdown ritual.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 06:33 PM
тАО02-09-2005 06:33 PM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 07:45 PM
тАО02-09-2005 07:45 PM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
It's about a banking app. called flexcube
Andrew : I'll try that tool, hope it can remove those segments otherwise the only solution I know is reboot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-09-2005 08:17 PM
тАО02-09-2005 08:17 PM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2005 02:45 AM
тАО02-10-2005 02:45 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-14-2005 09:35 AM
тАО02-14-2005 09:35 AM
Re: ipcs shows deleted shared segments, Oracle 9.2.0.4, HP-UX 11.23
pga_aggregate_target=XXXXXXXX (some number)
workarea_size_policy=auto
I've found that while these worked just fine in 9.2.0.4 - but when I upgraded to to 9.2.0.5 I needed to turn them off as performance had gone down to fully 1/2 of what the system could normally handle at 100% in performance testing. I called Oracle Support at the time with no results, so I just did a "divide and conquer" on all cost-optimizer type settings until I isolated these two. By turning these off I regained full system performance.
There may have been bug fixes, etc for this since then, but I'm running fine without.