oracle problem

[Radhakrishnan Venkatara]

hi all,

i am getting a problem in oracle.
we could able to start oracle without any problems.
even all oracle process are running properly.
but dbwriter is creating log file in oraclehome/rdbms/log
i given the log file below.
i couldn't figure it out whether it is hardware problem
Dump file /mnt1/software/oracle/rdbms/log/dbwr_1098.trc
ORACLE7 Server Release 7.0.13.1.0 - Production
With the procedural and distributed options
PL/SQL Release 2.0.15.1.0 - Production
ORACLE_HOME = /mnt1/software/oracle
ORACLE_SID = CEN
Oracle process number: 3 Unix process id: 1098
System name: HP-UX
Node name: unix
Release: B.10.20
Version: A
Machine: 9000/813

Sat Jul 20 18:18:15 2002
*** SESSION ID:(2.1)
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
ASYNC: Error opening ASYNC device driver, errno = 2
:

waiting for ur replies

thanks and regards
radhakrishnan

[T G Manikandan]

This link is a goog link for to speak about your messages



Error number 2 is
No such file or directory


I think you have set
DISK_ASYNC_IO =true in your init.ora file
Please check it out.

If you have not set that then
Do a
#mknod /dev/async c 101 0x0
#chown oracle:dba /dev/async
#chmod 000 /dev/async
Also check that the parameters

disk_asynch_io=false
tape_asynch_io=false
in your init.ora file


Restart the database.


Thanks

[T G Manikandan]

THis is a good link
Sorry this is not for your message
I was thinking that you are short of max_async_ports
but your error number is 2
which is no such file.


http://bizforums.itrc.hp.com/cm/QuestionAnswer/1,,0xead55a3e6e0bd6118ff40090279cd0f9,00.html

Also have a look at this above lonk

[Radhakrishnan Venkatara]

hi,
the problem started last week previously it was working fine since 4 years and thereis no such parameters in the init.ora file.

there is no device files named /dev/async in any of our servers.
we are using oracle 7.1 and 7.0 versions

thanks

[Radhakrishnan Venkatara]

hi,

i created the /dev/async file but after that we are getting a different error in rdbms/log/

i had given the rdbms/log/dbwr_pid.trc file

Dump file /mnt1/software/oracle/rdbms/log/dbwr_1102.trc
ORACLE7 Server Release 7.0.13.1.0 - Production
With the procedural and distributed options
PL/SQL Release 2.0.15.1.0 - Production
ORACLE_HOME = /mnt1/software/oracle
ORACLE_SID = CEN
Oracle process number: 3 Unix process id: 1102
System name: HP-UX
Node name: unix
Release: B.10.20
Version: A
Machine: 9000/813

Mon Jul 22 12:41:14 2002
*** SESSION ID:(2.1)
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19
ASYNC: Error opening ASYNC device driver, errno = 19


what is the new error 19 means

thanks

[Steven Sim Kok Leong]

Hi,

To add on, have you been performing regular backups? If you have, the easiest way to identify the changes that took place would be to take your last okay backup of the okay state, extract out a long listing (size, timestamp etc) of the files and compare this listing with a current listing of the files in the current problematic state. From the comparison, identify the files that were removed, changed or even added.

You might even want to restore /dev/async from the last okay backup of the okay state since this appears to be the problem cause (i.e. causes the error code to change) as pointed out by TG.

Hope this helps. Regards.

Steven Sim Kok Leong

[U.SivaKumar_2]

Hi,
Try this .
/usr/bin/setprivgrp MLOCK
create a file /etc/privgroup with following lines.
MLOCK

regards,
U.SivaKumar

[T G Manikandan]

The file does exist but the async io is not configured you get this message

errno=19

ENODEV /*No such device*/

Follow the steps what I have specified in my first post.

Did you make an entry

disk_asynch_io=false in your init.ora file

Restart the database to make the file to be re-read


Thanks
G Manikandan