oerr: Cannot access the message file /u01/app/11.2.0/rdbms/mesg/oraus.msg
Cause:
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
Workaround:
Check if the oraus.msg file exists under oracle home and also the permissions
[root@exdbadm01 mesg]# echo $ORACLE_HOME
/u01/app/11.2.0
[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.