Oracle Log files Troubleshooting Oracle

Oracle log files

The following Oracle log files is helpful for resolving issues and Oracle components:

• Table:log files for Oracle RAC 10g Release 2

• Table:log files for Oracle RAC 11g Release 2 and later versions

• Table:log files for Oracle database

Table:log files for Oracle RAC 10g Release 2

 $CRS _home/log/hostname/cssd 

Component	Log file location
Cluster ready Services Daemon (CRSD) Log Files	$CRS _home/log/hostname/crsd
Cluster synchronization Services (CSS)
Event Manager (EVM) Informat Ion generated by EVMD	$CRS _home/log/hostname/evmd
Oracle RAC RACG	$CRS _HOME/LOG/HOSTNAME/RACG $ORACLE _home/log/ HOSTNAME/RACG

Table:log files for Oracle RAC 11g Release 2 and later versions

Component	Log File Location
Clusterware Alert Log	$GRID _home/log/
Disk Monitor Daemon	$GRID _home/log/
Ocrdump, Ocrcheck, Ocrconfig, Crsctl	$GRID _home/log/
Cluster Time Synchronization Service	$GRID _HOME/LOG/<HOST>/CTSSD
Grid interprocess Communication Daemon	$GRID _HOME/LOG/<HOST>/GIPCD
Oracle High Availability Services Daemon	$GRID _HOME/LOG/<HOST>/OHASD
Cluster Ready Services Daemon	$GRID _HOME/LOG/<HOST>/CRSD
Grid Plug and Play daemon	$GRID _HOME/LOG/<HOST>/GPNPD
Mulitcast Domain Name Service Daemon	$GRID _HOME/LOG/<HOST>/MDNSD
Event Manager Daemon	$GRID _HOME/LOG/<HOST>/EVMD
RAC RACG (used if pre-11.1 database is installed)	$GRID _HOME/LOG/<HOST>/RACG
Cluster Synchronization Service Daemon	$GRID _HOME/LOG/<HOST>/CSSD
Server Manager	$GRID _HOME/LOG/<HOST>/SRVM
HA Service Daemon Agent	$GRID _home/log/
HA Service Daemon CSS Agent	$GRID _home/log/
HA Service Daemon OCSSD Monitor Agent	$GRID _home/log/
HA Service Daemon Oracle Root Agent	$GRID _home/log/
CRS Daemon Oracle Agent	$GRID _home/log/
CRS Daemon Oracle Root Agent	$GRID _home/log/
Grid Naming Service Daemon	$GRID _HOME/LOG/<HOST>/GNSD

Table:log files for Oracle database

Component	Log File Location
Oracle Database	$ORACLE _base/diag/rdbms/database_name/sid/

Ext.: https://sort.symantec.com/public/documents/sfha/6.1/aix/productguides/html/sfrac_admin/ch03s12s01.htm

Oracle Log files Troubleshooting Oracle