Oracle Diagnostics Tool-rda use

RDA is the short name of the remote diagnostic Agent, the tool Oracle uses to collect and analyze databases, and running the tool does not change any of the parameters of the system, and RDA collects data that is comprehensive and simplifies our day-to-day monitoring and analysis of databases, Oracle Support also advises us to provide RDA-collected data in response to related issues, which can provide a powerful guarantee for quick resolution of problems.

One, supported operating systems

IBM AIX

Intel Linux (RedHat and SuSE)

HP-UX (10.* and 11.*)

HP Tru64

Sequent dynix/ptx

Sun Solaris (2.6-2.10)

Windows XP Professional

Windows Workstation and Server

Windows 2003 Server

Second, supported Oracle products

Oracle RDBMS Server (Standard and Enterprise Editions)

Oracle RAC Cluster (single Node Collection)

Oracle Application Server (IAS 1.0.2.x/9.0.x/10.1.2.x, HTTP server)

Oracle Management Server and intelligent agent (Grid server, Agent Server, DB control)

OLAP Products (Express server, Financial Analyzer, and Demand Planning Server)

Oracle Developer (Forms and Reports)

Oracle Collaboration Suites (Email Server and Internet Directory)

Oracle Networking Products

Three, mainly for the diagnosis of the database of the following aspects of the problem

Performance, installation, configuration, upgrades, porting, and internal error issues.

Iv. installation of RDA (version 4.12-080530)

Tools Download: Metalink (need Metalink account)

Installation instructions for the UNIX operating system:

1, the tool download after the window operating system do not do decompression, the script file format will be destroyed.

2, FTP upload is the use of binary mode.

3. Perform decompression command

$ gunzip rda.tar.gz

$ tar xvf Rda.tar

4, the test is normal

$ CD RDA

$./rda.sh-c

V. Use of RDA

In UNIX operating systems, Oracle recommends execution under the database creation user (typically Oracle users), and the first use requires a collection of initial configuration.

To execute a command:

$./rda.sh-s

After the command is executed, a wizard interface allows you to complete the initial configuration based on the actual installed product of the current database. Configuration files Setup.cfg, Setup.bak are generated in the RDA directory after the configuration is completed, and can be modified directly if the configuration parameters need to be readjusted.

The configuration process is typically a default value, or if you are prompted to enter parameters, special places are as follows:

-------------------------------------------------------------------------------

Enter an Oracle User ID (userid only) to view Dba_ and v$ tables

If RDA would be run under the Oracle software owner ' s ID, enter a '/' here,

and select Y at the SYSDBA prompt to avoid being prompted for the database

Password at runtime.

Hit ' return ' to accept the default (System):/

Is '/' a SYSDBA user (would connect as SYSDBA) (y/n)?

Hit ' return ' to accept the default (N):

> Y 1 2 Next > Full-text reading tips: Try "←→" button, turn the page more convenient Oh!