Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The Remote Diagnostic Agent (RDA) is a tool provided by Oracle that collects data about your database environment and reports it as a web page.
RDA output is usually requested when you open a call via Oracle Support. This will allow the support analyst to review many information about your system.
By running RDA in a new database, it is possible to reach a lot of information about that database without asking anyone.
The current version of the RDA tool can be found in the links in the document “Remote Diagnostic Agent (RDA) – Getting Started (Doc ID 314422.1)” in Oracle Support.
Download the zip file according to your system’s operating system as described in this document and open it in any directory. Then, run the following commands.
1 2 3 4 | [oracle@orcldb01 ~]$ unzip p21769913_81617613_Linux-x86-64.zip ..... [oracle@orcldb01 ~]$ cd rda [oracle@orcldb01 rda]$ chmod +x rda* |
Then you need to run the rda.sh file for Linux systems. After running, it will ask a number of questions, then begin analysis. You will need to enter “sys” when the database user is asked. It writes “system” by default. Be careful about this.
If you are in the Exadata environment, it can also analyze all cellnodes. If you know the password of the celladmin, it can connect to all cellnodes.
You can run it in Linux environment as follows. In Windows environment, rda.cmd should be used.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 | [oracle@orcldb01 ~]$ ./rda.sh .......................... Processing RDA.BEGIN module ... Enter the password for "SYS as SYSDBA" at "ORCL1": Re-enter it to confirm: Entries do not match. Try again ... Enter the password for "SYS as SYSDBA" at "ORCL1": Re-enter it to confirm: Processing OS.PERF module ... Processing RDA.CONFIG module ... Processing SAMPLE.SAMPLE module ... Processing OS.OS module ... Processing OS.PROF module ... Processing OS.NET module ... Processing OS.ONET module ... Listener checks may take a few minutes. Be patient... Processing listener LISTENER Processing listener LISTENER_CLONEDB Processing OS.INST module ... Processing OS.OVMS module ... Processing DB.DBA module ... Processing DB.EXA module ... Enter celladmin at 192.168.10.1 password: Re-enter it to confirm: Enter celladmin at 192.168.10.2 password: Re-enter it to confirm: Enter celladmin at 192.168.10.3 password: Re-enter it to confirm: Enter celladmin at 192.168.10.4 password: Re-enter it to confirm: Enter celladmin at 192.168.10.5 password: Re-enter it to confirm: Enter celladmin at 192.168.10.6 password: Re-enter it to confirm: Enter celladmin at 192.168.10.7 password: Re-enter it to confirm: Enter celladmin at 192.168.10.8 password: Re-enter it to confirm: Enter celladmin at 192.168.10.9 password: Re-enter it to confirm: Enter celladmin at 192.168.10.10 password: Re-enter it to confirm: Enter celladmin at 192.168.10.11 password: Re-enter it to confirm: Enter celladmin at 192.168.10.12 password: Re-enter it to confirm: Enter celladmin at 192.168.10.13 password: Re-enter it to confirm: Enter celladmin at 192.168.10.14 password: Re-enter it to confirm: The cell data collection can take more than 750 seconds. Do not interrupt the data collection. Processing OFM.WREQ module ... This can take time. Be patient ... Processing OFM.IREQ module ... Processing RDA.LOAD module ... Processing RDA.END module ... ------------------------------------------------------------------------------ RDA Data Collection Ended 08-Sep-2017 15:13:52 ------------------------------------------------------------------------------ You can review the reports by transferring the /home/oracle/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 Based on your server configuration, some possible alternative approaches are: - If your client computer with a browser has access to a web-shared directory, copy the /home/oracle/rda/output directory structure to the web-shared directory and visit this URL: http://machine:port/web_shared_directory/RDA__start.htm or - If your client computer with a browser has FTP access to the server computer with the /home/oracle/rda/output directory, visit this URL: ftp://root@orcldb01/rda/output If this file was generated to assist in resolving a Service Request, send /home/oracle/rda/RDA_output_orcldb01.zip to Oracle Support by uploading the file via My Oracle Support. When sending with FTP, make sure you send it in BINARY format. Note: Do not submit any health, payment card or other sensitive production data that requires protections greater than those specified in the Oracle GCS Security Practices (http://www.oracle.com/us/support/library/customer-support-security-practices-069170.pdf). Information on how to remove data from your submission is available at https://support.oracle.com/rs?type=doc&id=1227943.1 |
The process will be completed as above. You can then find the necessary information in the file “RDA_output_ {hostname} .zip” in the directory that you run the rda.sh.
