RDA captures data and provides Oracle support with a comprehensive picture of the customer's environment which aids in problem diagnosis. The goal of this article is to detail the steps on how to gather basic configuration, log and platform information from Oracle OpenSSO using the Remote Diagnostic Agent.
Instructions for UNIX/ZLinux Type Operating Systems
Choose or create a directory or area on your UNIX server. Make sure you have sufficient space for the RDA output (150MB). It does not matter where you create this directory or what it is named, but the same user that runs RDA must own it. Do not use a directory that contains an older version of RDA unless you have deleted the previous version of RDA first. If necessary, you can reuse prior setup files.
Note: The rda.zip creates a directory named "rda" containing all the required files when you extract it.
Installation Instruction
Do not extract the contents of the RDA archive on a Windows client first or you will have to remove the ^M characters from the end of each line in all of the shell scripts in order for them to run.
downloaded rda.zip file from oracle support as compitable your OS, I'm using UNIX server.
step 1.
Extract the .zip archive contents into a new directory, preserving the directory structure of the archive. Do not extract into a directory that contains an older RDA version. For example:
unzip rda.zip
step 2.
Change directory to the 'rda' directory created by the above command, for example:
cd rda
setp 3.
Make sure the RDA command 'rda.sh' is executable. To verify, enter the following command:
ls -l rda.sh
If the script is not executable, update it using the command:
chmod +x rda.sh
step 4.
The following command checks that you have a viable installation of RDA by checking that all file versions are as expected:
./rda.sh -cv
output like below
===================
Loading the file list ...
Checking the directory [D_RDA] . ...
Checking the directory [D_RDA] engine ...
Checking the directory [D_RDA_ADM] model ...
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_CHK] EM ...
Checking the directory [D_RDA_CHK] OFM ...
Checking the directory [D_RDA_CHK] TEST ...
Checking the directory [D_RDA_COL] APPS ...
Checking the directory [D_RDA_COL] BI ...
Checking the directory [D_RDA_COL] CGBU ...
Checking the directory [D_RDA_COL] CLOUD ...
Checking the directory [D_RDA_COL] DA ...
Checking the directory [D_RDA_COL] DB ...
Checking the directory [D_RDA_COL] EM ...
Checking the directory [D_RDA_COL] EXPLORER ...
Checking the directory [D_RDA_COL] OFM ...
Checking the directory [D_RDA_COL] OS ...
Checking the directory [D_RDA_COL] PGBU ...
Checking the directory [D_RDA_COL] RDA ...
Checking the directory [D_RDA_COL] SAMPLE ...
Checking the directory [D_RDA_COL] TOOL ...
Checking the directory [D_RDA_CSS] . ...
Checking the directory [D_RDA_DAT] . ...
Checking the directory [D_RDA_DFW] cv0200 ...
Checking the directory [D_RDA_INC] Convert/Common ...
Checking the directory [D_RDA_INC] Convert/DB/LOG ...
Checking the directory [D_RDA_INC] Convert/OFM/OIM ...
Checking the directory [D_RDA_INC] Convert/OS/INST ...
Checking the directory [D_RDA_INC] Convert/OS/OS ...
Checking the directory [D_RDA_INC] Convert/RDA/CONFIG ...
Checking the directory [D_RDA_INC] Convert/TOOL/ALERT ...
Checking the directory [D_RDA_INC] Convert/TOOL/COMPLY ...
Checking the directory [D_RDA_INC] IRDA ...
Checking the directory [D_RDA_INC] IRDA/CV0200 ...
Checking the directory [D_RDA_INC] RDA ...
Checking the directory [D_RDA_INC] RDA/Agent ...
Checking the directory [D_RDA_INC] RDA/Driver ...
Checking the directory [D_RDA_INC] RDA/Handle ...
Checking the directory [D_RDA_INC] RDA/Library ...
Checking the directory [D_RDA_INC] RDA/Limit ...
Checking the directory [D_RDA_INC] RDA/Local ...
Checking the directory [D_RDA_INC] RDA/Object ...
Checking the directory [D_RDA_INC] RDA/Operator ...
Checking the directory [D_RDA_INC] RDA/Request ...
Checking the directory [D_RDA_INC] RDA/SDCL ...
Checking the directory [D_RDA_INC] RDA/SDSL ...
Checking the directory [D_RDA_INC] RDA/Target ...
Checking the directory [D_RDA_INC] RDA/Token ...
Checking the directory [D_RDA_INC] RDA/UI ...
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
===================
Loading the file list ...
Checking the directory [D_RDA] . ...
Checking the directory [D_RDA] engine ...
Checking the directory [D_RDA_ADM] model ...
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_CHK] EM ...
Checking the directory [D_RDA_CHK] OFM ...
Checking the directory [D_RDA_CHK] TEST ...
Checking the directory [D_RDA_COL] APPS ...
Checking the directory [D_RDA_COL] BI ...
Checking the directory [D_RDA_COL] CGBU ...
Checking the directory [D_RDA_COL] CLOUD ...
Checking the directory [D_RDA_COL] DA ...
Checking the directory [D_RDA_COL] DB ...
Checking the directory [D_RDA_COL] EM ...
Checking the directory [D_RDA_COL] EXPLORER ...
Checking the directory [D_RDA_COL] OFM ...
Checking the directory [D_RDA_COL] OS ...
Checking the directory [D_RDA_COL] PGBU ...
Checking the directory [D_RDA_COL] RDA ...
Checking the directory [D_RDA_COL] SAMPLE ...
Checking the directory [D_RDA_COL] TOOL ...
Checking the directory [D_RDA_CSS] . ...
Checking the directory [D_RDA_DAT] . ...
Checking the directory [D_RDA_DFW] cv0200 ...
Checking the directory [D_RDA_INC] Convert/Common ...
Checking the directory [D_RDA_INC] Convert/DB/LOG ...
Checking the directory [D_RDA_INC] Convert/OFM/OIM ...
Checking the directory [D_RDA_INC] Convert/OS/INST ...
Checking the directory [D_RDA_INC] Convert/OS/OS ...
Checking the directory [D_RDA_INC] Convert/RDA/CONFIG ...
Checking the directory [D_RDA_INC] Convert/TOOL/ALERT ...
Checking the directory [D_RDA_INC] Convert/TOOL/COMPLY ...
Checking the directory [D_RDA_INC] IRDA ...
Checking the directory [D_RDA_INC] IRDA/CV0200 ...
Checking the directory [D_RDA_INC] RDA ...
Checking the directory [D_RDA_INC] RDA/Agent ...
Checking the directory [D_RDA_INC] RDA/Driver ...
Checking the directory [D_RDA_INC] RDA/Handle ...
Checking the directory [D_RDA_INC] RDA/Library ...
Checking the directory [D_RDA_INC] RDA/Limit ...
Checking the directory [D_RDA_INC] RDA/Local ...
Checking the directory [D_RDA_INC] RDA/Object ...
Checking the directory [D_RDA_INC] RDA/Operator ...
Checking the directory [D_RDA_INC] RDA/Request ...
Checking the directory [D_RDA_INC] RDA/SDCL ...
Checking the directory [D_RDA_INC] RDA/SDSL ...
Checking the directory [D_RDA_INC] RDA/Target ...
Checking the directory [D_RDA_INC] RDA/Token ...
Checking the directory [D_RDA_INC] RDA/UI ...
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
step 5.
Now run RDA here for Preinstallation checks and co-ordinate with SA for failed checks/fixes.
./rda.sh -T hcve
Output like below
==============
==============
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Linux)
3. Oracle Database 11g R1 (11.1) Preinstall (Linux)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Linux)
5. Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)
6. Oracle Database 12c R2 (12.2.0) Preinstallation (Linux)
7. Oracle Database 18c Preinstallation (Linux)
8. Oracle Database 19c Preinstallation (Linux)
9. Oracle Identity and Access Management PreInstall Check: Oracle Identity
and Access Management 11g Release 2 (11.1.2) Linux
10. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 11g Release 2
(11.1.2.4) Linux
11. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 12c (12.1.3)
Linux
12. OAS PreInstall Check: Application Server 10g R2 (10.1.2) Linux
13. OAS PreInstall Check: Application Server 10g R3 (10.1.3) Linux
14. OFM PreInstall Check: Oracle Fusion Middleware 11g R1 (11.1.1) Linux
15. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.1.3) Linux
16. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.2.1.3.0) Linux
17. Oracle Forms and Reports PreInstall Check: Oracle Forms and Reports 11g
Release 2 (11.1.2) Linux
18. Portal PreInstall Check: Oracle Portal Generic
19. IDM PreInstall Check: Identity Management 10g (10.1.4) Linux
20. BIEE PreInstall Check: Business Intelligence Enterprise Edition 11g
(11.1.1) Linux
21. EPM PreInstall Check: Enterprise Performance Management Server (11.1.2)
Generic
22. Oracle Enterprise Manager Cloud Control PreInstall Check: Oracle
Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) Linux
23. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 and
x86_64)
24. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 and
x86_64)
25. Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)
Available Post-Installation Rule Sets:
26. RAC 10G DB and OS Best Practices (Linux)
27. Data Guard Postinstall (Generic)
28. WLS PostInstall Check: WebLogic Server 11g (10.3.x) Generic
29. WLS PostInstall Check: WebLogic Server 12c (12.x) Generic
30. Portal PostInstall Check: Oracle Portal Generic
31. OC4J PostInstall Check: Oracle Containers for J2EE 10g (10.1.x) Generic
32. SOA PostInstall Check: Service-Oriented Architecture 11g and Later
Generic
33. OSB PostInstall Check: Service Bus 11g and Later Generic
34. Oracle Forms 11g Post Installation (Generic)
35. Oracle Enterprise Manager Agent 12c Post Installation (Generic)
36. Oracle Management Server 12c Post Installation (Generic)
37. Network Charging and Control Database Post Installation (Generic)
Enter the HCVE rule set number or 0 to cancel the test
Press Return to accept the default (0)
> 8
Performing HCVE checks ...
Enter value for < Planned ORACLE_HOME location >
Press Return to accept the default (/u01/app/oracle/product/12.1.0/db_1)
>
Test "Oracle Database 19c Preinstallation (Linux)" executed at 16-Jul-2022 21:36:39
Test Results
~~~~~~~~~~~~
(Note : Current Health Check rulesets do not have logic to support checks against Oracle Cloud or Exadata environments. If your product is installed in such an environment some test results will be erroneous. Refer instead to the product documentation rather than rely on the data below.)
ID NAME RESULT VALUE
====== ==================== ======= ==========================================
A00100 OS Certified? FAILED Not certified [Oracle Linux version]
A01020 User in /etc/passwd? PASSED userOK
A01040 Group in /etc/group? PASSED GroupOK
A01050 Enter ORACLE_HOME RECORD /u01/app/oracle/product/12.1.0/db_1
A01060 ORACLE_HOME Valid? PASSED OHexists
A01070 O_H Permissions OK? PASSED CorrectPerms
A01410 oraInventory Permiss PASSED oraInventoryOK
A01420 Other OUI Up? PASSED NoOtherOUI
A01430 Got Software Tools? PASSED ld_nm_ar_make_found
A01440 Other O_Hs in PATH? FAILED OratabEntryInPath
A02010 Umask Set to 022? PASSED UmaskOK
A02030 Limits Processes PASSED Adequate
A02040 Limits Stacksize PASSED Adequate
A02050 Limits Descriptors PASSED Adequate
A02100 LDLIBRARYPATH Unset? FAILED IsSet
A02170 JAVA_HOME Unset? PASSED UnSet
A03100 RAM (in MB) PASSED 5982
A02210 Kernel Parameters OK PASSED KernelOK
A02300 Tainted Kernel? PASSED NotVerifiable
A03010 Temp Adequate? PASSED TempSpaceOK
A03020 Disk Space OK? PASSED DiskSpaceOK
A03050 Swap (in MB) RECORD 3999
A03100 RAM (in MB) PASSED 5982
A03150 SwapToRam OK? FAILED SwapToRamTooLow
A03500 Network PASSED Connected
A03510 IP Address RECORD 192.168.219.2
A03530 Domain Name RECORD NotFound
A03540 /etc/hosts Format FAILED No entry found
A03550 DNS Lookup FAILED nslookup host.domain
A03600 ip_local_port_range PASSED RangeOK
A04305 OL7 Server RPMs OK? SKIPPED NotOL7
A04315 RHEL7 Server RPMs OK SKIPPED NotRedHat
A04321 SLES12 Server RPMs O SKIPPED NotSuSE
A04325 SLES15 Server RPMs O SKIPPED NotSuSE
Result file: output/collect/DB_HCVE_A_DB19c_lin_res.htm
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Linux)
3. Oracle Database 11g R1 (11.1) Preinstall (Linux)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Linux)
5. Oracle Database 12c R1 (12.1.0) Preinstallation (Linux)
6. Oracle Database 12c R2 (12.2.0) Preinstallation (Linux)
7. Oracle Database 18c Preinstallation (Linux)
8. Oracle Database 19c Preinstallation (Linux)
9. Oracle Identity and Access Management PreInstall Check: Oracle Identity
and Access Management 11g Release 2 (11.1.2) Linux
10. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 11g Release 2
(11.1.2.4) Linux
11. Oracle JDeveloper PreInstall Check: Oracle JDeveloper 12c (12.1.3)
Linux
12. OAS PreInstall Check: Application Server 10g R2 (10.1.2) Linux
13. OAS PreInstall Check: Application Server 10g R3 (10.1.3) Linux
14. OFM PreInstall Check: Oracle Fusion Middleware 11g R1 (11.1.1) Linux
15. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.1.3) Linux
16. OFM PreInstall Check: Oracle Fusion Middleware 12c (12.2.1.3.0) Linux
17. Oracle Forms and Reports PreInstall Check: Oracle Forms and Reports 11g
Release 2 (11.1.2) Linux
18. Portal PreInstall Check: Oracle Portal Generic
19. IDM PreInstall Check: Identity Management 10g (10.1.4) Linux
20. BIEE PreInstall Check: Business Intelligence Enterprise Edition 11g
(11.1.1) Linux
21. EPM PreInstall Check: Enterprise Performance Management Server (11.1.2)
Generic
22. Oracle Enterprise Manager Cloud Control PreInstall Check: Oracle
Enterprise Manager Cloud Control 12c Release 4 (12.1.0.4) Linux
23. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 and
x86_64)
24. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 and
x86_64)
25. Oracle E-Business Suite Release 12 (12.2.0) Preinstall (Linux x86_64)
Available Post-Installation Rule Sets:
26. RAC 10G DB and OS Best Practices (Linux)
27. Data Guard Postinstall (Generic)
28. WLS PostInstall Check: WebLogic Server 11g (10.3.x) Generic
29. WLS PostInstall Check: WebLogic Server 12c (12.x) Generic
30. Portal PostInstall Check: Oracle Portal Generic
31. OC4J PostInstall Check: Oracle Containers for J2EE 10g (10.1.x) Generic
32. SOA PostInstall Check: Service-Oriented Architecture 11g and Later
Generic
33. OSB PostInstall Check: Service Bus 11g and Later Generic
34. Oracle Forms 11g Post Installation (Generic)
35. Oracle Enterprise Manager Agent 12c Post Installation (Generic)
36. Oracle Management Server 12c Post Installation (Generic)
37. Network Charging and Control Database Post Installation (Generic)
Enter the HCVE rule set number or 0 to cancel the test
Press Return to accept the default (0)
> 8
Performing HCVE checks ...
Enter value for < Planned ORACLE_HOME location >
Press Return to accept the default (/u01/app/oracle/product/12.1.0/db_1)
>
Test "Oracle Database 19c Preinstallation (Linux)" executed at 16-Jul-2022 21:36:39
Test Results
~~~~~~~~~~~~
(Note : Current Health Check rulesets do not have logic to support checks against Oracle Cloud or Exadata environments. If your product is installed in such an environment some test results will be erroneous. Refer instead to the product documentation rather than rely on the data below.)
ID NAME RESULT VALUE
====== ==================== ======= ==========================================
A00100 OS Certified? FAILED Not certified [Oracle Linux version]
A01020 User in /etc/passwd? PASSED userOK
A01040 Group in /etc/group? PASSED GroupOK
A01050 Enter ORACLE_HOME RECORD /u01/app/oracle/product/12.1.0/db_1
A01060 ORACLE_HOME Valid? PASSED OHexists
A01070 O_H Permissions OK? PASSED CorrectPerms
A01410 oraInventory Permiss PASSED oraInventoryOK
A01420 Other OUI Up? PASSED NoOtherOUI
A01430 Got Software Tools? PASSED ld_nm_ar_make_found
A01440 Other O_Hs in PATH? FAILED OratabEntryInPath
A02010 Umask Set to 022? PASSED UmaskOK
A02030 Limits Processes PASSED Adequate
A02040 Limits Stacksize PASSED Adequate
A02050 Limits Descriptors PASSED Adequate
A02100 LDLIBRARYPATH Unset? FAILED IsSet
A02170 JAVA_HOME Unset? PASSED UnSet
A03100 RAM (in MB) PASSED 5982
A02210 Kernel Parameters OK PASSED KernelOK
A02300 Tainted Kernel? PASSED NotVerifiable
A03010 Temp Adequate? PASSED TempSpaceOK
A03020 Disk Space OK? PASSED DiskSpaceOK
A03050 Swap (in MB) RECORD 3999
A03100 RAM (in MB) PASSED 5982
A03150 SwapToRam OK? FAILED SwapToRamTooLow
A03500 Network PASSED Connected
A03510 IP Address RECORD 192.168.219.2
A03530 Domain Name RECORD NotFound
A03540 /etc/hosts Format FAILED No entry found
A03550 DNS Lookup FAILED nslookup host.domain
A03600 ip_local_port_range PASSED RangeOK
A04305 OL7 Server RPMs OK? SKIPPED NotOL7
A04315 RHEL7 Server RPMs OK SKIPPED NotRedHat
A04321 SLES12 Server RPMs O SKIPPED NotSuSE
A04325 SLES15 Server RPMs O SKIPPED NotSuSE
Result file: output/collect/DB_HCVE_A_DB19c_lin_res.htm
In my case below the file location you just ftp on local machine and check the htm ext. file.
/home/oracle/software/rda/output/collect
-rw-r----- 1 oracle oinstall 19312 Jul 16 21:36 DB_HCVE_A_DB19c_lin_res.txt
-rw-r----- 1 oracle oinstall 29553 Jul 16 21:36 DB_HCVE_A_DB19c_lin_res.htm
Reference:
Remote Diagnostic Agent (RDA) - Getting Started (Doc ID 314422.1)
