加入收藏 | 设为首页 | 会员中心 | 我要投稿 辽源站长网 (https://www.0437zz.com/)- 云专线、云连接、智能数据、边缘计算、数据安全!
当前位置: 首页 > 站长百科 > 正文

RDA的使用和说明

发布时间:2021-02-26 06:04:30 所属栏目:站长百科 来源:网络整理
导读:一.RDA 说明 ? ? ? ?RDA(RemoteDiagnostic Agent)是oracle用来收集、分析数据库的工具,运行该工具不会改变系统的任何参数,RDA收集的相关数据非常全面,可以简化我们日常监控、分析数据库的工作。 ?????? 一般Oracle 原厂的人巡检也是使用RDA工具。 不过一

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?directory and encode passwords in your?setup.cfgwhen required.

?

(7)How 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

?

(8)How 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

?

(9)Why 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:setRDA_DOMAIN=oracle.com
C:rda.cmd -S

?

(10)How 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.

?

[[email?protected] rda]$ catsetup.bak |grep NO_PARALLEL

NO_PARALLEL=0

?

3.2.2 使用示例

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

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

[[email?protected] 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 interrupted(crtl+c)

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

RDA-00121: RDA setupinterrupted

?

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

?

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

--生成默认配置文件

[[email?protected] rda]$?rda.pl-Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ OS

[[email?protected] 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

[[email?protected] 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://[email?protected]//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)

[[email?protected] rda]$

?

这个收集的时间和CPU 有一定的关系。

?

3.3 查看RDA的信息

?????? 在3.2 节生成了RDA的信息。 这里可以用winscp 工具把/rda/output 目录下的文件传到windows,然后使用IE 进程查看。 打开*_start.htm

?

(编辑:辽源站长网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

推荐文章
    热点阅读