- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i on HPUX 11i - Kernel Parameter in Do...
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
тАО01-31-2003 11:19 PM
тАО01-31-2003 11:19 PM
Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
Both Machines contain only HPUX 11i and Oracle 9i.
Problems:
- Database Creation Assistant which is invoked as part of the Installation hangs with the message. "not enough space" on both machines. At different stages though.
- We are creating one of the available Template Databases. (The problem happens for all Databases)
- All recommended Oracle Kernel Parameters have been adjusted. However there is a persistent "not enough space ... could not fork" message on the operating system-level.
Question:
Are there any Kernel Settings for Oracle 9i Enterprise with a Standard Database (no tuning for anything) that are certified.
We believe the Oracle documented Kernel-Parameters are wrong at this point.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-31-2003 11:55 PM
тАО01-31-2003 11:55 PM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
It is probably not the kernel parameters that are causing you problems, I would guess it was swap space. Looking at you physical memory figures, you may need to go beyond the normal rules of allocating swap = memory. To check if swap space is the culprit during run time/installation us "/usr/sbin/swapinfo -tam". If the total at the bottom is reaching 100% this is a swap space issue.
Regards,
James.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 12:19 AM
тАО02-01-2003 12:19 AM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 12:28 AM
тАО02-01-2003 12:28 AM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
The "Could not fork" message still leads me to believe this is a swap issue. HPUX uses a reservation policy whereby a counter a decremented when a process starts....it must be able to reserve the swap space before running. If it couldn't reserve the space you will see this message but will not see the swap count increase. I would guess if you increased swap space and tried again you will be ok.
Regards,
James.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 12:56 AM
тАО02-01-2003 12:56 AM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
1.swap space
2.maxdsiz
3.SHMMAX
Please revert with the kernel parameter output on the system
kmtune -l
Also post the output of
swapinfo -l
What you can try is increase SHMMAX to 1GB on the system where you have 1GB memory
Also increase your maxdsiz for 32 bit Oracle and maxdsiz_64 for 64 bit Oracle to around 200MB.
Revert
Fast
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 02:08 PM
тАО02-01-2003 02:08 PM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
Is there a recommended Documentation about Kernel Parameters for HPUX11i ?
In addition on the B1000 I just increased all Kernel Parameters that seem to be related to Memory and Processes. Now Oracle 9i installed fine and is working. But this is for testing only. On our production machine we need to know which Kernel Parameters really are the issue here.
(certified Kernel Setting)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2003 05:58 PM
тАО02-01-2003 05:58 PM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
Oracle reccomends 256 Megabytes of ram to run Oracle 8 on a PC. It reccomends 512 Megabytes to run it on HP-UX.
As far as the L3000 goes, you are still actually kind of light on memory. HP-UX 11i is a pretty reliable and robust platform, but it uses a lot of resources, just to run the OS.
While it is possible to run an Enterprise database, and the L3000 is a rocket fast platform, you'll need to have at least 2G of swap, and will probably be hitting it pretty hard.
As far as actual kernel rec's go, you need to set up more shared memory than the minimum standards(discussed in earlier posts).
Do see Oracle recommends the December Gold Quality pack and a half dozen other patches prior to running Oracle on HP-UX, any one of which can cause you issues.
Don't forget to go to http://www.hp.com/go/java and pick a certified version of java 1.2 or 1.3 as higher versions are not yet certified by oracle, and all of the recommended patches.
As far as the workstation goes, forget about it, you'll never run oracle on that platform.
P
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-02-2003 10:05 AM
тАО02-02-2003 10:05 AM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
- Oracle recommends 256MB RAM as a Minimum. However Oracle 9i is now working successfully with 128 MB RAM after I increased several Kernel Parameters.
- 1GB RAM is not renough on the L3000 even though 256 MB RAM should be the Minimum for the B1000.
- The Oracle recommended minimum values are not the real minimum value to install one the Default Databases.
It seems we need more thorough information.
Is there a documentation specific to Kernel Settings with explanations for Parameters that can be recommended?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2003 11:57 AM
тАО02-02-2003 11:57 AM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
I think what Steven was trying to say is that Oracle is memory intensive. Also, getting something running is not the same as having it running effectively, especially if this is a mission critical server.
I don't really know Oracle but I am taking my information from the release notes which states the recommended kernel settings and minumum physical memory:
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/A90357-03/A90357_03.pdf
I did install 9i on my 11i workstation at home and didn't actually adjust any settings, as I have only 512MB memory and the same swap space the virtual memory on my server is limited anyway. However, the recommended paramters seemed reasonable to me. Looking at some of the virtual memory related parameters:
maxdsiz - 1GB
maxdsiz_64 - 2GB
shmmax - physical memory
I would be amazed if Oracle had not tested these thoroughly. This is why I thought swap space was your issue - with at most 1GB ram these segments limits should not be hit, especially after an install. Also, shmmax is dynamically tunable at 11i so you could tune this easily to see if this is causing a problem.
One thing that does puzzle me - that configuration attachment does not tie in with what you have said - some kernel parameters are not at what Oracle recommends (from the doc I pointed to) and it says there is 2GB physical memory on the system?
For more information on the kernel parameters please see the official HP guide:
http://www.docs.hp.com/hpux/onlinedocs/TKP-90202/TKP-90202.html
Regards,
James.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2003 07:26 PM
тАО02-02-2003 07:26 PM
Re: Oracle 9i on HPUX 11i - Kernel Parameter in Documentation inkonsistent
http://docs.hp.com/hpux/onlinedocs/939/KCParms/KCparams.OverviewAll.html