Table of Contents
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)