Skip to content

Oracle RAC Log Files

    Oracle RAC Log Files are used in diagnose problems for Oracle Real Application Clusters (Oracle RAC) components

    Oracle Database records information about important events that occur in your Oracle RAC environment in trace files. The trace files for Oracle RAC are the same as those in noncluster Oracle databases. As a best practice, monitor and back up trace files regularly for all instances to preserve their content for future troubleshooting.

    Information about ORA-600 errors appear in the alert_SID.log file for each instance where SID is the instance identifier.

    The alert log and all trace files for background and server processes are written to the Automatic Diagnostic Repository, the location of which you can specify with the DIAGNOSTIC_DEST initialization parameter. For example:

    $ORACLE_BASE/diag/rdbms/$DBNAME/$SID_NAME/trace

    Oracle Database creates a different trace file for each background thread. Oracle RAC background threads use trace files to record database operations and database errors. These trace logs help troubleshoot and also enable Oracle Support to more efficiently debug cluster database configuration problems. The names of trace files are operating system specific, but each file usually includes the name of the process writing the file (such as LGWR and RECO). For Linux, UNIX, and Windows systems, trace files for the background processes are named SID_process_name_process_identifier.trc.

    Location of Cluster Logfiles in 12.2

    adrci> SHOW LOG
    Choose the home from which to view diagnostic logs:
    1: diag/rdbms/_mgmtdb/-MGMTDB
    2: diag/asm/+asm/+ASM1
    3: diag/crs/node1/crs
    4: diag/clients/user_oracle/host_1268558819_107
    5: diag/tnslsnr/node1/asmnet1lsnr_asm
    6: diag/tnslsnr/node1/listener_scan1
    7: diag/tnslsnr/node1/listener_scan2
    8: diag/tnslsnr/node1/listener_scan3
    9: diag/tnslsnr/node1/listener
    10: diag/tnslsnr/node1/mgmtlsnr
    
    Q: to quit

    The Cluster Ready Services Daemon (crsd) Log Files

    Log files for the CRSD process (crsd) can be found in the following directories:

    CRS home/log/hostname/crsd

    Oracle Cluster Registry (OCR) Log Files

    The Oracle Cluster Registry (OCR) records log information in the following location:

    CRS Home/log/hostname/client

    Cluster Synchronization Services (CSS) Log Files

    You can find CSS information that the OCSSD generates in log files in the following locations:

    CRS Home/log/hostname/cssd

    Event Manager (EVM) Log Files

    Event Manager (EVM) information generated by evmd is recorded in log files in the following locations:

    CRS Home/log/hostname/evmd

    RACG Log Files

    The Oracle RAC high availability trace files are located in the following two locations:

    CRS home/log/hostname/racg

    $ORACLE_HOME/log/hostname/racg

    Core files are in the sub-directories of the log directories. Each RACG executable has a sub-directory assigned exclusively for that executable. The name of the RACG executable sub-directory is the same as the name of the executable.

    You can follow below table which define locations of logs files:

    Oracle Clusterware log files

    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

    Oracle RAC 11g Release 2 log files

    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

    Also See:

    ORAchk

    Oracle Clusterware Diagnostic and Alert Log Data