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/

Donate to support our blogging work

$1.00

Thanks
Ahmed

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 )

Google photo

You are commenting using your Google 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