- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- When using Oracle 9i on HP-UX should I do followin...
Operating System - HP-UX
1752802
Members
5886
Online
108789
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- 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
05-30-2002 05:34 PM
05-30-2002 05:34 PM
When using Oracle 9i on HP-UX should I do following?
1 Change shmmax kernel parameter
2 Enabling SCHED_NOAGE for Oracle9i using
# setprivgrp dba RTSCHED RTPRIO
create the /etc/privgroup add "dba RTSCHED RTPRIO"
3 AIO
3.1 Enable MLOCK Privilege
# setprivgrp dba MLOCK and add "dba MLOCK" to /etc/privgroup
3.2 Implementing Asynchronous I/O Using AIO
All these is I read from oracle's recommend, I do not know what others should I also need to do? Thanks !!!
2 Enabling SCHED_NOAGE for Oracle9i using
# setprivgrp dba RTSCHED RTPRIO
create the /etc/privgroup add "dba RTSCHED RTPRIO"
3 AIO
3.1 Enable MLOCK Privilege
# setprivgrp dba MLOCK and add "dba MLOCK" to /etc/privgroup
3.2 Implementing Asynchronous I/O Using AIO
All these is I read from oracle's recommend, I do not know what others should I also need to do? Thanks !!!
xysco
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2002 10:24 PM
05-31-2002 10:24 PM
Re: When using Oracle 9i on HP-UX should I do following?
To answer these questions in reverse order;
AIO is only really needed if you are planning on deploying the database on RAW partitions as opposed to File Systems. The one step which you have not mentioned is the creation of the /dev/async device file, and the installation of the asyncdsk module in the kernel.
SCHED_NOAGE is worth while as it prevents the process from being preempted. There is an init.ora parameter that also needs to be set, the value dependant upon weather you are running 11 or 11i
Shared Memory parameters need to be configured depending upon the application(s) being deployed. In addition to shmmax which should be set to the value of physical memory, the remainder of the parameters are dependant upon the number of processes that you require. I do not have access at this time to the system, but the Oracle Manuals have the other shared memory parameters (shmmns, etc)
What else is an open ended question. If you are planning on deploying the iAS as well, then you will need to look into msg* parameters.
Also, make sure that you have enough system table parameters such as nproc, nfile, maxfiles, maxfile_lim, max_users
Hope this helps
AIO is only really needed if you are planning on deploying the database on RAW partitions as opposed to File Systems. The one step which you have not mentioned is the creation of the /dev/async device file, and the installation of the asyncdsk module in the kernel.
SCHED_NOAGE is worth while as it prevents the process from being preempted. There is an init.ora parameter that also needs to be set, the value dependant upon weather you are running 11 or 11i
Shared Memory parameters need to be configured depending upon the application(s) being deployed. In addition to shmmax which should be set to the value of physical memory, the remainder of the parameters are dependant upon the number of processes that you require. I do not have access at this time to the system, but the Oracle Manuals have the other shared memory parameters (shmmns, etc)
What else is an open ended question. If you are planning on deploying the iAS as well, then you will need to look into msg* parameters.
Also, make sure that you have enough system table parameters such as nproc, nfile, maxfiles, maxfile_lim, max_users
Hope this helps
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP