Remote Diagnostic Agent (RDA) 是一個工程師用Perl語言編寫的命令列診斷工具，RDA提供統一的診斷工具支援包和預防的解決方法。提供給Oracle支援收集的客戶環境全面的資料資訊能夠幫助問題的診斷。

Oracle支援鼓勵使用RDA，因為它能對於更多資訊最小化請求數量而大大減少服務請求解決的時間。RDA不會對系統做任何的修改，它只為Oracle支援收集有用的資料，如果需要可以提供經安全過濾的資料。

一.支援的平臺。

Apple Mac OS X/Darwin

HP OpenVMS Alpha 7.3-2 and above

HP OpenVMS Itanium

HP Tru64 UNIX

HP-UX Itanium

HP-UX PA-RISC (32 and 64 bit)

IBM AIX on POWER Systems(32 and 64 bit)

IBM Dynix/Ptx

IBM Linux on POWER

IBM zSeries Based Linux

Linux Itanium

Linux x86 (32 and 64 bit)

Microsoft Windows 7

Microsoft Windows 2000 Workstation and Server

Microsoft Windows 2003 Server

Microsoft Windows 2008

Microsoft Windows Vista

Microsoft Windows XP Professional

Sun Solaris Intel

Sun Solaris SPARC (32 and 64 bit)

目前不支援的平臺：

IBM Z/OS (OS/390)

二.支援的Oracle產品。

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

Oracle Application Server (iAS 1.0.2.x/9.0.x/10.1.2.x/10.1.3.x,10.1.4.x,WebLogic Server (WLS) Release 9.x and 10.x,11g (WLS), HTTP Server,WebCache,J2EE/OC4J)

Oracle Billing and Revenue Management products

Oracle BPEL Process Manager

Oracle Collaboration Suite (Email Server,Calendar,Discussions,Content Services,Workspaces,WebClient,and Wireless)

Oracle Data Integrator

Oracle Developer (Forms and Reports)

Oracle Ebusiness Suite 11i and 12

Oracle Enterprise Content

Oracle Enterprise Single Sign-on

Oracle Enterprise performance management (Hyperion) products

Oracle Guardian

Oracle Identity Management products

Oracle JDBC/PRO *C/ODBC and other development client related information

Oracle Management Server and Intelligent Agent (Grid Server, Agent Server, DB Control)

Oracle Networking products

Oracle RAC Cluster (Single/Multiple Nodes, Automatic Storage Management, Oracle Cluster File System, Data Guard)

Oracle RDBMS Server (Standard and Enterprise Editions)

Oracle Retail (Retek)

Oracle SQL*Plus/iSQL*Plus

Oracle TimesTen In-Memory Database

Oracle Universal Archive (11g)

PeopleSoft

Siebel

三.安裝要求。

1).單獨目錄。

2).空間大於150M。

3).如果有老版本的RDA，需要刪除所有原有的老版本檔案。

4).RDA是透過Perl語言開發的工具，可以使用系統的Perl環境，也可以使用RDA自帶的Perl環境。

四.安裝操作。

1).unzip rda.zip

2).Make sure the RDA command (rda.sh and rda.pl) is executable. To verify, enter the following command:

chmod +x

3).You can verify the RDA installation using the following command:

./ -cv

下面是驗證RDA安裝的例子：

[oracle@redhat5 rda]$ ./rda.pl -cv

Loading the file list ...

Checking the directory '.' ...

Checking the directory 'IRDA' ...

Checking the directory 'IRDA/CV0100' ...

Checking the directory 'RDA' ...

Checking the directory 'RDA/Archive' ...

Checking the directory 'RDA/Driver' ...

Checking the directory 'RDA/Handle' ...

Checking the directory 'RDA/Library' ...

Checking the directory 'RDA/Local' ...

Checking the directory 'RDA/Object' ...

Checking the directory 'RDA/Operator' ...

Checking the directory 'RDA/Value' ...

Checking the directory 'RDA/Web' ...

Checking the directory 'dfw/cv0100' ...

Checking the directory 'engine' ...

Checking the directory 'hcve' ...

Checking the directory 'modules' ...

五.RDA工具介紹。

1).rda.sh - Use this command if Perl is not available.

2).rda.pl - Use this command if Perl is available.

3).Use the following command to verify that Perl is installed and available in the path:

perl -V

下面是執行perl -V命令的例子：
......

@INC:

/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi

/usr/lib/perl5/site_perl/5.8.8

/usr/lib/perl5/site_perl

/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi

/usr/lib/perl5/vendor_perl/5.8.8

/usr/lib/perl5/vendor_perl

/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi

/usr/lib/perl5/5.8.8

.

返回類似上面的結果表示當前系統使用者有Perl環境。

4).如果是Windows環境，那麼rda工具有如下的區別：

rda.cmd Use this command if Perl is not available.

rda.pl Use this command if Perl is available in the path. To verify if Perl is available, enter the following command:

同樣可以透過執行perl -V驗證Perl語言環境。

六.RDA的使用。

1).初始化RDA工具：

The data collection requires an initial setup to determine which information should be collected. Enter the following command to initiate the set up:

./ -S

根據提示完成配置工作。

Including the dot ensures that RDA is executed from the local directory.

After setup completes, you can review the setup file setup.cfg by opening it a text editor such as vi.

You can also choose to collect only specific data. For more details, view the command usage help by specifying the -h option, or complete manual page with the -M option.

2).生成RDA報告：

Make sure you have ample space for RDA output (approximately 150 MB) in the output location you have chosen in STEP 4. Sometimes, depending on the size of your data files (alert.log, *.trc, install*.log, apache logs, networking logs, etc) of the Oracle installation the final size of your RDA collection may reach over 1000 MB in size.

At this point, you can collect diagnostic information. sqlplus should connect to the database with the userid that you specified during the setup. Start the data collection using the following command:

./ [-v]

The -v option is optional; it allows you to view the collection progression. Additionally, if you want to re-run the RDA collection, you can use the "-fv" option, for example, ./ -fv. For additional information read the RDA FAQ.

A more targeted way of executing RDA and a way to limit the number of setup questions asked is the use of Diagnostic profiles ( -p ), see RDA Profiles for list of various profiles or run -L profiles. e.g:. ./ -p DB10g

The output is a set of HTML files that are located in the RDA output directory which you specified at setup. You can review the data collected by using a Web Browser to open the following file located in:

/__start.htm

Note: Do not submit any health, payment card or other sensitive production data that requires protections greater than those specified in the Oracle GCS Security Practices (http://www.oracle.com/us/support/library/customer-support-security-practices-069170.pdf). Information on how to remove data from your submission is available at note 1227943.1

The final output is also packaged in an archive located in the chosen during RDA setup -- the packaged output file will have a .zip, .tar, .tar.gz, or .tar.Z extension. If the data collection was generated to assist in resolving a Service Request, send the report archive (for example, RDA.RDA_db_autoxyz.tar) to Oracle Support by uploading the file via My Oracle Support. If FTP'ing the file, please be sure to FTP in BINARY format. Please do notrename the file, as the file name helps Oracle Support quickly identify that RDA output is attached to the service request or bundle with other files such as trace or log files into a single or common archive file (.tar, .zip, .jar, etc.)

參考文章：

RDA文件索引 (文件 ID 1540377.1)

Remote Diagnostic Agent (RDA) 4 - Getting Started (文件 ID 314422.1)

--end--

利用Oracle RDA快速收集Oracle產品分析資料

相關文章