RDA是Remote Diagnostic Agent 的簡(jiǎn)稱，是Oracle用來(lái)收集、分析數(shù)據(jù)庫(kù)的工具，運(yùn)行該工具不會(huì)改變系統(tǒng)的任何參數(shù)，RDA收集的相關(guān)數(shù)據(jù)非常全面，可以用于oracle巡檢及日常監(jiān)控分析。工具支持AIX,Linux,Solaris,HP-UX,Windows等操作系統(tǒng)。這里簡(jiǎn)要記錄使用過(guò)程。RDA工具51cto下載地址：http://down.51cto.com/data/762579

創(chuàng)新互聯(lián)公司專(zhuān)注于企業(yè)成都全網(wǎng)營(yíng)銷(xiāo)推廣、網(wǎng)站重做改版、浦東網(wǎng)站定制設(shè)計(jì)、自適應(yīng)品牌網(wǎng)站建設(shè)、H5場(chǎng)景定制、商城網(wǎng)站制作、集團(tuán)公司官網(wǎng)建設(shè)、成都外貿(mào)網(wǎng)站建設(shè)公司、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁(yè)設(shè)計(jì)等建站業(yè)務(wù)，價(jià)格優(yōu)惠性價(jià)比高，為浦東等各大城市提供網(wǎng)站開(kāi)發(fā)制作服務(wù)。

1. 上傳到Linux系統(tǒng)上解壓使用

上傳rda到/home/oracle目錄下

# chown -R oracle:oinstall /home/oracle/rda
# su - oracle
$ cd rda

(1) 第一次初始化工作

$ ./rda.sh -S

(2) 開(kāi)始收集信息

$ ./rda.sh -v

       Collecting diagnostic data ...
-------------------------------------------------------------------------------
RDA Data Collection Started 12-Nov-2014 10:14:50 PM
-------------------------------------------------------------------------------
Processing Initialization module ...
Enter the password for 'SYSTEM':  需要輸入數(shù)據(jù)庫(kù)system密碼
Please re-enter it to confirm:
Processing CFG module ...
Processing Sampling module ...
Processing OS module ...
Processing PROF module ...
Processing PERF module ...
Processing NET module ...
Processing networking information (network files, sql*net files)...
Listener checks may take a few minutes. please be patient...
 Processing listener status, services and log for listener LISTENER
Processing Oracle installation module ...
Processing RDBMS module ...
Processing LOG module ...
Processing Web Server module ...
Processing Web Server (9iAS 1.x) module ...
Processing HTTP Server ...
Processing J2EE/OC4J module ...
Processing RDSP module ...
Processing End module ...
-------------------------------------------------------------------------------
RDA Data Collection Ended 12-Nov-2014 10:16:15 PM
-------------------------------------------------------------------------------
       Generating the reports ...
               - RDA_DBA_vspparameters.txt ...
               - RDA_NET_netperf.txt ...
               - RDA_PERF_top_sql.txt ...
               - RDA_OS_tracing.txt ...
               - RDA_IAS_apache_over.txt ...
               - RDA_NET_sqlnet_tnsnames_ora.txt ...
               - RDA_OS_cpu_info.txt ...
               - RDA_IAS_web_env.txt ...
               - RDA_DBA_jvm_info.txt ...
               - RDA_DBA_text.txt ...
               - RDA_PROF_profiles.txt ...
               - RDA_DBA_datafile.txt ...
               - RDA_DBA_vfeatureinfo.txt ...
               - RDA_DBA_nls_parms.txt ...
               - RDA_DBA_aq_data.txt ...
               - RDA_OS_kernel_info.txt ...
               - RDA_DBA_vsystem_event.txt ...
               - RDA_END_system.txt ...
               - RDA_DBA_vcompatibility.txt ...
               - RDA_DBA_security.txt ...
               - RDA_DBA_spatial.txt ...
               - RDA_INST_orainst_loc.txt ...
               - RDA_INST_oracle_home.txt ...
               - RDA_OS_system_error_log.txt ...
               - RDA_OS_disk_info.txt ...
               - RDA_OS_sysdef.txt ...
               - RDA_DBA_undo_info.txt ...
               - RDA_PROF_dot_bashrc.txt ...
               - RDA_DBA_partition_data.txt ...
               - RDA_OS_libc.txt ...
               - RDA_DBA_vHWM_Statistic.txt ...
               - RDA_INST_installActions20141104_085020PM_log.dat ...
               - RDA_DBA_database_properties.txt ...
               - RDA_DBA_voption.txt ...
               - RDA_PERF_overview.txt ...
               - RDA_CFG_database.txt ...
               - RDA_PROF_etc_profile.txt ...
               - RDA_INST_oraInstall20141104_085020PM_out.dat ...
               - RDA_OS_nls_env.txt ...
               - RDA_NET_sqlnet_sqlnet_ora.txt ...
               - RDA_INST_oraInstall20141104_085748PM_out.dat ...
               - RDA_OS_memory_info.txt ...
               - RDA_NET_netenv.txt ...
               - RDA_DBA_vcontrolfile.txt ...
               - RDA_PROF_dot_bash_profile.txt ...
               - RDA_DBA_mts.txt ...
               - RDA_NET_ifconfig.txt ...
               - RDA_END_report.txt ...
               - RDA_INST_make_report.txt ...
               - RDA_DBA_vlicense.txt ...
               - RDA_DBA_all_errors.txt ...
               - RDA_OS_misc_linux_info.txt ...
               - RDA_INST_orainventory_files.txt ...
               - RDA_DBA_ses_procs.txt ...
               - RDA_NET_tcpip_settings.txt ...
               - RDA_NET_sqlnet_listener_ora.txt ...
               - RDA_INST_installActions20141104_085748PM_log.dat ...
               - RDA_DBA_sga_info.txt ...
               - RDA_PROF_ulimit.txt ...
               - RDA_OS_packages.txt ...
               - RDA_DBA_init_ora.txt ...
               - RDA_OS_etc_conf.txt ...
               - RDA_LOG_log_trace.txt ...
               - RDA_DBA_tablespace.txt ...
               - RDA_NET_udp_settings.txt ...
               - RDA_OS_linux_release.txt ...
               - RDA_J2EE_versions.txt ...
               - RDA_DBA_vresource_limit.txt ...
               - RDA_DBA_log_info.txt ...
               - RDA_IAS_web_processes.txt ...
               - RDA_INST_orainventory_logdir.txt ...
               - RDA_INST_opatch_report.txt ...
               - RDA_NET_etc_files.txt ...
               - RDA_INST_inventory_xml.txt ...
               - RDA_OS_java_version.txt ...
               - RDA_DBA_dba_registry.txt ...
               - RDA_INST_oratab.txt ...
               - RDA_DBA_vsession_wait.txt ...
               - RDA_DBA_vparameters.txt ...
               - RDA_DBA_jobs.txt ...
               - RDA_PROF_env.txt ...
               - RDA_DBA_invalids.txt ...
               - RDA_DBA_security_files.txt ...
               - RDA_NET_lstatus.txt ...
               - RDA_DBA_versions.txt ...
               - RDA_DBA_vfeatureusage.txt ...
               - RDA_DBA_replication.txt ...
               - RDA_DBA_latch_info.txt ...
               - Report index ...
       Packaging the reports ...

You can review the reports by transferring the contents of the output
directory to a location where you have web-browser access. Then, point your
browser at this file to display the reports:
  RDA__start.htm

Based on your server configuration, some possible alternative approaches are:
- If your client computer with a browser has access to a web shared
  directory, copy the output directory to the web shared directory and visit
  this URL:
http://machine:port/web_shared_directory/RDA__start.htm
  or
- If your client computer with a browser has FTP access to the server
  computer with the output directory, visit this URL:
ftp://root@node1./rda/output/RDA__start.htm

If this file was generated to assist in resolving a Service Request, please
send output/RDA.RDA_node1.zip to Oracle Support by uploading the file via
Metalink. If ftp'ing the file, please be sure to ftp in BINARY format.

       Updating the setup file ...
$

2. 將output目錄中的.zip文件拷貝下來(lái)解壓查看
按上面的提示打開(kāi)RDA__start.htm

(1) Overview信息

(2) 操作系統(tǒng)信息，下面可以查看CPU，內(nèi)存，磁盤(pán)等各類(lèi)信息

(3) 數(shù)據(jù)庫(kù)的信息等

通過(guò)以上數(shù)據(jù)可以快速了解數(shù)據(jù)庫(kù)服務(wù)器的相關(guān)信息，強(qiáng)大。

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無(wú)理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國(guó)服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡(jiǎn)單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢(shì)，專(zhuān)為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場(chǎng)景需求。

分享題目：Oracle診斷工具RDA使用記錄-創(chuàng)新互聯(lián)
當(dāng)前網(wǎng)址：http://weahome.cn/article/doeops.html