This discussion is archived
3 Replies Latest reply: Aug 31, 2013 7:23 AM by Levi-Pereira RSS

Automating the log files to be required by Oracle Support

Sivaprasad S Newbie
Currently Being Moderated

Environmnet: HP-UX B.11.31 U ia64

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

 

Question:

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points