3 Replies Latest reply on Aug 31, 2013 2:23 PM by Levi Pereira

    Automating the log files to be required by Oracle Support

    Siva Ora

      Environmnet: HP-UX B.11.31 U ia64

      RDBMS: Oracle Database 11g Enterprise Edition Release - 64bit Production with 2 Node RAC



      When server hangs or node evicts, we open up tickets with Oracle Support and Oracle  Support ask for some list of log files.

      Currently we can not use the TFA(trace file analyzer)  tool/script.

      We like to automate the log from following location;


      Clusterware related:
      1.CRS logs from $ORA_CRS_HOME/log/<hostname>/crsd/
      2.CSS logs from $ORA_CRS_HOME/log/<hostname>/cssd/
      3.CRS alert<nodename>.log present from the  $ORA_CRS_HOME/log/<hostname>

      OS related
      4.OS log /var/adm/syslog/syslog.log
      5. OSWatcher logs from all nodes

      DB related
      6. DB alert.log and all trace files from bdump & udump directories generated at time of problem
      7. If ASM from use same information from it is needed


      Let me know if there any other log files commonly required by Oracle support.


      What are tbe best approach to automate this?  Like using Shell script on Unix.