Oracle诊断工具RDA使用记录

RDA是Remote Diagnostic Agent 的简称,是Oracle用来收集、分析数据库的工具,运行该工具不会改变系统的任何参数,RDA收集的相关数据非常全面,可以用于oracle巡检及日常监控分析。工具支持AIX,Linux,Solaris,HP-UX,Windows等操作系统。

Oracle数据库监控软件(简称Oracle监控或Oracle监控软件)是企事业单位中最重要的监控需要,通过对Oracle数据库的监控,可以全面了解Oracle的运行状态、数据库响应情况、数据库表空用度情况。

SUM服务器监控软件对Oracle数据库的监控十分全面,主要有:缓冲区命中率监控、表空间使用率监控、表空间监控、会话数监控、连接数监控等核心性能,这些性能均为DBA必须了解和随时掌握的性能,SUM的监控为DBA提供了有力的帮助。在Oracle数据库的性能监控中其中表空间随时监控是DBA首要职责,因为一旦表空用尽,将无法再进行数据库的操作,这将给应用软件造成很大的损失。通过SUM监控与短信报警功能,DBA可以设定表空间使用率阀值进行报警,比如可以设定表空间使用率达到95%后就立即短信通知指定的DBA进行表空间扩容,从而可以有效地避免因为表空间不足引起的应用程序错误和数据库错误。

这里简要记录使用过程。RDA工具51cto下载地址:http://down.51cto.com/data/762579

1. 上传到Linux系统上解压使用

上传rda到/home/oracle目录下

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

(1) 第一次初始化工作

$ ./rda.sh -S

(2) 开始收集信息

$ ./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':   需要输入数据库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信息

image

(2) 操作系统信息,下面可以查看CPU,内存,磁盘等各类信息

image

(3) 数据库的信息等

image

通过以上数据可以快速了解数据库服务器的相关信息,强大。

业务热线电话:(+86)021-52765253 021-61172807      上海哲涛网络科技有限公司版权所有 © 2005-2018       沪ICP备06058430-1号

沪公网安备 31011302000898号

校睿宝,培训机构学员管理软件,教师工资计算软件,消课管理软件!

手机智慧课堂答题,短信答题,微信答题!

数据备份软件,文件数据备份软件,文件备份软件,B/S架构备份软件,分布式计算机备份软件!