- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Two Oracle instances not coexisting
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
тАО08-24-2000 08:06 AM
тАО08-24-2000 08:06 AM
ORA-27102: out of memory
HP-UX Error: 12: Not enough space
The servers are N-class with 16GB of memory; shmmax is set to 1GB. Each of the instance's SGA is 1.5GB.
Does anyone have any ideas as to why the second instance fail? Is it a shmmax problem?
By the way, I'm not Bryan - I'm Dana Manda.
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:08 AM
тАО08-24-2000 08:08 AM
Re: Two Oracle instances not coexisting
Try increasing your maxdsiz . That may solve some of your out of memory issues.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:16 AM
тАО08-24-2000 08:16 AM
Re: Two Oracle instances not coexisting
Errno 12; not enough core usually always means your out of swapspace. Try adding some more and/or turning on the following kernel parameter SWAPMEM_ON is set to 1.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:20 AM
тАО08-24-2000 08:20 AM
Re: Two Oracle instances not coexisting
If your Oracle configuration is ok to run two concurent instances, could be a kernel params issue.
For HP11, going in sam->kernel Parm->configurable param->action->temlpates->apply tuned param set->general OLTP/Database Server System can help you a little bit.
Also, you can take a look at:
http://docs.hp.com/hpux/content/KCparams.OverviewAll.html
As well you can check the forum for Kernel as a key word and you'll get lots of posts.
Chris Anoruo attached a few times a list of kernel params.
Good luck!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:31 AM
тАО08-24-2000 08:31 AM
Re: Two Oracle instances not coexisting
Tony
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:33 AM
тАО08-24-2000 08:33 AM
Re: Two Oracle instances not coexisting
Set these values as follows:
MAXDSIZ=IGB
MAXTSIZ=1GB
NBUF=0
BUPAGES=0
DBC_MAX_PCT=25
DBC_MIN_PCT=5
SWAPMEM_ON=1
ALLOCATE_FS_SWAPMAP=0
SHMMAX=1GB
SEMAEM=16384
SEMMAP=1366
SEMMNI=1364
SEMMNU=2048
SEMVMX=32767
I hope your total swap space is upto 3gb.
See link
http://www.docs.hp.com/hpux/content/KCparams.OverviewAll.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:46 AM
тАО08-24-2000 08:46 AM
Solutionaddress more than 1.87 GB of shared memory (which happens to be the limit for shared memory on 32 bit 10.20 of HP-UX). This would not be the problem if you were running 64-bit ORacle.
You can get around this problem (with 32-nit Oracle) by limiting your TOTAL SGA usage to less than approx. 1.8GB of SGA space. Alternatively you can implement what is known as memory windows on HP-UX 11 that will allow each instance to utilize up to 1.87 GB of SGA space. I've only had to use this in one shop that I've worked in.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 08:55 AM
тАО08-24-2000 08:55 AM
Re: Two Oracle instances not coexisting
Check this link also, I don't think you will have shared memory problems if you follow the settings as recommended. http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xb05f7e990647d4118fee0090279cd0f9,00.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 09:22 AM
тАО08-24-2000 09:22 AM
Re: Two Oracle instances not coexisting
Check this link also, I don't think you will have shared memory problems if you follow the settings as recommended. http://my1.itrc.hp.com/cm/QuestionAnswer/1,1150,0xb05f7e990647d4118fee0090279cd0f9,00.html
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-24-2000 03:03 PM
тАО08-24-2000 03:03 PM
Re: Two Oracle instances not coexisting
do you use a 32bit Oracle? Then read the docu about "Applications Domains" or
"Memory Windows" and use the "setmemwindow" command with a different
number for each of your instances. That way you will get independent shared
memory segements for the instances! But that accounts only for the 1GB segment
for the "shared data" quadrant, so you might only be able to have two 1GB SGAs!
HTH,
Wodisch