The Remote Diagnostic Agent (RDA) is an Oracle-provided diagnostic tool that captures data about your database environment and packages it into a web page report. When submitting a Service Request to Oracle Support, you will often be asked to run the Remote Diagnostic Agent (RDA) and upload the results. This allows the support analyst to review a lot of information about your system with very little effort on your part. It saves time by eliminating a lot of back and forth questions.
Even when not dealing with Oracle Support, I find RDA is a great tool for understanding an environment and troubleshooting issues. In my job as a Remote DBA, I often get involved in unfamiliar environments and RDA can allow me to quickly get up to speed. It provides a wealth of information in a format that is easy to use and (mostly) easy to understand.
Here are some simple instructions for installing and using RDA
On the Oracle Support web site, search for document Id 314422.1 Remote Diagnostic Agent (RDA) 4 – Getting Started
Click on Download RDA and select the appropriate Zip file for your platform
Unzip the file to any location and make it executable (chmod +x)
To run RDA, just execute rda.sh from the unzipped location. Initially. it will prompt for you for information, such as the name of the database and a username that can connect to it. Follow the prompts and they are mostly self-explanatory.
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
Steps and Commands:
| UNIX / LINUX | WINDOWS | |
| Unzip Files | use Unix/Linux utility | use any Windows utility |
| Instructions | README_Unix.txt/README_Linux.txt | README_Windows.txt |
| Verify Installation | rda.sh -cv | rda.cmd -cv |
| Run Setup | rda.sh -S or rda.pl -S | rda.cmd -S or rda.pl -S |
| Run RDA | rda.sh -v or rda.pl -v | rda.cmd -v |
| To view RDA | Open RDA_INDEX.htm from the RDA output directory | |
What kind of licences are required to run this rda in our env.