RDA是Remote Diagnostic Agent 的簡稱，是Oracle用來收集、分析數(shù)據(jù)庫的工具，運行該工具不會改變系統(tǒng)的任何參數(shù)，RDA收集的相關數(shù)據(jù)非常全面，可以用于oracle巡檢及日常監(jiān)控分析。工具支持AIX,Linux,Solaris,HP-UX,Windows等操作系統(tǒng)。這里簡要記錄使用過程。RDA工具51cto下載地址：http://down.51cto.com/data/762579
創(chuàng)新互聯(lián)公司自2013年創(chuàng)立以來，是專業(yè)互聯(lián)網(wǎng)技術服務公司，擁有項目成都網(wǎng)站制作、網(wǎng)站建設網(wǎng)站策劃，項目實施與項目整合能力。我們以讓每一個夢想脫穎而出為使命，1280元云巖做網(wǎng)站,已為上家服務,為云巖各地企業(yè)和個人服務,聯(lián)系電話:028-86922220
上傳rda到/home/oracle目錄下
# chown -R oracle:oinstall /home/oracle/rda
# su - oracle
$ cd rda
$ ./rda.sh -S
$ ./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ù)庫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文件拷貝下來解壓查看
按上面的提示打開RDA__start.htm
(1) Overview信息
(2) 操作系統(tǒng)信息，下面可以查看CPU，內(nèi)存，磁盤等各類信息
(3) 數(shù)據(jù)庫的信息等
通過以上數(shù)據(jù)可以快速了解數(shù)據(jù)庫服務器的相關信息，強大。
重慶分公司
重慶分公司
