RDA 4.11 is out, with a couple of new features. “Oracle Database Diagnostics Collector” (ORADDC) is one of those. It allows you to easily activate all kinds of traces, dumps, or stack collections.
Once RDA 4.11 installed, run ./rda.pl -T oraddc to collect whatever you need. The tool will guide you. To learn more about its features, you can display its man page: run ./rda.pl -M oraddc or ./rda.pl -M.
This may become one of the most used RDA modules for Oracle Support Services and Oracle database administrators stuck in different situations. For now, let’s start with a more basic question: “How to leverage RDA in a RAC environment ?”
About RDA
RDA (Remote Diagnostic Agent) is one of the primary tools used by Oracle Support Services to diagnose any problem related to the Oracle stacks (from the Virtual Machine to the CRM). You can leverage this tool for your own needs and to speed up your problem resolution.
Using RDA before you install the Clusterware
Installing the Oracle Clusterware is an error-prone process, and in most cases, the errors come from unmet prerequisites, Fortunately, the CVU (Cluster Verification Utility) helps diagnose any problem in the initial setup you’ve performed. The best way to use it is probably to download the latest version and to validate the prerequisites according to the release you want to install. Once you’ve downloaded and unzipped the latest release from OTN, you can for example check if the prerequisites are met before you install Clusterware, with a command like the one below:
$ su - oracle
$ mkdir cvu
$ cd cvu
$ # Change the URL accordingly to the CVU latest
$ # release and your platform
$ wget https://download.oracle.com/otndocs/products/clustering/cvu/cvu_linux_64_112007.zip
$ unzip cvu_*.zip
$ cd bin
$ ./cluvfy stage -pre crsinst \
-n node1,node2,node3,node4 \
-r 10gR2 -verbose
Using the latest CVU will reduce the number of errors, and the checks are more accurate with the latest releases. However, you can also use RDA on a per-node basis to check the Oracle prerequisites. In order to do that, use the HCVE (Health Check/Validation Engine) tool. Below is an example of this use of RDA HCVE:
$ su - oracle
$ mkdir rda-4.11
$ cd rda-4.11
$ # Change the distribution accordingly to the latest
$ # RDA release and platform. Use your Metalink Credentials
$ ftp updates.oracle.com
ftp> cd 6854532
ftp> ls
ftp> get p6854532_4110_Linux-x86.zip
ftp> bye
$ unzip 6854532*.zip
$ cd rda
$ ./rda.pl -T hcveProcessing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) PreInstall (Linux-x86)
2. Oracle Database 10g R1 (10.1.0) PreInstall (Linux AMD64)
3. Oracle Database 10g R1 (10.1.0) PreInstall (IA-64 Linux)
4. Oracle Database 10g R2 (10.2.0) PreInstall (Linux AMD64)
5. Oracle Database 10g R2 (10.2.0) PreInstall (IA-64 Linux)
6. Oracle Database 10g R2 (10.2.0) PreInstall (Linux-x86)
7. Oracle Database 11g R1 (11.1.0) PreInstall (Linux AMD64)
8. Oracle Database 11g R1 (11.1.0) PreInstall (Linux-x86)
9. Oracle Application Server 10g (9.0.4) PreInstall (Linux)
10. Oracle Application Server 10g R2 (10.1.2) PreInstall (Linux)
11. Oracle Application Server 10g R3 (10.1.3) PreInstall (Linux AMD64)
12. Oracle Application Server 10g R3 (10.1.3) PreInstall (IA-64 Linux)
13. Oracle Application Server 10g R3 (10.1.3) PreInstall (Linux-x86)
14. Oracle Portal PreInstall (Generic)
Available Post-Installation Rule Sets:
15. Oracle Portal PostInstall (generic)
16. RAC 10G DB and OS Best Practices (Linux)
17. Data Guard PostInstall (Generic)
Enter the HCVE rule set number
Hit 'Return' to accept the default (1)
> 4
Enter value for < Planned ORACLE_HOME location or if set >
Hit 'Return' to accept the default ($ORACLE_HOME)
>Test "Oracle Database 10g R2 (10.2.0) PreInstall (Linux AMD64)" executed at Sat Mar 15 15:52:17 2008
Test Results
~~~~~~~~~~~~ID NAME RESULT VALUE
===== ==================== ====== ========================================
10 OS Certified? FAILED Not certified [Red Hat version] 20 User in /Want to talk with an expert? Schedule a call with our team to get the conversation started.
1 Comment. Leave new
A more comprehensive example of using the -T diff will be most helpful. Can’t find any example of a -T diff run either from Google or Oracle Support.
BTW, the brightness of the font are so “foggy”, can’t barely see it. But otherwise this is a good example considering you can’t find such good example in Oracle Support. Even Chris Warticki’s Blog does not contain an example of a -T diff run.