- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle10g mmnl errors
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
тАО11-14-2005 08:52 AM
тАО11-14-2005 08:52 AM
Oracle10g mmnl errors
my client has a new oracle 10g r2 database on HPUX 11.11. In the database bdump dir this is a .trc file dbname_mmnl_13961.trc. Which contains:
Dump file /u00/app/oracle/admin/PRDCLRTY/bdump/prdclrty_mmnl_13961.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u00/app/oracle/product/10.2.0.1.0
System name: HP-UX
Node name: akldwhp1
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: PRDCLRTY
Redo thread mounted by this instance: 0
Oracle process number: 0
Unix process pid: 13961, image: oracle@akldwhp1
File '/dev/async' not present : errno=2
*** 2005-11-14 04:19:34.764
*** SERVICE NAME:(SYS$BACKGROUND) 2005-11-14 04:19:34.764
*** SESSION ID:(325.1) 2005-11-14 04:19:34.763
ksugetosstat failed: op = pstat_getprocessor, location = slsgetactive ()
*** 2005-11-14 04:19:47.136
ksugetosstat failed: op = pstat_getprocessor, location = slsgetactive ()
*** 2005-11-14 04:20:02.285
ksugetosstat failed: op = pstat_getprocessor, location = slsgetactive ()
*** 2005-11-14 04:20:16.423
- they are working on the /dev/async problem.
- are the ksugetosstat failures related to the /dev/async problem, or are they something else? I suspect the latter as these msgs are being produced every few secs since 0419 Monday.
Any clues would be welcome, I'm a bit lost.
thanks, Greg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2005 02:03 PM
тАО11-14-2005 02:03 PM
Re: Oracle10g mmnl errors
similar reported in metalink.oracle
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=FOR&p_id=613649.993
This problem happened on oracle8 and it come out again on the 10gR2....!?
GOOD LUCK!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2005 03:08 PM
тАО11-14-2005 03:08 PM
Re: Oracle10g mmnl errors
also refer to metalink notes:
Note.60692.1 ALERT HP-UX Tracefiles reference /dev/async when async i/o not configured
Note.1053060.6 TRACE FILE BEING GENERATED WITH EACH DBWR PROCESS
As the previous post say this error was first reported in Oracle 8i whereby the workaround was:
WORKAROUND
==========
It is possible to workaround the problem by the following means;
If the "/dev/async" device does not exists, then create it.
As the root user:
/sbin/mknod /dev/async c 101 0x0
/usr/bin/chown oracle:dba /dev/async
/usr/bin/chmod 000 /dev/async
The permissions on /dev/async of 000 ensure that it is not possible to use the async driver unintentionally.
As the oracle user, modify the "init.ora" file so that the parameters:
disk_asynch_io = false
tape_asynch_io = false
I would also suggest that you create a TAR in Metalink for a more proper followup. Most probably they already have a patch for that... please check
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2005 03:27 PM
тАО11-14-2005 03:27 PM
Re: Oracle10g mmnl errors
I'm more interested in the "ksugetosstat failed" error. Is this related to the /dev/async problem? Could be, in which case I should ignore them until the dev/async issue is resolved.
Greg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-14-2005 10:49 PM
тАО11-14-2005 10:49 PM
Re: Oracle10g mmnl errors
The only way to know if the ksugetosstat error message is related to /dev/async file is to - assuming you use file systems and not raw devices - modify the init
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-10-2006 02:13 AM
тАО07-10-2006 02:13 AM
Re: Oracle10g mmnl errors
Does this particular system have any iCOD CPU's?
I have a 48-way Superdome with 16 iCOD CPU's, and I'm getting the same trace errors about "ksugetosstat failed".
The only guess I have is that since I have 16 iCOD CPU's, Oracle can't access them. If you query the number of CPUs in the system (for example, from a print_manifest), I show 64 CPU's, but only 48 are active.
I -think- it's related to iCOD, but I'm not 100% sure yet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-21-2006 08:24 AM
тАО07-21-2006 08:24 AM
Re: Oracle10g mmnl errors
Thanks, Adam
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО01-03-2011 10:00 AM
тАО01-03-2011 10:00 AM
Re: Oracle10g mmnl errors
We just moved to Oracle 10g r2 on a PA-RISC running 11.11 OS. We too are now seeing hundreds of .trc files being created. Does the above thread still apply as a vaild solution ? Or has more research and other methods been developed to address this issue ?
Thanks