Oracle Diagnostic Tool RDA Usage records

RDA is the short name of the remote Diagnostic Agent, the tool that Oracle uses to collect and analyze the database, and the tool does not change any of the system's parameters, and the data collected by RDA is comprehensive and can be used for Oracle patrol and daily monitoring analysis. The tool supports aix,linux,solaris,hp-ux,windows and other operating systems. Here is a brief record of the use process. RDA Tool 51cto:http://down.51cto.com/data/762579

1. Upload to Linux system for decompression and use

Upload RDA to the/home/oracle directory

# Chown-r Oracle:oinstall/home/oracle/rda
# su-oracle
$ CD RDA

(1) First time initialization work

$./rda.sh-s

(2) Start collecting information

$./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 ': You need to enter the database SYSTEM password
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 is:
-If your client computer with a browser have 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 have FTP access to the server
Computer with the output directory, visit this URL:
ftp://[email protected]/rda/output/rda__start.htm

If This file is generated to assist with 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. Copy the. zip file from the output directory to unzip the view
Follow the prompts above to open rda__start.htm

(1) Overview information

650) this.width=650; "style=" border-bottom:0px;border-left:0px;border-top:0px;border-right:0px; "title=" image " Border= "0" alt= "image" Src= "Http://img1.51cto.com/attachment/201411/12/703525_1415806533klcu.png" height= "493"/ >

(2) Operating system information, the following can view the CPU, memory, disk and other types of information

650) this.width=650; "style=" border-bottom:0px;border-left:0px;border-top:0px;border-right:0px; "title=" image " Border= "0" alt= "image" Src= "Http://img1.51cto.com/attachment/201411/12/703525_1415806540Rb4W.png" height= "534"/ >

(3) Information on the database, etc.

650) this.width=650; "style=" border-bottom:0px;border-left:0px;border-top:0px;border-right:0px; "title=" image " Border= "0" alt= "image" Src= "Http://img1.51cto.com/attachment/201411/12/703525_1415806550AQga.png" height= "568"/ >

Through the above data can quickly understand the database server information, powerful.

This article is from the "Koumm Linux Technology blog" blog, be sure to keep this source http://koumm.blog.51cto.com/703525/1575915

Oracle Diagnostic Tool RDA Usage records