oerr: Cannot access the message file /u01/app/11.2.0/rdbms/mesg/oraus.msg


When invoking oerr utility , the oraus.msg file is not accessible to report the error recommendations. The file is either missing or not accessible.

[root@exdbadm01 mesg]# oerr ora 00060
oerr: Cannot access the message file /u01/app/11.2.0/rdbms/mesg/oraus.msg


Check if the oraus.msg file exists under oracle home and also the permissions

[root@exdbadm01 mesg]# echo $ORACLE_HOME

[root@exdbadm01 mesg]# ls -lrt /u01/app/11.2.0/rdbms/mesg/oraus.msg
ls: /u01/app/11.2.0/rdbms/mesg/oraus.msg: No such file or directory
[root@exdbadm01 mesg]# ls -lrt /u01/app/11.2.0/rdbms/mesg/*oraus*
-rw-r--r-- 1 oracle oinstall 4976647 Aug 24  2013 /u01/app/11.2.0/rdbms/mesg/oraus.msg.bkp
-rw-r--r-- 1 oracle oinstall 1112064 Aug 24  2013 /u01/app/11.2.0/rdbms/mesg/oraus.msb

If the file exists with different file name or located in some other location then move the file to $ORACLE_HOME/rdbms/mesg/ directory. Post that invoke the oerr utility

[root@exdbadm01 mesg]# mv /u01/app/11.2.0/rdbms/mesg/oraus.msg.bkp /u01/app/11.2.0/rdbms/mesg/oraus.msg
[root@exdbadm01 mesg]# oerr ora 00060
00060, 00000, "deadlock detected while waiting for resource"
// *Cause:  Transactions deadlocked one another while waiting for resources.
// *Action: Look at the trace file to see the transactions and resources
//          involved. Retry if necessary.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s