Oracle log files Troubleshooting Oracle

標籤：

Oracle log files

The following Oracle log files are helpful for resolving issues with 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

Component	Log file location
Cluster Ready Services Daemon (crsd) Log Files	$CRS_HOME/log/hostname/crsd
Cluster Synchronization Services (CSS)	$CRS_HOME/log/hostname/cssd
Event Manager (EVM) information 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/<host>/alert<host>.log
Disk Monitor daemon	$GRID_HOME/log/<host>/diskmon
OCRDUMP, OCRCHECK, OCRCONFIG, CRSCTL	$GRID_HOME/log/<host>/client
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 (only 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/<host>/agent/ohasd/oraagent_oracle11
HA Service Daemon CSS Agent	$GRID_HOME/log/<host>/agent/ohasd/oracssdagent_root
HA Service Daemon ocssd Monitor Agent	$GRID_HOME/log/<host>/agent/ohasd/oracssdmonitor_root
HA Service Daemon Oracle Root Agent	$GRID_HOME/log/<host>/agent/ohasd/orarootagent_root
CRS Daemon Oracle Agent	$GRID_HOME/log/<host>/agent/crsd/oraagent_oracle11
CRS Daemon Oracle Root Agent	$GRID_HOME/log/<host> agent/crsd/orarootagent_root
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/

 

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

Oracle log files Troubleshooting Oracle