- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Errors HPUK 11.31
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
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
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-04-2011 09:44 AM
01-04-2011 09:44 AM
Oracle Errors HPUK 11.31
disk_asynch_io TRUE
filesystemio_options asynch
I am gettng errors in the oracle trace files as follows
WARNING:Could not increase the asynch I/O limit to 32 for SQL direct I/O. It is set to 0
Can the system suppirt async io and anyone comes across this problem before
oracle metalink has reported the problem in 11g rel 1 but not in 10.2.0.5
Any help would be appreciated
Thanks
mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-04-2011 11:50 AM
01-04-2011 11:50 AM
Re: Oracle Errors HPUK 11.31
http://ericwijaya.wordpress.com/2009/11/06/warningcould-not-set-the-asynch-io-limit-to-64-for-sql-direct-io-it-is-set-to-0/
Rgrds,
Rota
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2011 01:06 AM
01-05-2011 01:06 AM
Re: Oracle Errors HPUK 11.31
thanks for your reply , I did find that thread.
I did also find out that oracle for HP still uses async io regardless of the value of the init setting
disk_asynch_io=FALSE and filesystemio_options=none).
So i might as well turn off the settings
Thanks for your help
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2011 05:05 AM
01-05-2011 05:05 AM
Re: Oracle Errors HPUK 11.31
The point is that regardless of what you set these parameters to, if the data is on a filesystem on HP-UX, then there is no async IO happening anyway.
If you have access you should look at Oracle support document 139272.1
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-05-2011 05:11 AM
01-05-2011 05:11 AM
Re: Oracle Errors HPUK 11.31
sorry , i should have mentioned that , after having a word with out system administrator I found out that
Async I/O is only available for raw volumes and weâ re using the VxFS file systems with the concurrent I/O (CIO) option
so i have changed the following parameters in oracle
filesystemio_options string SETALL
disk_asynch_io boolean FALSE
This has resolved the problem
Thanks for your help
Mike