Re: err msg in trace file ????

Saad Ahmad (sahmad_at_mfa.com) wrote:
: What does this error message in oracle trace file mean:  

: > *** SESSION ID:(2.1)
: > ASYNC: Error opening ASYNC device driver, errno = 2

looks like your machine does not have a device file for async i/o...

are you using (or intending to use) async i/o? If so, you should check with your SysAdmin that the machine has been properly configured to use asynch i/o.

on HP-UX, for example, a device file called /dev/async needs to be created as such:

        /etc/mknod /dev/async c 101 0

Then make sure your unix kernal has the asyncdsk driver included and if not adjust the kernal to have that included. Finally, adjust init.ora to have async_io = true.
Note that on HP as well as some other platforms, you can't use async i/o unless your db files are on raw devices.

If you are not intending (or can't) use async i/o, set async_io = false to get rid of those messages.

Johnny Chan
Oracle Database Specialist Received on Fri Sep 29 1995 - 00:00:00 CET