oracle RDA 使用说明





 

.RDA 说明

       RDA(RemoteDiagnostic Agent)oracle用来收集、分析数据库的工具,运行该工具不会改变系统的任何参数,RDA收集的相关数据非常全面,可以简化我们日常监控、分析数据库的工作。

       一般Oracle 原厂的人巡检也是使用RDA工具。 不过一般国内的DBA 巡检时很少使用这个工具,一般都是通过AWR 或者自己整几个脚本,跑了再分析一下就ok了。

       MOS 上创建SR(Service Request)时。 Oracle 也会要求客户上传RDA的信息。 通过RDA 可以快速的了解系统的状况。

       RDA 是用Perl 脚本写出来的。 可以通过MOS 下载RDA RDA 是一个客户端,解压缩之后就可以直接使用了。

.RDA 支持的平台与产品

支持的平台:

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

1)       Apple Mac OS X/Darwin

2)       HP OpenVMS Alpha 7.3-2 andabove

3)       HP OpenVMS Itanium

4)       HP Tru64 UNIX

5)       HP-UX Itanium

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

7)       IBM AIX on POWER Systems(32 and64 bit)

8)       IBM Dynix/Ptx

9)       IBM Linux on POWER

10)   IBM zSeries Based Linux

11)   Linux Itanium

12)   Linux x86 (32 and 64 bit)

13)   Microsoft Windows 2000Workstation and Server

14)   Microsoft Windows 2003 Server

15)   Microsoft Windows 2008

16)   Microsoft Windows Vista

17)   Microsoft Windows XPProfessional

18)   Sun Solaris Intel

19)   Sun Solaris SPARC (32 and 64bit)

支持的产品:

RDA collectsinformation that is useful for diagnosing issues related to the followingSupported Oracle products

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

2)       Oracle Application Server (iAS1.0.2.x/9.0.x/10.1.2.x/10.1.3.x,10.1.4.x,WebLogic Server (WLS) Release 9.x and10.x,11g (WLS), HTTP Server,WebCache,J2EE/OC4J)

3)       Oracle Billing and RevenueManagement products

4)       Oracle BPEL Process Manager

5)       Oracle Collaboration Suite(Email Server,Calendar,Discussions,Content Services,Workspaces,WebClient,andWireless)

6)       Oracle Data Integrator

7)       Oracle Developer (Forms andReports)

8)       Oracle Ebusiness Suite 11i and12

9)       Oracle Enterprise Content

10)   Oracle Enterprise SingleSign-on

11)   Oracle Enterprise performancemanagement (Hyperion) products

12)   Oracle Guardian

13)   Oracle Identity Managementproducts

14)   Oracle JDBC/PRO *C/ODBC andother development client related information

15)   Oracle Management Server andIntelligent Agent (Grid Server, Agent Server, DB Control)

16)   Oracle Networking products

17)   Oracle RAC Cluster(Single/Multiple Nodes, Automatic Storage Management, Oracle Cluster FileSystem, Data Guard)

18)   Oracle RDBMS Server (Standardand Enterprise Editions)

19)   Oracle Retail (Retek)

20)   Oracle SQL*Plus/iSQL*Plus

21)   Oracle Universal Archive (11g)

22)   PeopleSoft

23)   Siebel

.RDA 的安装使用

RDA 8.5.14.9.9的版本是:Patchset 19543134可以直接从MOS 上下载

3.1 RDA 安装

1找个目录解压解压之后会创建rda的目录(要在oracle产品所属用户下)

2不要在windows 平台上解压缩linux RDA 因为这样会移除shell脚本每行的^M 字符。

3确认rda.sh rda.pl 脚本的权限。 2个脚本作用是一样的,只是一个是shell,一个是perl,都是用来收集信息的,如果我们要使用RDA,就是执行其中一个脚本就可以了。  (要确保它们有可执行权限)

4–rda 不需要安装,解压缩之后就可以使用了。

验证安装./rda.sh –cv

 

linux上的一个示例:

[oracle@localhost ~]$ unzip p19543134_805_Generic.zip

……

[oracle@localhost ~]$ cd rda                                               

[oracle@localhost rda]$ ls -rtl                                            

total 252                                                                   

-r-xr-xr-x   1 oracle dba  9448 Sep  2 17:50 sdci.sh                       

-r-xr-xr-x   1 oracle dba 24158 Sep  2 17:50 sdci.pl                       

-r-xr-xr-x   1 oracle dba  8795 Sep  2 17:50 sdci.cmd                      

-r–r–r–   1 oracle dba 15886 Sep  2 17:50 README_Windows.txt            

-r–r–r–   1 oracle dba 17292 Sep  2 17:50 README_VMS.txt                

-r–r–r–   1 oracle dba  5154 Sep  2 17:50 README_upgrade.txt             

-r–r–r–   1 oracle dba 15976 Sep  2 17:50 README_Unix.txt               

-r–r–r–   1 oracle dba  3346 Sep  2 17:50 README_irda.txt               

-r-xr-xr-x   1 oracle dba 10490 Sep  2 17:50 rda.sh                        

-r-xr-xr-x   1 oracle dba 39260 Sep  2 17:50 rda.pl                        

-r-xr-xr-x   1 oracle dba  7768 Sep  2 17:50 rda.com                       

-r-xr-xr-x   1 oracle dba  9099 Sep  2 17:50 rda.cmd                       

-r-xr-xr-x   1 oracle dba 14287 Sep  2 17:50 irda.pl                       

-r–r–r–   1 oracle dba  4106 Sep  2 17:50 DISCLAIM.txt                  

drwxr-xr-x  17 oracle dba  4096 Sep  9 09:38 RDA                           

drwxr-xr-x   3 oracle dba  4096 Sep  9 09:38 Pod                           

drwxr-xr-x   2 oracle dba  4096 Sep  9 09:38 modules                       

drwxr-xr-x   6 oracle dba  4096 Sep  9 09:38 mesg                          

drwxr-xr-x   3 oracle dba  4096 Sep  9 09:38 IRDA                           

drwxr-xr-x   8 oracle dba  4096 Sep  9 09:38 hcve                          

drwxr-xr-x   2 oracle dba  4096 Sep  9 09:38 engine                        

drwxr-xr-x   3 oracle dba  4096 Sep  9 09:38 dfw                            

drwxr-xr-x   8 oracle dba  4096 Sep  9 09:38 Convert                       

drwxr-xr-x  14 oracle dba  4096 Sep  9 09:38 collect                       

drwxr-xr-x   4 oracle dba  4096 Sep  9 09:38 admin                         

 

验证rda

[oracle@localhost rda]$ rda.sh -cv                                         

-bash: rda.sh: command not found                                           

[oracle@localhost rda]$ ./rda.sh -cv                                       

Loading the file list …                                                  

Checking the directory [D_RDA] . …                                       

Checking the directory [D_RDA] engine …                                  

Checking the directory [D_RDA_CHK] APPS …                                 

Checking the directory [D_RDA_CHK] BI …                                  

Checking the directory [D_RDA_CHK] CGBU …                                

Checking the directory [D_RDA_CHK] DB …                                   

Checking the directory [D_RDA_CHK] OFM …                                 

Checking the directory [D_RDA_CHK] TEST …                                

Checking the directory [D_RDA_COL] APPS …                                

Checking the directory [D_RDA_COL] BI …                                  

Checking the directory [D_RDA_COL] CGBU …                                

Checking the directory [D_RDA_COL] DA …                                  

Checking the directory [D_RDA_COL] DB …                                  

Checking the directory [D_RDA_COL] EM …                                  

Checking the directory [D_RDA_COL] EXPLORER …                            

Checking the directory [D_RDA_COL] OFM …                                  

Checking the directory [D_RDA_COL] OS …                                  

Checking the directory [D_RDA_COL] RDA …                                 

Checking the directory [D_RDA_COL] SAMPLE …                               

Checking the directory [D_RDA_COL] TOOL …                                

Checking the directory [D_RDA_CSS] . …                                   

Checking the directory [D_RDA_DAT] . …                                   

Checking the directory [D_RDA_DFW] cv0200 …                              

Checking the directory [D_RDA_INC] Convert/Common …                      

Checking the directory [D_RDA_INC] Convert/DB/LOG …                      

Checking the directory [D_RDA_INC] Convert/OFM/OIM …                     

Checking the directory [D_RDA_INC] Convert/OS/INST …                     

Checking the directory [D_RDA_INC] Convert/OS/OS …                       

Checking the directory [D_RDA_INC] Convert/RDA/CONFIG …                   

Checking the directory [D_RDA_INC] Convert/TOOL/ALERT …                  

Checking the directory [D_RDA_INC] Convert/TOOL/COMPLY …                 

Checking the directory [D_RDA_INC] IRDA …                                

Checking the directory [D_RDA_INC] IRDA/CV0200 …                         

Checking the directory [D_RDA_INC] RDA …                                 

Checking the directory [D_RDA_INC] RDA/Driver …                          

Checking the directory [D_RDA_INC] RDA/Handle …                          

Checking the directory [D_RDA_INC] RDA/Library …                         

Checking the directory [D_RDA_INC] RDA/Local …                           

Checking the directory [D_RDA_INC] RDA/Object …                          

Checking the directory [D_RDA_INC] RDA/Operator …                        

Checking the directory [D_RDA_INC] RDA/Request …                         

Checking the directory [D_RDA_INC] RDA/SDCL …                             

Checking the directory [D_RDA_INC] RDA/SDSL …                            

Checking the directory [D_RDA_INC] RDA/Target …                          

Checking the directory [D_RDA_INC] RDA/UI …                               

Checking the directory [D_RDA_INC] RDA/Value …                           

Checking the directory [D_RDA_INC] RDA/Web …                             

Checking the directory [D_RDA_MSG] charset …                             

Checking the directory [D_RDA_MSG] desc …                                

Checking the directory [D_RDA_MSG] en …                                  

Checking the directory [D_RDA_MSG] fr …                                  

Checking the directory [D_RDA_POD] en …                                   

                                                                           

No issues found   

3.2 RDA使用说明

    Linux/Unix操作系统中,oracle推荐在数据库创建用户下执行(oracle用户)。在第一次使用RDA时, 会在命令行上有一些交互的信息,会让你确实是否收集某些信息。等确认完毕后,会在rda目录下面生成1个配置文件:output.cfg 这里面保存了交互时确认的信息。

     当我们下次执行RDA时,那么就不需要再次进行交互信息的确认。 直接从第一次生成的配置文件中读取即可。 这个交互信息非常多,是需要点耐心来逐步确认的。也可以通过命令生成默认的配置文件。 如果我们想更改收集的配置,那么可以直接修改这个配置文件。 在执行rda 命令就可以了。

 

    RDA 收集的信息会默认会放到/rda/output 文件夹下,在第一次运行RDA时,会提示指定RDA文件已什么开头,并保存在什么位置。 RDA文件有2种格式的文件,一个是html,一个是txt 其中会有一个_start.htm 的文件,我们可以通过这个文件开开始阅读整个RDA

在生成RDA 文件的同时,默认还会把RDA文件打成一个压缩包。 这个压缩包里的内容和我们output文件夹下的一致。 这个压缩包是用来发送oracle的。 一般创建SR时,Oracle 会要求提供这个RDA的压缩包。

 

运行示例:

[oracle@localhost rda]$ ./rda.sh                                                

Enter the network domain name for this server                                  

>                                                                              

                                                                               

Warning: No domain has been specified                                          

Do you want to specify a new value (Y/N)? y                                    

                                                                               

                                                                                

Enter the network domain name for this server                                  

>                                                                

                                                                                

……下面配置的还有很多很多,第一次需要耐心输入信息。

3.3 查看RDA的信息 

上面生成了RDA的信息。 这里可以用工具把/rda/output 目录下的文件传到windows,也可以tar过去,然后使用IE 进程查看。 打开*_start.htm

 


 

 

.MOS 的文档上贴几个常见的问题

 

1How do I force RDA to run Setup again?

RDA will readthe values it finds in "setup.cfg" first before requiring to answerany setup questions. You can force RDA to start the setup process again intwo(2) ways.

在非第一次运行RDA的情况下,默认会读取setup.cfg文件。 如果要强制的再次setup,有如下2种方法:

 

Deleting or renaming the"setup.cfg" file 

$ ./rda.pl -S or 
c:\>rda.cmd -S or
$ ./rda.sh  -S

 

Running the following RDAcommand: 
$ ./rda.pl  -Sfn or
c:\>rda.cmd -Sfn or
$ ./rda.sh  -Sfn

 

2How do I force RDA to collect data again?

RDA will readthe values it finds in <output> directory first, if it finds data thathas not been collected it will attempt to collect that data. However if youwant RDA to collect data again you can execute the following commands. (-v: verbose , C: collect , R: render into html, P:Package contents of output directory into archive, and f : forceexecution of all commands.

$ ./rda.sh  -vCRPf or 
c:\>rda.cmd -vCRPf  or 
$ ./rda.pl  -vCRPf  or 
$./rda.sh   -vf  or 
c:\>rda.cmd -vf

 

Finally, if youneed to run data collection for specific module again you can just run thefollowing command (OS: Operating system and DBA: Database)

$ ./rda.sh -vCRP OS DB or 
c:\>rda.cmd -vCRP OS DBA

 

Note: Thecollection process will execute must faster and you will not receive anynotices when it completes. This also overwrite the data in the outputdirectory.

 

3Where is the RDA output located?

The output is aset of HTML files that are located in the RDA output directory which youspecified at setup (the default is /rda/output). You can review the datacollected, by using a Web Browser to open the following file located in theoutput directory:

RDA__start.htm

 

Note that thethe first part of the name "RDA" can be different, depending on yourspecific RDA setup.

The final outputis also packaged in an archive located in the output directory chosen duringRDA setup — the packaged output file will have a .zip, .tar, .tar.gz,or .tar.Z extension.

If the datacollection was generated to assist in resolving a Service Request, send thereport archive (note: file name varies, but ends in .zip, .tar, .tar.gz,or .tar.Z ; e.a: RDA.RDA_db_autoxyz.zip) to Oracle Support byuploading the file via My Oracle Support. If FTP'ing the file, please be sureto FTP in BINARY format. Do not rename the file, as the file name helps OracleSupport quickly identify that RDA output is attached to the service request.>

 

Note: Thefinal 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 inthe <output> manually and send them to Oracle Support. You canuse a packaging/archive utility program like http://www.info-zip.org/Zip.html toperform this task.

 

 

4What does the RDA-nnnnn error mean when I executedRDA?

RDA has a builtin error handling mechanism. You can discover the meaning and possible solutionto the error by using the following RDA command line argument: rda.pl -E {ERROR#} . i.e:

可以使用RDA 命令查看对应错误的详细说明

 
$ ./rda.pl -E RDA-14
RDA-00014: %d issue(s) found in the RDA installation
*Cause: issues encountered when checking the RDA installation
*Action: A fresh install of RDA is probably the easiest way to fix file
alteration problems. However, permission problems can result from
other factors:
- If RDA has been installed by another user, the default settings
could be too restrictive. Please review the local context with
that user and your appropriate local authorities.
- Execution permissions can be missing on startup scripts for other
platforms and when perl is not available from the command line.

 

5Can RDA be setup without asking any questions?

Yes. RDA wasdesigned to determine values to setup question from the customer OSenvironment. You can also, pass all default parameters and values in a singlecommand like this:

$ ./rda.pl-Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ OS INST DB

       在前面讲到,第一次运行RDA时,要确认很多信息。 那么可以使用这种方法避免进行交互。 当然如果是初次使用RDA 还是很有必要了解一下收集的内容。

       这里要注意的事,该命令仅仅是快速的生成配置文件,并没有生成RDA的信息。 我们还是需要再次运行rda.sh 命令的。

 

6Can RDA be scheduled to run automatically via CRONor AT?

Yes. You need tocheck with your OS documentation regarding running scheduling applications likeCRON and AT. Please note you may need purge RDA log files in the <output>directory and encode passwords in your setup.cfgwhen required.

 

7How can I reduce the size or amount of RDA outputfiles?

RDA has 2mechanisms to reduce the size and quantity of trace and log files it collectsand packages in the output file. The first is built into the advance setupprofiles of the various collection modules, specifically for the (INI, DB,WEBC, IAS, GTW, RAC) modules and can be called using the following command(s):

$ rda.sh -S -p expert INI DB  or 
rda.cmd -S -p expert INI DB  or 
rda.pl -S -p expert INI DB

 

The second isusing the using "-e" switch when calling RDA (rda.sh, rda.cmd, orrda.pl):

See modules:DB:[DB_TRACE_AGE, ALERT_TAIL], INI:[RDA_TAIL], GTW:[GATEWAY_TAIL],IAS:[DCM_TAIL], WEBC:[WEBCACHE_TAIL], RAC:[CLUSTER_TAIL]

 

./rda.sh -e DB_TRACE_AGE=5,ALERT_TAIL=1000  or 
./rda.cmd -e DB_TRACE_AGE=5, ALERT_TAIL=1000

 

8How do I verify the RDA package that I installedis not corrupted?

RDA has aninternal file verification system to handle most types of file corruptions, aslong as ./rda.pl, rda.sh, or rda.cmd can be called or not corrupt themselves:It can be run using the following command.

验证RDA的安装是否正确

$ ./rda.sh -vc  or 
C:\>rda.cmd -vc or 
$ ./rda.pl –vc

 

9Why is RDA taking a long time to run the setupprocess?

Commandexecution can be slow to start when there are difficulties to detect the TCP/IPdomain of the server that RDA is running on. The setup process can takesseveral minutes in some circumstances. The RDA_DOMAINenvironment variable can avoid that.

 

On UNIX:

$RDA_DOMAIN=oracle.com 
./rda.sh -S  or

$RDA_DOMAIN=oracle.com
$export RDA_DOMAIN
$./rda.sh -S

 

On Windows:

C:\set\RDA_DOMAIN=oracle.com
C:\rda.cmd -S

 

10How to disable the parallel collection in RDA 4.18and later?

Set the defaultfor NO_PARALLEL to 1 in modules/S000INI.cfg, and specify NO_PARALLEL=1 in allsetup files already present.

 

[oracle@rac2 rda]$ catsetup.bak |grep NO_PARALLEL

NO_PARALLEL=0

 

使用示例

1)先演示一下交互信息配置

因为我之前已经运行过,所以这里使用上面的方法,强制RDA 再次配置一次。

[oracle@rac1 rda]$rda.sh -Sfn

——————————————————————————-

S000INI: Initializes the Data Collection

——————————————————————————-

RDA uses the output file prefix to identifyall files belonging to the same

data collection. The prefix must start witha letter and must contain only

alphanumeric characters.

 

Enter the prefix to be used for all thegenerated files

Hit 'Return' to accept the default (RDA)

> dave

 

Enter the directory used for all the filesto be generated

Hit 'Return' to accept the default(/u01/rda/output)

>

 

Do you want to keep report packages fromprevious runs (Y/N)?

Hit 'Return' to accept the default (N)

>

 

Enter the Oracle home to be used for dataanalysis

Hit 'Return' to accept the default (/u01/app/oracle/product/10.2.0/db_1)

>

 

Enter the network domain name for thisserver

> oracle.com

 

——————————————————————————-

S010CFG: Collects Key ConfigurationInformation

——————————————————————————-

——————————————————————————-

S090OCM: Set up the Configuration ManagerInterface

——————————————————————————-

RDA benefits from Oracle ConfigurationManager by improving its data

collection. Oracle Configuration Manager(OCM) collects the configuration

information and uploads it to the OCMRepository in connected mode. When OCM

is configured in disconnected mode, it addsthe OCM payload to the RDA report

packages in future RDA runs.

 

 

Select the mode that you want to installOracle Configuration Manager in

/u01/app/oracle/product/10.2.0/db_1

 C  Connected Mode

 D  Disconnected Mode

Enter the letter corresponding to yourchoice

Hit 'Return' to accept the default (C)

> c

 

Do you want to install OCM Databasecollection scripts (Y/N)?

Hit 'Return' to accept the default (Y)

>

 

Enter a SYSDBA user for installing the OCMDatabase collection scripts

Hit 'Return' to accept the default (sys)

…..

The setup has been interruptedcrtl+c

Do you want to restart it(Y/N)?n

RDA-00121: RDA setupinterrupted

 

这里的信息还有很多。 就不贴了,强制中断,然后使用我们全部默认参数的方法。

 

2)直接使用默认的参数,避免交互配置

生成默认配置文件

[oracle@rac1 rda]$ rda.pl-Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ OS

[oracle@rac1 rda]$ ls

ccr          engine   modules rda.com         README_Unix.txt     setup.bak

Convert       hcve    output   rda.pl           README_upgrade.txt  setup.cfg

dfw           IRDA     RDA     rda.sh           README_VMS.txt

DISCLAIM.txt  irda.pl rda.cmd  README_irda.txt  README_Windows.txt

 

生成RDA

[oracle@rac1 rda]$rda.sh

——————————————————————————-

RDA Data Collection Started 07-Sep-201123:22:29

——————————————————————————-

Processing Initialization module …

Enter the password for 'SYSTEM':

Please re-enter it to confirm:

Processing OCM module …

Processing CFG module …

Processing PERF module …

Processing Sampling module …

Processing OS module …

Processing PROF module …

Processing NET module …

Processing Oracle installation module …

Processing RDBMS module …

Processing LOG module …

Processing WREQ module …

Processing IREQ module …

Processing JDEV module …

Processing RDSP module …

Processing LOAD module …

Processing End module …

——————————————————————————-

RDA Data Collection Ended 07-Sep-201123:24:32

——————————————————————————-

 

 Youcan review the reports by transferring the contents of the

 /u01/rda/output directory to a location whereyou have web-browser access.

 Then, point your browser at this file todisplay the reports:

  RDA__start.htm

 

 Based on your server configuration, somepossible alternative approaches are:

 - Ifyour client computer with a browser has access to a web shared

  directory, copy the /u01/rda/output directory to the web shareddirectory

  and visit this URL:

   http://machine:port/web_shared_directory/RDA__start.htm

   or

 - Ifyour client computer with a browser has FTP access to the server

  computer with the /u01/rda/output directory, visit this URL:

   ftp://root@rac1//u01/rda/output/RDA__start.htm

 

 Ifthis file was generated to assist in resolving a Service Request, please

 send/u01/rda/output/RDA.RDA_rac1.zip to Oracle Support by uploading the file

 viaMy Oracle Support. If ftp'ing the file, please be sure to ftp in BINARY

 format.

 

 Please note: Do not submit any health, paymentcard or other sensitive

 production data that requires protectionsgreater 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 yoursubmission is available at

 https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1227943.1

 

RDA-00017: Warning – 1 command(s) notexecuted in CFG module(s)

[oracle@rac1 rda]$

 

 




Related posts

coded by nessus
分享:  DeliciousGReader鲜果豆瓣CSDN网摘
Trackback

no comment untill now

Add your comment now

无觅相关文章插件