|
Remote Diagnostic Agent (RDA)
On Monday
morning I received a mail from my client regarding installation of oracle 10g on
RHEL ES 4 platform. I started the installation and ended up with many errors.
While struggling to get required RPMS and going through metalink documents I
found usage of RDA.
I used to
hear about RDA even when working with Oracle Corporation but never thought how
useful RDA is.
Remote
Diagnostic Agent (RDA) is a set of command line diagnostic scripts. RDA is used
to gather detailed information about an Oracle environment.
Oracle
Support encourages the use of RDA because it provides a comprehensive picture of
the customer's environment.
Some
times in the platform like RHEL to find required RPMs and compatibility RDA
looks very great. Eben you might run custom xml scrips with this RDA.
All
installation instructions are given in metalink note
314422.1.
The Tools can be run in SHELL or PEARL environment.
Example
Ater
installation of RDA /home/oracle/rda
To start
data collection
[oracle@rda]$
./rda.sh
-------------------------------------------------------------------------------
RDA Data
Collection Started 06-Feb-2008 11:50:16 AM
-------------------------------------------------------------------------------
Processing Initialization module ...
Processing CFG module ...
Processing Sampling module ...
Processing OCM module ...
Processing OS module ...
Processing PROF module ...
Processing PERF module ...
Processing RDSP module ...
Processing LOAD module ...
This will
generate many files including a zip file usually required by Oracle Support.
RDA
includes health Check Validation Engine
To check
HCVE
Run
Processing 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 Application Server 10g (9.0.4) PreInstall (Linux)
8.
Oracle Application Server 10g R2 (10.1.2) PreInstall (Linux)
9.
Oracle Application Server 10g R3 (10.1.3) PreInstall (Linux AMD64)
10.
Oracle Application Server 10g R3 (10.1.3) PreInstall (IA-64 Linux)
11.
Oracle Application Server 10g R3 (10.1.3) PreInstall (Linux-x86)
12.
Oracle Portal PreInstall (Generic)
Available
Post-Installation Rule Sets:
13.
Oracle Portal PostInstall (generic)
14. RAC
10G DB and OS Best Practices (Linux)
15.
Data Guard PostInstall (Generic)
Enter the
HCVE rule set number
Hit
'Return' to accept the default (1)
>
Select
your choice and press enter
Test
Results
~~~~~~~~~~~~
ID
NAME RESULT VALUE
=====
==================== ====== ========================================
10 OS
Certified? PASSED Adequate
20
User in /etc/passwd? PASSED userOK
30
Group in /etc/group? PASSED GroupOK
40
Input ORACLE_HOME RECORD $ORACLE_HOME
50
ORACLE_HOME Valid? PASSED OHexists
60 O_H
Permissions OK? PASSED CorrectPerms
70
Umask Set to 022? PASSED UmaskOK
80
LDLIBRARYPATH Unset? FAILED IsSet
100
Other O_Hs in PATH? PASSED NoneFound
110
oraInventory Permiss PASSED oraInventoryOK
120 /tmp
Adequate? PASSED TempSpaceOK
130
Swap (in MB) RECORD 4605
140 RAM
(in MB) PASSED 2007
150
Swap OK? PASSED SwapOK
160
Disk Space OK? PASSED DiskSpaceOK
170
Kernel Parameters OK FAILED SHMMAXTooSmall SEMOPMTooSmall
180 Got
ld,nm,ar,make? PASSED ld_nm_ar_make_found
190
ulimits OK? FAILED StackTooSmall MaxLockMemTooSmall
200 EL4
RPMs OK? PASSED NotEnterprise
203
RHEL21 RPMs OK? PASSED NotRHEL21
204
RHEL3 RPMs OK? PASSED NotRHEL3
205
RHEL4 RPMs OK? PASSED RHEL4rpmsOK
208
SUSE SLES8 RPMs OK? PASSED NotSuSE
209
SUSE SLES9 RPMs OK? PASSED NotSuSE
212
Patch 3006854 Instal PASSED NotRequired
213
LD_ASSUME_KERNEL Set PASSED NotRHEL3
214
ip_local_port_range FAILED LowTooHigh HighTooLow
220
Tainted Kernel? PASSED NotVerifiable
230
Other OUI Up? PASSED NoOtherOUI
This will
give you a fair idea of environment before installation.
And
always RDA will have a result file, some time Oracle Support may ask this file.
Usually this will be generated in output folder.
So try to
learn RDA as quickly as possible. This tool helps in many ways.
Purpose
of this document was to just highlight what RDA is and how best to use it. Refer
Metalink for downloadable, getting started and installation instructions.
| 
