topic Re: oracle problem in Operating System - HP-UX

oracle problem

Radhakrishnan Venkatara — Sat, 20 Jul 2002 12:18:39 GMT

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

Re: oracle problem

T G Manikandan — Sat, 20 Jul 2002 13:42:38 GMT

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

Re: oracle problem

T G Manikandan — Sat, 20 Jul 2002 13:45:07 GMT

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

Re: oracle problem

Radhakrishnan Venkatara — Mon, 22 Jul 2002 03:57:22 GMT

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

Re: oracle problem

Radhakrishnan Venkatara — Mon, 22 Jul 2002 06:17:16 GMT

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

Re: oracle problem

Steven Sim Kok Leong — Mon, 22 Jul 2002 06:25:39 GMT

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

Re: oracle problem

U.SivaKumar_2 — Mon, 22 Jul 2002 06:42:12 GMT

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

MLOCK

regards,
U.SivaKumar

Re: oracle problem

T G Manikandan — Mon, 22 Jul 2002 10:39:24 GMT

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