Sunday, January 4, 2009

About RDA

REMOTE DIAGONISTIC AGENT


What is RDA ?
Remote Diagnostic Agent is a set of Unix shell scripts, written by Oracle, that gather detailed information about an Oracle environment. The scripts are focused to collect information that will aid in problem diagnosis.

Why use RDA ?

Oracle strongly encourages the use Remote Diagnostic Agent(RDA) diagnostics collections because it provides a comprehenshive picture of the customer’s environment. Providing RDA diagnostic output,especially when submitting a Service Request online, can minimize the requirement the follow up questions that may delay problem resolution. RDA collections are essential for the following types of tars:

• Performance issue
• Installation/configuration issues
• ORA-600,ORA-7445, and ORA-3113 errors
• Upgrade,migration, and linking issues
• Database and Development API issues
• Froms and reports isseues
• Development/Discoverer Server issues
• Oracle Application Server / Fusion Middleware issues
• Other corrective issues

Download

Download RDA from metalink normally start with p.zip
As per the instruction save with rda.zip Copy the zip file to the location where the database is installed and make sure you have sufficient permission.

The patch number we have to download is
p7114647_92080_LINUX-x86-64.zip





Installation Instructions

i. Choose or create a directory or area that is used exclusively for RDA on your UNIX server. Make sure you have sufficient apace for 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.

ii. Copy the zip file to created directory.

iii. Unzip the file , a folder with name 'rda' will create where you will find README_Unix.txt where instructions are give to setup and rerun the rda to get the system and database configuration.

iv. If using .pl script make sure Perl is installed into the system to check Perl is available or not

$Perl –V

The output will show the installation path and related files
If Perl is not available you can use .sh script.

v. Log into the database user and ensure the rda folder Permissions (both ownership and executing permission)
And also ensure that database is up and running.

vi. Go into the unzipped folder and run the script
$./rda.sh –S

Incase of .pl script
$perl -S rda.pl

It will ask several questions regarding the analysis required for both database and operating system. Accordingly insert values into it.

vii. Now run the following command to compile the info and the info will be recorded in the output directory with .html format

$./rda.sh –v

After this is executed all the information are collected and stored in the output directory.

No comments:

Post a Comment