oracle in and output,RDA使用-metalink notes[ID 314422.1]

Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1]Modified 29-NOV-2011     Type DIAGNOSTIC TOOLS     Status PUBLISHED

Applies to:

OSS Support Tools - Version: 4.25 and later   [Release: and later ]

Information in this document applies to any platform.

RDA 4 Getting Started

In This Document

RDA 4.x Overview

Note: Please review installation and execution instructions below. If you experience difficulties or receive errors please follow theRDA Troubleshooting GuideandRDA FAQfor instructions on reporting problems.

Overview

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 asecurity filteris 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.

What's New in this RDA Release

See theRDA 4 Release Notesfor information about new features. The next release in RDA 4.x series is scheduled for release in Mid-September.

Platforms Supported

At this time, RDA has been successfully tested to run on the following Supported platforms:

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)

Following Platforms are NOT Supported:

IBM Z/OS (OS/390)

You can run RDA also on other platforms that support Perl 5.005 and later. However, Oracle Support recommends testing on a non-production server first because the performance is unpredictable. For example, you will receive errors when RDA attempts to run utilities and commands that are not supported on these platforms.

Products Supported

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

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 Universal Archive (11g)

PeopleSoft

Siebel

Additional new Oracle products will be supported in future releases. We are constantly enhancing and refining RDA, so make sure you have the latest version! For more detailed information see the Knowledge330760.1.

Versions Supported

RDA supports most supported versions of the Oracle products listed inProducts Supported. In most cases, it runs on desupported versions as well, although the collected information may not be as extensive.

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 when submitting 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

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

For troubleshooting information or to learn more about Oracle Configuration Manager see the following Oracle Knowledge250434.1.

For your benefit, Oracle created anRDA/OCM bundle. This bundle contains both RDA and OCM software and it allows customers to install OCM as part of the RDA data collection process.

Download

click the zip file for your platform

save it locally as rda.zip

Each file contains all of the required files so choose only one to download.

Note:If your platform is certified for OCM, the RDA zip file below is conveniently bundled with OCM.

RDA bundle (Released MON, D YYYY)

Platform

Download File

HP-UX PA-RISC (32-bit)

HP-UX PA-RISC (64-bit)

IBM AIX on POWER Systems (32-bit)

IBM AIX on POWER Systems (64-bit)

IBM Linux on POWER

IBM zSeries Based Linux

Linux x86 (32-bit)

Linux x86 (64-bit)

Microsoft Windows (32-bit)

Microsoft Windows (64-bit)

Sun Solaris Intel (32-bit)

Sun Solaris Intel (64-bit)

Sun Solaris SPARC (32-bit)

Sun Solaris SPARC (64-bit)

Note:RDA 4 is written in Perl and is a command-line script. Besides Perl and a few basic Perl libraries it is not necessary to install extra software. If for some reason Perl 5.005 or above is not available or is inaccessible on your environment, then ais available for download on major platforms.

For additional information please read theRDA FAQ- Knowledge Article330363.1.

Note: In this document represents the different RDA OS command to execute RDA. Therefore substitute rda.sh, rda.pl, or perl rda.pl on UNIX and rda.cmd on Windows in place of .

Installation Instructions

Instructions for UNIX/ZLinux Type Operating Systems

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 not use 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.

FTP thedownloadedrda.zipfile to your UNIX server in binary mode and place it in the directory chosen in step 1.

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

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

chmod +x

You can verify the RDA installation using the following command:

./ -cv      #检查

Instructions for Microsoft Windows Based Operating Systems

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 not use 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.

Transfer thedownloadedrda.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.

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

You can verify the RDA installation using the following command:

-cv

Instructions for HP OpenVMS Based Operating Systems

Due to the special nature of HP OpenVMS environment, Oracle created a separate document. See the RDA 4 - OpenVMS Users Guide: Knowledge Article171748.1.

Running RDA

Note: It is impossible to tell how long RDA will take to execute, as it depends on many variables, such as system activity, the options chosen, network settings, and so on. On an average system, RDA takes just a few minutes to run. Most scripts are designed to stop if for some reason they cannot complete within 30 seconds, (for example, the lsnrctl status command will stop if the listener is not responding.) It is not unusual for RDA to take 15 minutes or more on a busy server, especially if there are many Oracle listener processes active.

Instructions for UNIX type operating systems (including ZLinux):

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 is when 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.

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

.

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.cfgby 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.

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 theRDA 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 ), seeRDA Profilesfor 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 athttps://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=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.Zextension. 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 not rename 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 manually and send them to Oracle Support. You can use a packaging/archive utility program such ashttp://www.info-zip.org/Zip.htmlto perform this task.

For more information or clarification please review the demonstration viewlets located in theTrainingdocument or please read theRDA FAQ. If you still have problems please followTroubleshooting Steps.

Instructions for Microsoft Windows Based Operating Systems

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.

Choose one RDA command line script that 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 orrda.pl you choose is represented as in the rest of this procedure.

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: means use either rda.cmd orrda.pl.

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

Make sure you have ample space for RDA output (approximately 150 MB) in theoutput locationyou 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.

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 rerun RDA collection again, you can use the "-fv" option like -fv. For additional information, read theRDA 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), seeRDA Profilesfor list of various 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:

/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 athttps://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=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.Zextension. If the data collection was 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 be sure 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 manually and send them to Oracle Support. You can use a packaging/archive utility program such ashttp://www.info-zip.org/Zip.html

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 files into a single or common archive file (.tar, .zip, .jar, etc.)

For more information or clarification please review the demonstration viewlets located in theTrainingdocument or read theRDA FAQ. If you still have problems please followTroubleshooting Steps.

Instructions for Oracle RAC Cluster or Multi-Node Environment

Due to the special nature of Oracle RAC Cluster environment a separate document was created. Please refer to RDA 4 - RAC Cluster/Multi-Node Users Guide -359395.1

Instructions for HP OpenVMS Based Operating Systems:

Due to the special nature of HP OpenVMS environment a separate document was created. Please refer to RDA 4 - OpenVMS Users Guide - Knowledge171748.1

Upgrading RDA

Use the following procedure to manually upgrade the RDA:

Delete the rda directory and all it's contents. If you want to use the same setup.cfg file again, move it to another location first. Also, move any output files you wish to save.

Download the new version of RDA from thisDownload RDA.

Extract the files in the directory you want to install RDA. It will recreate the rda directory for you.

Remember that the directory structure in the archive is important; don't move any RDA files.

Automated update of RDA

As of March 28, 2011, RDA is automatically upgraded in the following scenario:

OCM is installed and configured in "Connect" mode. OCM auto-update will now

upgrade RDA as part of its normal deployment procedure.

For finer control of the RDA upgrade see

Special Notes On Userids And Passwords

As a means of providing higher security when using RDA, passwords are no longer stored in plain text in the setup.txt file. As result, RDA prompts for the required passwords when collecting the data.

If the Perl implementation installed on your operating system supports it, RDA will suppress the character echo during password requests. When the character echo is suppressed, the password is requested twice for verification. If both entered passwords do not match after three attempts, the request is cancelled.

RDA can perform OS authentication, which eliminates having to enter a password for database information gathering. It also accepts "/" as a username to avoid entering a password when RDA is gathering database information.

For executing RDA at regularly scheduled intervals via cron, passwords can be encoded inside the setup file. For instance, to encode the system password, use the following command:

-A system

The password will be requested interactively.

Special Note on the Output Directory

To limit security vulnerabilities, the permissions of the RDA output directory should be set as restrictive as possible. The output directory could contain sensitive configuration information and, when no other mechanism is available, temporary data collection files.

Viewing RDA Report Output Files

RDA output is not encrypted and can be viewed by anyone. You can view the RDA report files using almost any web browser by opening the //RDA__start.htm.

We recommend usingMozilla1.x ( or Higher), Netscape 4.x (or higher), or Internet Explorer 4.x (or higher).

Special Note on Security Filters

The following table is a snapshot of the 'System Settings' section of the end report to demonstrate exactly what Filtering does. The result below is dependent on the system configuration.

Machine and Version

SunOS 5.6 Generic 105181-29 sun4u

Fully qualified host name

Platform

32 - bit Sun O/S Version 2.6

Logged in as

Last run as

uid=52279 ()gid=101(dba) groups=101(dba)

Executed as Oracle home owner?

Yes

Sensitive information removed?

Yes

Output file prefix

RDA

Output file directory

/emea/oracle/ /home/rda2/security/output

RDA install directory

/emea/oracle//home/rda2

The host names (machine names), are substituted by ''. Similarly, user names are substituted by '' instead of 'oracle'. The group of the software owner is 'dba', which is not substituted by the default filter.

Note that the above report was run as the owner of the Oracle home directory, which was different from 'oracle'. This is the reason why we see '' instead of 'oracle'. The group of the Oracle software owner is 'dba', which is not substituted by the default filter.

The RDA filter substitutes sensitive information (such as user names) using something like in the reports. As shown later in this document, you can customize what information RDA filters out and how RDA substitutes this information.

RDA provides you with a default filter, which currently filters out the information in the list below.

Domain names

Group names

Host names

IPv4 and IPv6 addresses

LDAP domain components

Network masks

User names

Using Security Filters

RDA allows you to remove sensitive data from RDA reports. The security profile can be used to turn on filtering and can be combined with other profiles. For example:

-S -p DB10g-Security

This will do the RDA setup for the DB10g profile and turn on filtering through the Security profile. If you want to enable the filtering for an existing setup:

-X Filter enable

When the filter is not yet defined, this command will also generate the default filter configuration, based on the system configuration.

Reporting Problems or Feedback

If you have issues with the Remote Diagnostic Agent (RDA), you can file an Non-Technical SR in My Oracle Support. Subject line "Remote Diagnostic Agent (RDA) Issue"  and complete the SR.

Note: Do not let an RDA issue prevent you from progressing on your technical issue that you are running RDA for. Please inform the engineer that owns your technical issue that you are having trouble with RDA and request that he give you instructions on collecting necessary data manually to resolve the issue. RDA is designed to speed up the resolution time of technical issues and we do not want it to interfere with resolution. However, it is important that we get the RDA issue resolved so that it can be used to help speed up resolution for future technical issues

Legal Notices And Terms Of Use

By downloading and using RDA you agree to the following:Warranties And Disclaimers.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market- leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation. This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.

Related

Products

Internal Applications > Internal Applications > Internal Applications > OSS Support Tools

Keywords

DATA_COLLECT; DIAGNOSTIC; RDA

Errors

ORA-4031; ORA-7445; ORA-3113