Database 11g

Tuesday, October 20, 2015

Diagcollection.pl in RAC


Diagcollection.pl is a script used to collect the diagnostic information from clusterware. The script provides you with additional information so that the Oracle Support can resolve our problems. Mining data from all the log files is difficult. So, in order to ease of this difficulty in 11gR2 Oracle has given very good option to collect all diagnostic data.

  • Environment: RAC 11gR2 on Windows 2008 Server


set ORACLE_HOME=<GRID_HOME>    for example: set ORACLE_HOME=D:\app\11.2.0\grid
set PATH=%PATH%;%ORACLE_HOME%\perl\bin
perl %ORACLE_HOME%\bin\diagcollection.pl --collect --crshome %ORACLE_HOME%

  • The following .zip files will be generated in the current directory and need to be uploaded:  


crsData_<timestamp>.zip,
ocrData_<timestamp>.zip,
oraData_<timestamp>.zip,
coreData_<timestamp>.zip (only --core option specified)

Note:- Set the oracle home and execute the diag perl script as given by MOS




No comments:

Post a Comment