- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle & Asynchronous IO
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
тАО10-29-2004 04:31 AM
тАО10-29-2004 04:31 AM
I'm having troubles configuring Async IOs on a 11.00 server here.
Config is :
HP-UX 11.00 64 bits
Oracle 9i (9.2.0.4)
*no* Online JFS
I've done the following steps :
. Setting up /etc/privgroup
#cat /etc/privgroup
dba MLOCK
dba RTSCHED RTPRIO
. used setprivgroup -f /etc/privgroup
. add lines in spfile
disk_async_io=true
hpux_sched_noage=178
. restart Oracle DB
After that, each session on DB creates a file in udump dir with a line like that :
Ioctl ASYNC_CONFIG error, errno = 1
Note that the server is really short on RAM compared to DB size (but I don't believe it matters).
One strange thing I noticed is that when I do getprivgrp, I get the foillowing :
global privileges: CHOWN
dba: RTPRIO RTSCHED
I don't see "dba: MLOCK". Is it normal ?
I'm not complaining about DB perfs, but udump is filling with those little trace files, and I'm looking for a way to fix.
Thanks for any help,
Fred
"Reality is just a point of view." (P. K. D.)
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2004 04:37 AM
тАО10-29-2004 04:37 AM
Re: Oracle & Asynchronous IO
read the doc:
"Best practices for Oracle on HP-UX"
http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt
Regards,
Zygmunt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2004 04:40 AM
тАО10-29-2004 04:40 AM
SolutionWe don't have this:
dba RTSCHED RTPRIO
and we're not getting the little dump files.
Maybe you want to back out that change and see if it helps.
We are successfully using asynchronous i/o.
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
тАО10-29-2004 04:46 AM
тАО10-29-2004 04:46 AM
Re: Oracle & Asynchronous IO
Have you enabled the aync drivers in the kernel. Also the /dev/async file should be owned by oracle:dba
These are the steps involved.
1. cd /stand/build
2. /usr/lbin/sysadm/system_prep -s system
3. vi /stand/build/system - add the following 2 lines: asyncdsk & asyncdsk_included
4. mk_kernel -s /stand/build/system
5. cp /stand/system /stand/system.prev
6. cp /stand/build/system /stand
7. kmupdate /stand/build/vmunix_test
8. cd /
9. shutdown -r -y now
10. after the system is reboot..
Use sam to change the value of the parameter max_async_port from 50 -> 1024
11. check that the driver is installed: lsdev | grep 101
12. mknod /dev/async c 101 0x000000
13. chown oracle:dba /dev/async
14. chmod 660 /dev/async
15. vi /etc/privgroup - add 1 line:
dba MLOCK
16. run the command: setprivgrp -f /etc/privgroup
17. run the command: getprivgrp, and make sure that you can the following
output:
global prvileges: CHOWN
dba: MLOCK
18. make sure that the oracle team add the following parameter to the oracle
init files:
disk_asynch_io=true
Hope this helps.
Regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2004 05:30 AM
тАО10-29-2004 05:30 AM
Re: Oracle & Asynchronous IO
They should be oracle:dba and read for both
Anil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-01-2004 07:50 PM
тАО11-01-2004 07:50 PM
Re: Oracle & Asynchronous IO
It's exactly the doc I used to set up async IO :)
SEP,
This line is for process scheduling. It is mentionned in doc zygmunt said. I will try without it.
Sanjay and RAC,
If I give /dev/async to oracle:dba, no other user will be able to use it... I don't have another user who needs, but I find it a little strange.
/dev/async belongs to bin:bin and is rw for everybody.
# ll /dev/async*
crw-rw-rw- 1 bin bin 101 0x000000 Feb 15 2001 /dev/async
crw-rw-rw- 1 bin bin 101 0x000000 Feb 24 2004 /dev/asyncdsk
asyncdsk is already in kernel.
# kmadmin -k | grep async
asyncdsk_included
asyncdsk
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
тАО11-01-2004 08:01 PM
тАО11-01-2004 08:01 PM
Re: Oracle & Asynchronous IO
In my /etc/privgroup, dba group has its rights on two lines. When I issue a getprivgrp, I only see second line. Putting all on one line seems to solve it...
One more question : Is /etc/privgroup read at each boot, or do I need to include a setprivgrp in startup scripts ?
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
тАО11-01-2004 08:07 PM
тАО11-01-2004 08:07 PM
Re: Oracle & Asynchronous IO
# grep /etc/privgroup /sbin/init.d/*
/sbin/init.d/set_prvgrp: if [ -f /etc/privgroup ]; then
/sbin/init.d/set_prvgrp: /usr/sbin/setprivgrp -f /etc/privgroup
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
тАО12-12-2007 11:26 PM
тАО12-12-2007 11:26 PM
Re: Oracle & Asynchronous IO
I wanted to know, how it'll affect the database if the dba: MLOCK privillage is not there.