Oracle Database and Exadata Log File Locations

August 1, 2019

As a DBA, you must know the important locations of Oracle database and Exadata log files. Like database alert log file there is also a alert log file for the exadata cell nodes. So lets look at the locations of all these files.

How to Find Out the size of your Oracle Database

Cell alert.log file

/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log
 if the CELLTRACE parameter is set just do cd $CELLTRACE

MS logfile

/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.log.

orif the CELLTRACE parameter is set just do cd $CELLTRACE

Database alert logfile:

$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log

Example: /u01/app/oracle/diag/rdbms/db12c/db12c1/trace/alert_db12c1.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

Listener logfile

$ORACLE_BASE/diag/tnslsnr/{node name}/listener/trace/listener.log

Example: /u01/app/oracle/diag/tnslsnr/orahowdb/listener/trace/listener.log

Diskmon logfiles

$GRID_HOME/log/{node name}/diskmon/diskmon.lo*

Ex: /u01/app/11.2.0/grid/log/orahowdb2/diskmon/diskmon.log

Clusterware CRS alert.log

$GRID_HOME/log/{node name}/alert{node name}.log

Ex: /u01/app/11.2.0/grid/log/orahowdb2/alertorahowdb2.log
Important Log Locations
 Clusterware daemon logs are all under /log/.  Structure under /log/:

 alert.log - look here first for most clusterware issues
 ./admin:
 ./agent:
 ./agent/crsd:
 ./agent/crsd/oraagent_oracle:
 ./agent/crsd/ora_oc4j_type_oracle:
 ./agent/crsd/orarootagent_root:
 ./agent/ohasd:
 ./agent/ohasd/oraagent_oracle:
 ./agent/ohasd/oracssdagent_root:
 ./agent/ohasd/oracssdmonitor_root:
 ./agent/ohasd/orarootagent_root:
 ./client:
 ./crsd:
 ./cssd:
 ./ctssd:
 ./diskmon:
 ./evmd:
 ./gipcd:
 ./gnsd:
 ./gpnpd:
 ./mdnsd:
 ./ohasd:
 ./racg:
 ./racg/racgeut:
 ./racg/racgevtf:
 ./racg/racgmain: 
 ./srvm:

Os message log file

/var/log/messages

Must Read: