RDA（一）----- 介绍

RDA：Remote Diagnostic Agent，是oracle原厂人员经常用来收集、分析数据库的工具，运行该工具不会改变系统的任何参数，RDA收集的相关数据非常全面，可以简化手工收集数据库数据的工作，很多时候在MOS上面开SR也会要求提供RDA采集的数据，RDA 是用Perl 脚本编写，目前最新的RDA版本为4.30，需要的话可以在MOS上下载，关联文章如下：

Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1]

Remote Diagnostic Agent (RDA) is a command-line diagnostic tool that is executed by an engine written in the Perl programming language. RDA provides a unified package of support diagnostics tools and preventive solutions. The data captured provides Oracle Support with a comprehensive picture of the customer's environment which aids in problem diagnosis.

Oracle Support encourages the use of RDA because it greatly reduces service request resolution time by minimizing the number of requests from Oracle Support for more information. RDA is designed to be as unobtrusive as possible; it does not modify systems in any way. It collects useful data for Oracle Support only and a security filter is provided if required.

This guide provides users with an overview of RDA, the download instructions, and general steps about how to execute RDA within a UNIX, Windows, and Mac OS X environment.

1、支持的平台：

• 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)

2、没有获得支持的平台：

IBM Z/OS (OS/390)

3、支持的产品包括：

RDA collects information that is useful for diagnosing issues related to the following Supported Oracle products

1. OLAP Products (Express Server, Financial Analyzer, and Demand Planning Server)
2. 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)
3. Oracle Billing and Revenue Management products
4. Oracle BPEL Process Manager
5. Oracle Collaboration Suite (Email Server,Calendar,Discussions,Content Services,Workspaces,WebClient,and Wireless)
6. Oracle Data Integrator
7. Oracle Developer (Forms and Reports)
8. Oracle Ebusiness Suite 11i and 12
9. Oracle Enterprise Content
10. Oracle Enterprise Single Sign-on
11. Oracle Enterprise performance management (Hyperion) products
12. Oracle Guardian
13. Oracle Identity Management products
14. Oracle JDBC/PRO *C/ODBC and other development client related information
15. Oracle Management Server and Intelligent Agent (Grid Server, Agent Server, DB Control)
16. Oracle Networking products
17. Oracle RAC Cluster (Single/Multiple Nodes, Automatic Storage Management, Oracle Cluster File System, Data Guard)
18. Oracle RDBMS Server (Standard and Enterprise Editions)
19. Oracle Retail (Retek)
20. Oracle SQL*Plus/iSQL*Plus
21. Oracle TimesTen In-Memory Database
22. Oracle Universal Archive (11g)
23. PeopleSoft
24. Siebel

4、Why use RDA?

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

• Acquired company product issues
• Developer issues
• Installation/configuration issues
• ORA-600, ORA-7445, ORA-3113, and ORA-4031 errors
• Oracle Database issues
• Oracle Application Server/Fusion Middleware issues
• Oracle Collaboration products (Oracle Collaboration Suite and Oracle Beehive) issues
• Oracle Application issues
• Other corrective issues
• Performance issues
• Upgrade, migration, and linking issues

5、Oracle Configuration Manager

The Oracle Configuration Manager (OCM) is a data collector that collects key Oracle and system statistics of the system that it is running on. As a key component of Oracle Configuration Manager, the OCM collector (scheduler) optimizes the customer benefits of OCM by automating the configuration collections. OCM simplifies your ability to automate your configuration and diagnostics uploads to Oracle. Oracle Configuration Manager bundle provides the following benefits:

• HealthCheck recommendations based on Support best practices when using configuration auto-collection
• Improves Oracle's understanding of your business needs
• Personalized access to best practices and the Oracle Knowledge base
• Pro-active configuration-specific notification of Security and General Alerts
• Project cataloging of key milestones and contacts associated with your configurations
• Secure, automated configuration collection
• Simplified Service Request logging, tracking and reporting

6、 安装说明

Instructions for UNIX/ZLinux Type Operating Systems

1. Choose or create a directory or area on your UNIX server. Make sure you have sufficient space for the 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. Do notuse a directory that contains an older version of RDA unless you have deleted the previous version of RDA first. If necessary, you can reuse prior setup files.

   Note: The rda.zip creates a directory named "rda" containing all the required files when you extract it. Do not extract the contents of the RDA archive on a Windows client first or you will have to remove the ^M characters from the end of each line in all of the shell scripts in order for them to run.

2. FTP the downloaded rda.zip file to your UNIX server in binary mode and place it in the directory chosen in step 1.
3. Extract the .zip archive contents into a new directory, preserving the directory structure of the archive. Do not extract into a directory that contains an older RDA version. For example:

   unzip rda.zip

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

   chmod +x <rda>

5. You can verify the RDA installation using the following command:

   ./<rda> -cv

Instructions for Microsoft Windows Based Operating Systems

1. Create a new directory or area on your Windows server. Make sure you have sufficient space for RDA output (~150MB). It does not matter where you create this directory or what it is named, but it should have access to the Oracle software installation. Do notuse a directory that contains an older version of RDA unless you have deleted the previous version of RDA first.

   Note: The rda.zip file creates a directory named " rda" containing all the required files when you extract it.

2. Transfer the downloaded rda.zip file to your Windows server and place it in the directory chosen in step 1. If transferring the zip file from one system to another using FTP, remember to transfer it in binary mode.
3. Extract the .zip archive contents into a new directory, preserving the directory structure of the archive. Do not extract into a directory that contains an older RDA version. For example:

   unzip rda.zip

4. You can verify the RDA installation using the following command:

   <rda> -cv

Instructions for HP OpenVMS Based Operating Systems

Due to the special nature of HP OpenVMS environment, Oracle created a separate document. 

Instructions for UNIX type operating systems (including ZLinux):

1. 1. Before you begin: Log on as the UNIX user that owns the Oracle installation. On some operating systems, this user will not have the necessary permissions to run all of the commands and utilities called by RDA(e.g. sar, top, vmstat, etc). If you are running RDA to assist in resolving a service request, the analyst will most likely need the information pertaining to the Oracle owner. The exception to this rule iswhen RDA is used to assist in a performance related issue. In this case, Oracle support recommends that you run RDA as the UNIX user who owns the Oracle software.

      Note: If you use su to connect to root or a privileged user, do not use "su -" as the minus resets the environment.

   2. Select the RDA command line script that you will be using. Choose one of the following:

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

      rda.pl - Use this command if Perl is available.
      
      
      Use the following command to verify that Perl is installed and available in the path:

      perl -V

      Inspect the command output, checking that '.' (i.e. tells perl to look for libaries in current directory) is present in @INC section. Notice the last entry "." in the example below:

@INC: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .

 

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

   ./<rda> -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. 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, apachelogs, networking logs, etc) of the Oracle installation the final size of your RDA collection may reach over 1000 MB in size.
3. 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:

   ./<rda> [-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, ./<rda> -fv. For additional information read the RDA FAQ.

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

    

5. 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:

   <output_directory>/<report_group>__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

    

6. The final output is also packaged in an archive located in the <output_directory> 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.)

   Note: The final output directory may not contain an archive file (.zip, .tar, .tar.gz, or .tar.Z). If the archive is missing, please archive all of the files in the <output_directory> manually and send them to Oracle Support. You can use a packaging/archive utility program such as http://www.info-zip.org/Zip.html to perform this task.

For more information or clarification please review the demonstration viewlets located in the Training document or please read the RDA FAQ. If you still have problems please follow Troubleshooting Steps.

Instructions for Microsoft Windows Based Operating Systems

1. Before you begin: Log on as the WINDOWS user that owns the Oracle installation. On some operating systems, this user will not have the necessary permissions to run all of the commands and utilities called by RDA (e.g. WinMsd utility, MSInfo32 on Windows 2000, Windows 2003) If you are running RDA to assist in resolving a service request, the analyst will most likely need the information pertaining to the Oracle owner. The exception to this rule is when RDA is used to assist in a performance related issue. In this case, Oracle support recommends that you run RDA as the user who owns the Oracle software.
2. Choose one RDA  command line scriptthat you will be using, either:

   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

   In the command output, verify that '.' (i.e. the current directory) is present in @INC section.

   The RDA command rda.cmd or rda.pl you choose is represented as <rda> in the rest of this procedure.

3. The data collection requires an initial setup to determine which information should be collected. Enter the following command from the  Windows Command or DOS prompt to initiate the set up:  REMEMBER: <rda> means use either  rda.cmd or  rda.pl.

   <rda> -S

   After setup completes, you can review the setup file setup.cfg by opening it a text editor like wordpad.

   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.

4. Make sure you have ample space for RDA output (approximately 150 MB) in the output location you have chosen. 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.
5. 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:

   <rda> [-v]

   The -v option is optional. It allows you to view the collection progression. Additionally, if you want to rerun RDA collection again, you can use the "-fv" option like <rda> -fv . For additional information, read the RDA FAQ.

6. A more targeted way of executing RDA and a way to limit the number of setup questions asked is the use of Diagnostic profiles (<rda> -p), see RDA Profiles for list of various profiles. e.g: <rda> -p DB10g
7. 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:

   <output_directory>/RDA__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 1227943.1

    

8. The final output is also packaged in an archive located in the <output_directory> chosen during RDA setup -- the packaged output file will have a  .zip, .tar, .tar.gz, or .tar.Z extension. If the data collectionwas generated to assist in resolving a Service Request, send the report archive (for example, RDA.RDA_db_autoxyz.zip) to Oracle Support by uploading the file via My Oracle Support. If FTP'ing the file, please besure to FTP in BINARY format. Do not rename the file, as the file name helps Oracle Support quickly identify that RDA output is attached to the service request.

   The final output directory may not contain an archive file (.zip, .tar, .tar.gz, or .tar.Z). If the archive is missing, please archive all the files in the <output_directory> manually and send them to Oracle Support. You can use a packaging/archive utility program such as http://www.info-zip.org/Zip.html

9. When you send/upload an RDA report in a compressed file (such as .zip, .tar, .tar.gz, or .tar.Z), please do so in a separate file and start is named with 'RDA'; this ensures our internal tools and users can find and analyze it correctly. 
   
   
   When sending RDA output to Oracle Support via a My Oracle Support Service Request, we highly recommend that you attached the output file as a single file.  Do not bundle with other files such as trace or log filesinto a single or common archive file (.tar, .zip, .jar, etc.)

For more information or clarification please review the demonstration viewlets located in the Training document or read the RDA FAQ. If you still have problems please follow Troubleshooting Steps.