Oracle Exadata Log Files

When time came to troubleshooting , we started to search and review the log files. At stress time, one may waste time searching about the location of these log files. So, it may be a good practice to document the location of your environment log files, so as to reach them quickly when you need them.

There are many log files on Exadata, following are the most important ones:

Cell Node:

cell alert log file: /opt/oracle/cell/log/diag/asm/cell/cell2/trace/alert.log
MS logfile /opt/oracle/cell/log/diag/asm/cell/cell2/trace/ms-odl.log
System log file /var/log/messages

Database Node:

Database alert.log
$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log
Ex: /u01/app/oracle/diag/rdbms/exadb01/exadb01/trace/alert_DBFS2.log

Listener logfile
$ORACLE_BASE/diag/tnslsnr/{node name}/listener/trace/listener.log
Example: /u01/app/oracle/diag/tnslsnr/exadb01/listener/trace/listener.log

ASM alert.log
$ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/alert_+ASM {instance number}.log
Ex: /u01/app/oracle/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log

Clusterware CRS alert.log
$GRID_HOME/log/{node name}/alert{node name}.log
Ex: /u01/app/11.2.0/grid/log/exadb01/alertdmorldb02.log

Diskmon logfiles
$GRID_HOME/log/{node name}/diskmon/diskmon.lo*
Ex: /u01/app/11.2.0/grid/log/exadb01/diskmon/diskmon.log

OS Watcher output files
/opt/oracle.oswatcher/osw/archive/

Thanks
Ahmed