Using RDA in a RAC environment

Overview

  • Syntax used  for RDA is based on RDA 8.04
  • RDA provides a lot of information
  • Need to clarify whether I need to run RDA as grid or oracle user when investigating ASM issues

Installation

Unzip DBSupportBundle and RDA support bundle and verify RDA installation 

$ cp /media/sf_Kits/Toolsbundle/DBSupportBundle_v1_3_5.zip .
$ unzip DBSupportBundle_v1_3_5.zip
Archive:  DBSupportBundle_v1_3_5.zip
   creating: DBSupportBundle/
  inflating: DBSupportBundle/darda_8.04-20140610.zip  
   creating: DBSupportBundle/deploy/
  inflating: DBSupportBundle/deploy/db_bundle_state.sh  
  inflating: DBSupportBundle/deploy/ORAchk_install.sh  
...
[grid@grac41 ~]$ cd DBSupportBundle
[grid@grac41 DBSupportBundle]$ ls
darda_8.04-20140610.zip  deploy  orachk.zip  oratop.zip  oswbb.tar  prw.zip  README.txt  sqlt.zip  SupportBundle.properties  TFALite.zip

Unzip RDA zip 
[grid@grac41 DBSupportBundle]$ unzip darda_8.04-20140610.zip
Archive:  darda_8.04-20140610.zip
   creating: rda/
   creating: rda/Convert/
   creating: rda/Convert/Common/
   creating: rda/Convert/DB/
...

DBSupportBundle]$ cd rda
[grid@grac41 rda]$ ls
admin     da           engine  irda.pl    Pod     rda.com  README_irda.txt     README_VMS.txt      sdci.pl
collect  dfw           hcve    mesg    RDA     rda.pl   README_Unix.txt     README_Windows.txt  sdci.sh
Convert  DISCLAIM.txt  IRDA    modules    rda.cmd  rda.sh   README_upgrade.txt  sdci.cmd          tools

Set proper protections
[grid@grac41 rda]$ pwd
/home/grid/DBSupportBundle/rda
[grid@grac41 rda]$ chmod +x rda*
[grid@grac41 rda]$ ls -l rda*
-r-xr-xr-x. 1 grid oinstall  9099 Jun  3 12:55 rda.cmd
-r-xr-xr-x. 1 grid oinstall  7768 Jun  3 12:55 rda.com
-r-xr-xr-x. 1 grid oinstall 39260 Jun  3 12:55 rda.pl
-r-xr-xr-x. 1 grid oinstall 10490 Jun  3 12:55 rda.sh

Verify RDA installation
[grid@grac41 rda]$ ./rda.sh -cv
Loading the file list ...
Checking the directory [D_RDA] . ...
Checking the directory [D_RDA] engine ...
Checking the directory [D_RDA_CHK] APPS ...
Checking the directory [D_RDA_CHK] BI ...
Checking the directory [D_RDA_CHK] CGBU ...
Checking the directory [D_RDA_CHK] DB ...
Checking the directory [D_RDA_INC] RDA/Value ...
....
Checking the directory [D_RDA_INC] RDA/Web ...
Checking the directory [D_RDA_MSG] charset ...
Checking the directory [D_RDA_MSG] desc ...
Checking the directory [D_RDA_MSG] en ...
Checking the directory [D_RDA_MSG] fr ...
Checking the directory [D_RDA_POD] en ...
No issues found

Verify RAC nodes, PERL version and ssh connectivity
[grid@grac41 rda]$ olsnodes 
grac41
grac42
grac43
[grid@grac41 rda]$ perl -V
Summary of my perl5 (revision 5 version 10 subversion 1) configuration:

Test ssh connectivity
$ ssh grid@grac41 env
$ ssh grid@grac42 env
$ ssh grid@grac43 env

Initial RAC RDA setup to collect cluster nodes

[grid@grac41 rda]$   rda.pl -vXRda start CLOUD -pRac_Assessment
Creating collection "output" ...
 Inside DFT scenario, define the input and profile targets
 Inside DFT scenario, check Oracle home or Middleware presence
    - RDA:DCbegin ...
------------------------------------------------------------------------------
RDA.BEGIN: Initializes the Data Collection
------------------------------------------------------------------------------
Enter the Oracle home to be used for data analysis
Hit "Return" to accept the default (/u01/app/11204/grid)
> 
    - RDA:DCconfig ...
------------------------------------------------------------------------------
RDA.CONFIG: Collects Key Configuration Information
------------------------------------------------------------------------------
    - RDA:DCocm ...
------------------------------------------------------------------------------
RDA.OCM: Set up the Configuration Manager Interface
------------------------------------------------------------------------------
    - RDA:DCstatus ...
------------------------------------------------------------------------------
RDA.STATUS: Produces the Remote Data Collection Reports
------------------------------------------------------------------------------
    - RDA:DCload ...
------------------------------------------------------------------------------
RDA.LOAD: Produces the External Collection Reports
------------------------------------------------------------------------------
    - RDA:DCfilter ...
------------------------------------------------------------------------------
RDA.FILTER: Controls Report Content Filtering
------------------------------------------------------------------------------
    - RDA:DCend ...
------------------------------------------------------------------------------
RDA.END: Finalizes the Data Collection
------------------------------------------------------------------------------
In CRS start scenario, getting nodes using /u01/app/11204/grid/bin/olsnodes
2>/dev/null
------------------------------------------------------------------------------
Requesting common cluster information
------------------------------------------------------------------------------
Enter the absolute path of the directory where RDA will be installed on the
remote nodes.
Hit "Return" to accept the default (/home/grid/DBSupportBundle/rda)
> 
Do you want RDA to use an alternative login to execute remote requests (Y/N)?
Hit "Return" to accept the default (N)
> 
In CRS start scenario, getting local node information
In CRS start scenario, pinging node grac42
In CRS start scenario, pinging node grac43
------------------------------------------------------------------------------
Requesting information for node grac41
------------------------------------------------------------------------------
Enter the Oracle home to be analyzed on the node grac41
Hit "Return" to accept the default (/u01/app/11204/grid)
> 
Enter the Oracle SID to be analyzed on the node grac41
Hit "Return" to accept the default (+ASM1)
> 
------------------------------------------------------------------------------
Requesting information for node grac42
------------------------------------------------------------------------------
Enter the Oracle home to be analyzed on the node grac42
Hit "Return" to accept the default (/u01/app/11204/grid)
> 
Enter the Oracle SID to be analyzed on the node grac42
> +ASM2
------------------------------------------------------------------------------
Requesting information for node grac43
------------------------------------------------------------------------------
Enter the Oracle home to be analyzed on the node grac43
Hit "Return" to accept the default (/u01/app/11204/grid)
> 
Enter the Oracle SID to be analyzed on the node grac43
> +ASM3
    - RDA:DCremote ...
------------------------------------------------------------------------------
RAC Setup Summary
------------------------------------------------------------------------------
Nodes:
. NOD001  grac41/+ASM1
. NOD002  grac42/+ASM2
. NOD003  grac43/+ASM3
3 nodes found

---> You can verify  this installation step by checking config file:  output.cfg

 

List the nodes that has been configured and to check their accessibility

[grid@grac41 rda]$  rda.pl -vC RDA.REMOTE list 
  --> seems with 8.0.4 above command also starts collection  too 
      you may skip this step and run  : $ rda.pl -v -e TRC/TRACE=1 )

Collect the RDA data from remote notes

rda.pl -v -e TRC/TRACE=1
     The -v option is optional, it allows you to view the collection progression.
     The -e REMOTE_TRACE=1 or -e TRC/TRACE=1 allows to you to follow the progress on the remote collections.
---------------------------------------------------------------------
RDA Data Collection Started 17-Jul-2014 11:00:57
------------------------------------------------------------------------------
Processing RDA.BEGIN module ...
 Inside BEGIN module, testing the RDA engine code build
 Inside BEGIN module, testing the report directory
 Inside BEGIN module, testing the module targets
 Inside BEGIN module, launching parallel executions
Processing RDA.CONFIG module ...
 Inside CONFIG module, listing Oracle homes
 Inside CONFIG module, getting Oracle home inventory (can take time)
Processing RDA.REMOTE module ...
NOD002: Detecting storage type
NOD003: Detecting storage type
NOD001: Detecting storage type
NOD001: Running RDA command
NOD002: Installing RDA software
NOD003: Installing RDA software
NOD002: Running RDA command
NOD003: Running RDA command
NOD003: Transfering report package
NOD002: Transfering report package
NOD001: Transfering report package
Processing RDA.END module ...
 Inside END module, gathering system information
 Inside END module, getting CPU information (linux)
 Inside END module, getting memory information (linux)
 Inside END module, producing the file catalog
 Inside END module, producing target overview
 Inside END module, waiting for parallel execution completion
 Inside END module, producing setting overview
------------------------------------------------------------------------------
RDA Data Collection Ended 17-Jul-2014 11:12:54
------------------------------------------------------------------------------
Generating the reports ...
    - collect/RDA_CONFIG_oh_inv.txt ...
    - collect/RDA_END_system.txt ...
    - collect/RDA_END_report.txt ...
    - collect/RDA_END_target.txt ...
    - collect/RDA_END_files.txt ...
    - collect/RDA_CONFIG_homes.txt ...
    - Report index ...
Packaging collection results ...
  You can review the reports by transferring the
  /home/grid/DBSupportBundle/rda/output directory structure to a location
  where you have web-browser access. Then, point your browser at this file to
  display the reports:
    RDA__start.htm
...

Display RDA data

To display the data for remote node RDA_nod003 ( == grac43 )
[grid@grac41 rda]$ cd output/remote
[grid@grac41 remote]$ ls
RDA_nod001_output.zip  RDA_nod002_output.zip  RDA_nod003_output.zip

[grid@grac41 remote]$ mkdir grac43
[grid@grac41 remote]$ cd grac43
[grid@grac41 grac43]$ unzip ../RDA_nod003_output.zip
Archive:  ../RDA_nod003_output.zip
  inflating: META-INF/MANIFEST.MF    
  inflating: DB_ACFS_A.fil        
...
[grid@grac41 grac42]$ firefox /home/grid/DBSupportBundle/rda/output/remote/grac43/RDA__start.htm
--> Note you need to exract the data for the remaining nodes grac41 and grac42 too

To rerun  Node configuration

$. rda.pl -vC RDA.REMOTE retry [<node_id> ...]

Reference

  • Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1)
  • Remote Diagnostic Agent (RDA) – RAC Cluster Guide (Doc ID 359395.1)

 

Leave a Reply

Your email address will not be published. Required fields are marked *