Friday, February 17, 2012

Oracle Clusterware Log Files (11.2)

Investigating a RAC error can be a minefield when it comes to log files. Below are a list of Clusterware log files and their associated process that can be used to diagnose/resolve errors.

A good MOS (My Oracle Support) note for diagnosing Grid Infrastructure (Clusterware) issues on startup:
Troubleshoot Grid Infrastructure Startup Issues [ID 1050908.1]

For the below log file names server hostname is "myserver01" and Grid Infrastructure is installed under /app/11.2.0/grid/ (UNIX).

Summary of all Clusterware events on this host
$GI_HOME/log/myserver01/alertmyserver01.log

Oracle High Availability Services Daemon OUT
$GI_HOME/log/myserver01/ohasd/ohasdOUT.log

Oracle High Availability Services Daemon
$GI_HOME/log/myserver01/ohasd/ohasd.log

Cluster Ready Services OUT
$GI_HOME/log/myserver01/crsd/crsdOUT.log

Cluster Ready Services Daemon
$GI_HOME/log/myserver01/crsd/crsd.log

Cluster Synchronisation Service OUT
$GI_HOME/log/myserver01/cssd/cssdOUT.log

Cluster Synchronisation Service Daemon
$GI_HOME/log/myserver01/cssd/ocssd.log

Alert log for ASM (ADR - Automatic Diagnostic Repository = /app/oracle/diag/)
/app/oracle/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log

Cluster Ready Services Monitor Agent
$GI_HOME/log/myserver01/agent/crsd/oraagent_grid/oraagent_grid.log

Cluster Ready Services Root Agent
$GI_HOME/log/myserver01/agent/crsd/orarootagent_root/orarootagent_root.log

Oracle High Availability Services Monitor Agent
$GI_HOME/log/myserver01/agent/ohasd/oraagent_grid/oraagent_grid.log

Oracle High Availability Services Root Agent
$GI_HOME/log/myserver01/agent/ohasd/orarootagent_root/orarootagent_root.log

Cluster Synchronisation Service Root Agent (under OHAS)
$GI_HOME/log/myserver01/agent/ohasd/oracssdagent_root/oracssdagent_root.log

Cluster Synchronisation Service Monitor Agent (under OHAS)
$GI_HOME/log/myserver01/agent/ohasd/oracssdmonitor_root/oracssdmonitor_root.log

In addition to the above I recently found this page in the documentation:

  • Clusterware Log Files and the Unified Log Directory Structure

  • No comments:

    Post a Comment