Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

Thread: Log Files for Troubleshooting Oracle RAC issues

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    412

    Log Files for Troubleshooting Oracle RAC issues

    The cluster has a number of log files that can be examined to gain any insight of occurring problems
    A good place to start diagnosis for the cluster problems is from the $ORA_CRS_HOME/log/<hostname>/alert<hostname>.log

    All clusterware log files are stored under $ORA_CRS_HOME/log/ directory.

    1. alert<nodename>.log : Important clusterware alerts are stored in this log file.
    It is stored in $ORA_CRS_HOME/log/<hostname>/alert<hostname>.log

    2. crsd.log : CRS logs are stored in $ORA_CRS_HOME/log/<hostname>/crsd/ directory. The crsd.log file is archived every 10MB as crsd.101, crsd.102 ...

    3. cssd.log : CSS logs are stored in $ORA_CRS_HOME/log/<hostname>/cssd/ directory. The cssd.log file is archived every 20MB as cssd.101, cssd.102....

    4. evmd.log : EVM logs are stored in $ORA_CRS_HOME/log/<hostname>/evmd/ directory.

    5. OCR logs : OCR logs (ocrdump, ocrconfig, ocrcheck) log files are stored in $ORA_CRS_HOME/log/<hostname>/client/ directory.

    6. SRVCTL logs: srvctl logs are stored in two locations, $ORA_CRS_HOME/log/<hostname>/client/ and in $ORACLE_HOME/log/<hostname>/client/ directories.

    7. RACG logs : The high availability trace files are stored in two locations
    $ORA_CRS_HOME/log/<hostname>/racg/ and in $ORACLE_HOME/log/<hostname>/racg/ directories.

    RACG contains log files for node applications such as VIP, ONS etc.
    ONS log filename = ora.<hostname>.ons.log
    VIP log filename = ora.<hostname>.vip.log

    Each RACG executable has a sub directory assigned exclusively for that executable.
    racgeut : $ORA_CRS_HOME/log/<hostname>/racg/racgeut/
    racgevtf : $ORA_CRS_HOME/log/<hostname>/racg/racgevtf/
    racgmain : $ORA_CRS_HOME/log/<hostname>/racg/racgmain/

    racgeut : $ORACLE_HOME/log/<hostname>/racg/racgeut/
    racgmain: $ORACLE_HOME/log/<hostname>/racg/racgmain/
    racgmdb : $ORACLE_HOME/log/<hostname>/racg/racgmdb/
    racgimon: $ORACLE_HOME/log/<hostname>/racg/racgimon/


    As in a normal Oracle single instance environment, a RAC environment contains the standard RDBMS log files:

    These files are located by the parameters :

    background_dest_dump contan the alert log and backgrond process trace files.
    user_dump_dest contains any trace file generated by a user process.
    core_dump_dest contains core files that are generated due to a core dump in a user process.
    Last edited by Hemant; 12-15-2011 at 09:11 PM.
    Hemant Fulfagar
    Oracle Administration Architect
    hemant@dbalounge.com
    Skype Name: hemant.fulfagar
    --------------------------------------------------------------------------------------------------------------------------
    DBALounge Provides Oracle DBA Training Services. This includes Online Training, Classroom based Training at Noida (Delhi NCR).
    Students come from Delhi, Gurgaon, Noida, Ghaziabad, Faridabad, Greater Noida .
    Trainings : Oracle Database,10G,11G,RAC,Apps,11i,R12,Fusion Middleware,WebLogic,OID,OBIEE,OAM,OIM,Directory Services,Oracle VM.

+ Reply to Thread

Similar Threads

  1. Administering .dbc Files
    By pkumar in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 02-29-2012, 06:42 AM
  2. Oracle Database Online Redo Log Files Management.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-13-2012, 10:40 PM
  3. Common / Known Issues with OPMN Startup
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 2
    Last Post: 11-01-2011, 11:38 AM
  4. Oracle Applications R12 Log Files
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 08:38 PM
  5. Oracle Applications 11i Components, Configuration Files and Log Files
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 10-29-2011, 07:52 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics