ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 利用Oracle RDA快速收集Oracle产品分析数据

利用Oracle RDA快速收集Oracle产品分析数据

原创 Linux操作系统 作者:尛样儿 时间:2013-07-20 23:39:23 0 删除 编辑

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23135684/viewspace-766784/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle数据库管理员,Oracle数据库系统构架员;2012年7月出版《构建最高可用Oracle数据库系统:Oracle 11gR2 RAC管理、维护与性能优化》一书;Oracle 10g OCM。

注册时间:2010-01-05

  • 博文量
    483
  • 访问量
    5354615