- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Shared Memory issue
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-06-2001 10:56 AM
тАО02-06-2001 10:56 AM
Shared Memory issue
either with a reboot or stopping other services on the server. I have 4GB of memory.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2001 11:25 AM
тАО02-06-2001 11:25 AM
Re: Shared Memory issue
If you have set all your semm params (semmni,semmns, semmap) correctly based on the processes being required in Oracles ~init.ora then the problem may not be the parms settings....it's could be that Oracle is not releasing the semmaphores, and that is strictly an issue how your database is being handled via Oracle/SQL.
Now for shared memory..check SHMMAX. I generally set this to 1GB (1073741824). This setting does not affect how much shared memory is need or used by Oracle or the O/S. It is used only to indicate the maximum allowable size. This does not impact the operating system kernel resources.
Some Oracle parm settings (I used 8i as example)
nflocks = 200 + sum of values in init.ora parm db_files
maxdsiz & maxdsiz_64_bit = set this value to
larger than the default for maxdsiz &maxdsiz_64, for ex. 1B (because relinking needs the space).
semmni = total of all oracle process from init.ora (round
up if I have resources I add 10 for each db then
round up)
semmns = value of semmni *2
semmap = value of semmni +2
Hope this helps....it sure made me dust off my notes.
/rcw
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-06-2001 12:36 PM
тАО02-06-2001 12:36 PM
Re: Shared Memory issue
If you just upgraded your O/S, make sure you relinked Oracle. I followed the Oracle manual to set the parameters and was mislead in the setting of SEMMNI. If you have access to Metalink, I spent hours on this TAR# 1327376.999. Oracle will be amending the manual. Good notes in there. Hope this helps.
Take care,
Josee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2001 12:01 AM
тАО02-07-2001 12:01 AM
Re: Shared Memory issue
a) Oracle hasn't shutdown correctly and therefore hasn't removed all it's segments
b) Another application grabbing a chunk of shared memory while Oracle is down.
If it's (a) checking ipcs -m might show the culprit.
If it's (b), then you've got problems. The way the virtual memory is allocated means that if Oracle can't find what it requires contigously, then it won't start.
If your running hp-ux 11 64bit, you can use memory windows, to effectively give Oracle it's own place to put it's shared memory.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2001 02:18 AM
тАО02-07-2001 02:18 AM
Re: Shared Memory issue
Use ipcrm to remove any shared memory segments or semaphores used by Oracle without rebooting your server.
For shared memory segments,
# ipcrm -m shmid
For semaphores,
# ipcrm -s semid
Both the shared memory segment id (shmid) and the semaphore id (semid) can be retrieved from the output of
# ipcs -b
Changing kernel parameters would require you to reboot the system. There is no clean way out of it. In my opinion, it is simply too risky to use the adb debugger to modify the kernel already existing in memory.
Hope this helps. Regards.
Steven Sim Kok Leong
Brainbench MVP for Unix Admin
http://www.brainbench.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-07-2001 07:49 AM
тАО02-07-2001 07:49 AM