Oracle Log Files - Location

The following tables detail the location and purpose of the Oracle database log files and trace files. This includes Database log files and Grid Infrastructure log files written to as part of a RAC cluster or Oracle's HA solutions.

Database Log File - Location

Oracle Database Alert Log

$ORACLE_BASE/diag/rdbms/database_name/SID/trace/alert_SID.log

where SID is the database SID

Grid Infrastructure Log Files

Clusterware Alert Log	$ORA_CRS_HOME/log/hostname/alerthostname.log
Disk Monitor Daemon	$ORA_CRS_HOME/log/hostname/diskmon
OCRDUMP, OCRCHECK, OCRCONFIG, CRSCTL	$ORA_CRS_HOME/log/hostname/client
Cluster Time Synchronization Service	$ORA_CRS_HOME/log/hostname/ctssd
Grid Interprocess Communication Daemon	$ORA_CRS_HOME/log/hostname/gipcd
Oracle High Availability Services Daemon	$ORA_CRS_HOME/log/hostname/ohasd
Cluster Ready Services Daemon	$ORA_CRS_HOME/log/hostname/crsd
Grid Plug and Play Daemon	$ORA_CRS_HOME/log/hostname/gpnpd
Mulitcast Domain Name Service Daemon	$ORA_CRS_HOME/log/hostname/mdnsd
Event Manager Daemon	$ORA_CRS_HOME/log/hostname/evmd
Cluster Synchronization Service Daemon	$ORA_CRS_HOME/log/hostname/cssd
Server Manager	$ORA_CRS_HOME/log/hostname/srvm
HA Service Daemon Agent	$ORA_CRS_HOME/log/hostname/agent/ohasd/oraagent_oracle
HA Service Daemon CSS Agent	$ORA_CRS_HOME/log/hostname/agent/ohasd/oracssdagent_root
HA Service Daemon ocssd Monitor Agent	$ORA_CRS_HOME/log/hostname/agent/ohasd/oracssdmonitor_root
HA Service Daemon Oracle Root Agent	$ORA_CRS_HOME/log/hostname/agent/ohasd/orarootagent_root
CRS Daemon Oracle Agent	$ORA_CRS_HOME/log/hostname/agent/crsd/oraagent_oracle
CRS Daemon Oracle Root Agent	$ORA_CRS_HOME/log/hostname/agent/crsd/orarootagent_root
Grid Naming Service Daemon	$ORA_CRS_HOME/log/hostname/gnsd
SCAN Listener Logs	$ORA_CRS_HOME/log/diag/tnslsnr/hostname/listener_scanN/trace	where N is the node number