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.<\/p>\n
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.<\/p>\n
By running RDA in a new database, it is possible to reach a lot of information about that database without asking anyone.<\/p>\n
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.<\/p>\n
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.<\/p>\n
[oracle@orcldb01 ~]$ unzip p21769913_81617613_Linux-x86-64.zip\n.....\n[oracle@orcldb01 ~]$ cd rda\n[oracle@orcldb01 rda]$ chmod +x rda*<\/pre>\nThen 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<\/strong>” when the database user is asked. It writes “system<\/strong>” by default. Be careful about this<\/strong>.<\/p>\n
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.<\/p>\n
You can run it in Linux environment as follows. In Windows environment, rda.cmd should be used.<\/p>\n
[oracle@orcldb01 ~]$ .\/rda.sh\n\n..........................\n\nProcessing RDA.BEGIN module ...\nEnter the password for \"SYS as SYSDBA\" at \"ORCL1\": \nRe-enter it to confirm: \nEntries do not match. Try again ...\nEnter the password for \"SYS as SYSDBA\" at \"ORCL1\": \nRe-enter it to confirm: \nProcessing OS.PERF module ...\nProcessing RDA.CONFIG module ...\nProcessing SAMPLE.SAMPLE module ...\nProcessing OS.OS module ...\nProcessing OS.PROF module ...\nProcessing OS.NET module ...\nProcessing OS.ONET module ...\nListener checks may take a few minutes. Be patient...\n Processing listener LISTENER\n Processing listener LISTENER_CLONEDB\nProcessing OS.INST module ...\nProcessing OS.OVMS module ...\nProcessing DB.DBA module ...\nProcessing DB.EXA module ...\nEnter celladmin at 192.168.10.1 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.2 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.3 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.4 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.5 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.6 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.7 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.8 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.9 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.10 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.11 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.12 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.13 password:\nRe-enter it to confirm: \nEnter celladmin at 192.168.10.14 password:\nRe-enter it to confirm: \nThe cell data collection can take more than 750 seconds. Do not interrupt the\ndata collection.\nProcessing OFM.WREQ module ...\nThis can take time. Be patient ...\nProcessing OFM.IREQ module ...\nProcessing RDA.LOAD module ...\nProcessing RDA.END module ...\n------------------------------------------------------------------------------\nRDA Data Collection Ended 08-Sep-2017 15:13:52\n------------------------------------------------------------------------------\n You can review the reports by transferring the \/home\/oracle\/rda\/output\n directory structure to a location where you have web-browser access. Then,\n point your browser at this file to display the reports:\n RDA__start.htm\n\n Based on your server configuration, some possible alternative approaches\n are:\n - If your client computer with a browser has access to a web-shared\n directory, copy the \/home\/oracle\/rda\/output directory structure to the\n web-shared directory and visit this URL:\n http:\/\/machine:port\/web_shared_directory\/RDA__start.htm\n or\n - If your client computer with a browser has FTP access to the server\n computer with the \/home\/oracle\/rda\/output directory, visit this URL:\n ftp:\/\/root@orcldb01\/rda\/output\n\n If this file was generated to assist in resolving a Service Request, send\n \/home\/oracle\/rda\/RDA_output_orcldb01.zip to Oracle Support by uploading the\n file via My Oracle Support. When sending with FTP, make sure you send it in\n BINARY format.\n\n Note: Do not submit any health, payment card or other sensitive production\n data that requires protections greater than those specified in the Oracle\n GCS Security Practices\n (http:\/\/www.oracle.com\/us\/support\/library\/customer-support-security-practices-069170.pdf).\n Information on how to remove data from your submission is available at\n https:\/\/support.oracle.com\/rs?type=doc&id=1227943.1<\/pre>\nThe 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.<\/p>\n\n
<\/div>\n