Environmnet: HP-UX B.11.31 U ia64
RDBMS: Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 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;
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>
4.OS log /var/adm/syslog/syslog.log
5. OSWatcher logs from all nodes
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.