Oracle RDA安装部署

1.概述

RDA是Remote Diagnostic Agent 的简称,是oracle用来收集、分析数据库的工具,运行该工具不会改变系统的任何参数,RDA收集的相关数据非常全面,可以简化我们日常监控、分析数据库的工作,Oracle Support也建议我们在反馈相关问题时,提供RDA收集的数据,这样可以为快速解决问题提供一个有力的保证。

RDA工具支持的操作系统有以下:
Apple Mac OS X/Darwin
HP OpenVMS Alpha 7.3-2 and above
HP OpenVMS Itanium
HP Tru64 UNIX
HP-UX Itanium
HP-UX PA-RISC (32 and 64 bit)
IBM AIX on POWER Systems(32 and 64 bit)
IBM Dynix/Ptx
IBM Linux on POWER
IBM zSeries Based Linux
Linux Itanium
Linux x86 (32 and 64 bit)
Microsoft Windows 7
Microsoft Windows 2000 Workstation and Server
Microsoft Windows 2003 Server
Microsoft Windows 2008
Microsoft Windows 2012
Microsoft Windows Vista
Microsoft Windows XP Professional
Sun Solaris Intel
Sun Solaris SPARC (32 and 64 bit)

RDA工具下载地址(需要Oracle MOS帐号):
Remote Diagnostic Agent (RDA) – Getting Started (文档 ID 314422.1)
也可以直接搜索补丁号:21769913

其它相关使用帮助文档:
Remote Diagnostic Agent (RDA) – Content Modules Man Page (文档 ID 330760.1)
Remote Diagnostic Agent (RDA) – FAQ (文档 ID 330363.1)
Remote Diagnostic Agent (RDA) – Main Man Page (文档 ID 330364.1)
Remote Diagnostic Agent (RDA) – Profile Manual Pages (文档 ID 391983.1)
Remote Diagnostic Agent (RDA) – RAC Cluster Guide (文档 ID 359395.1)

RDA支持巡检的产品较多,这里只以Oracle RDBMS为例。

2.最快地部署使用RDA

    (1)RDA安装

上传p21769913_814161213_Linux-x86-64.zip到Oracle数据库运行用户的HOME目录或其它目录(RDA占用空间一般只有200m左右),并解压。
$ unzip -q p21769913_814161213_Linux-x86-64.zip
$ cd rda

    (2)部署Oracle 11gR2单实例配置

在rda目录中执行如下脚本:
$ ./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p DB11g

    (3)部署Oracle 10gR2单实例配置

./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB10g

    (4)执行收集
$ ./rda.sh
------------------------------------------------------------------------------
RDA Data Collection Started 23-Dec-2016 11:10:51
------------------------------------------------------------------------------
Processing RDA.BEGIN module ...
Enter the password for "SYSTEM" at "TEST1": 	-> 输入system用户口令
Re-enter it to confirm: 			-> 再次确认
Processing OS.PERF module ...
Processing RDA.CONFIG module ...
Processing OS.OS module ...
Processing OS.PROF module ...
Processing OS.NET module ...
Processing OS.ONET module ...
Listener checks may take a few minutes. Be patient...
  Processing listener LISTENER
Processing OS.INST module ...
Processing DB.DBA module ...
Processing HCVE tests ...
Performing HCVE checks ...
......

经过大概10分钟左右,RDA把信息收集完后就退出了,收集的信息在output目录下,里面生成了很多HTML文件,我们只需要下载rda目录下的tar.gz文件到本地即可。如:
$ pwd
/home/oracle/rda
$ ls -l | grep zip
-rw-r—– 1 oracle oinstall 1868928 Dec 23 11:15 RDA_output_liuweitest02.zip
下载到本地,解压后,用浏览器打开RDA__start.htm文件,效果如下:

采用这种方法安装部署,可以避免RDA前期配置烦人的询问,达到最快速获取数据。这里采用的profile,基本可以满足巡检要求。

3.RDA的帮助信息

$ ./rda.sh -h
Usage: rda.pl [-bcdfilnvwxy] [-ABCDEGHIKLMPQRSTV] [-e edt] [-m dir] [-o out]
              [-p nam] [-s nam] [-t lvl] arg ...
        -A     Authentify user through the result set definition file
        -B     Start background collection
        -C     Collect diagnostic information
        -D     Delete specified modules from the collection
        -E     Explain specified error numbers
        -G     Convert report files to XML format
        -H     Halt background collection
        -I     Regenerate the index
        -K     Kill background collection
        -L     List the available modules, profiles, and conversion groups
        -M     Display the related manual pages
        -O     Render output specifications from the standard input
        -P     Package the reports (tar or zip)
        -Q     Display the related setup questions
        -R     Generate specified reports
        -S     Setup specified modules
        -T     Execute test modules
        -V     Display component version numbers
        -b     Do not backup result set definition file before saving
        -c     Check the RDA installation and exit
        -d     Set debug mode
        -e edt Specify a list of alternate setting definitions (var=val,...)
        -f     Set force mode
        -g grp Specify the XML conversion group
        -h     Display the command usage and exit
        -i     Read settings from the standard input
        -l     Use a lock file to prevent concurrent usage of a definition file
        -m dir Specify the module directory ('collect' by default)
        -n     Start a new data collection
        -o out Specify the file for background collection output redirection
        -p nam Specify the collection profile ('Default' by default)
        -q     Set quiet mode
        -s nam Specify the result set name ('output' by default)
        -t lvl Specify the trace level
        -u lng Specify the language and character set for user interactions
        -v     Set verbose mode
        -w     Wait as long as the background collection daemon is active
        -x     Produce cross references
        -y     Accept all defaults and skip all pauses

4.RDA的所有模块

$ ./rda.sh -L Module
Available data collection modules:
  ACFS          Collects ASM Cluster File System Information
  ACT           Collects Oracle E-Business Suite Application Information
  ADBA          Collects ACS Oracle Database Assessment
  ADX           Collects AutoConfig and Rapid Clone Information
  AGT           Collects Enterprise Manager Agent Information
  APEX          Collects APEX Information
  ASAP          Collects Automated Service Activation Program Information
  ASBR          Collects Application Server 10g Backup and Recovery
                Information
  ASG           Collects Application Server Guard Information
  ASIT          Collects Oracle Application Server Installation Information
  ASM           Collects Automatic Storage Management Information
  B2B           Collects Oracle Business to Business Information
  BAM           Collects Business Activity Monitoring Information
  BEE           Collects Beehive Information
  BEGIN         Initializes the Data Collection
  BI            Collects Oracle Business Intelligence Enterprise Edition Info.
  BIPL          Collects Oracle Business Intelligence Publisher Information
  BPEL          Collects Oracle BPEL Process Manager Information
  BPM           Collects Oracle Business Process Management Suite Information
  BR            Collects Oracle Database Backup and Recovery Information
  BRM           Collects Billing and Revenue Management Information
  CAMM          Collects Oracle Composite Application Monitor and Modeler
                Info.
  CB            Collects Oracle Crystal Ball Information
  CCR           Collects OCM Diagnostic Information
  CDB           Collects Oracle Container or Pluggable Database Information
  CM            Collects Configuration Management Information
  COHR          Collects Oracle Coherence Information
  CONFIG        Collects Key Configuration Information
  CONT          Collects Oracle Content Services Information
  CRID          Collects Oracle Access Manager (COREid) Information
  CRS           Collects Cluster Information
  CS            Collects Oracle Communications Calendar Server Information
  CUST          Collects Customer-Specific Information
  D2PC          Collects Distributed Transaction Information
  DAC           Collects Data Warehouse Administration Console Information
  DB            Controls Oracle RDBMS Data Collection
  DBA           Collects Oracle RDBMS Information
  DBC           Collects Database Control Information
  DBM           Collects Oracle RDBMS Memory Information
  DBPGA         Collects Oracle RDBMS Process Global Area Memory Information
  DEV           Collects Oracle Developer Information
  DG            Collects Data Guard Information
  DNFS          Collects Direct NFS Information
  DPS           Collects Oracle DSEE Directory Proxy Server Information
  DSCS          Collects Discussions Information
  DSCV          Collects Oracle Discoverer Information
  EAS           Collects Oracle Essbase Administration Services Information
  ECE           Collects Elastic Charging Engine Information
  ECM           Controls Oracle WebCenter Content Data Collection
  EDQ           Collects Oracle Enterprise Data Quality Information
  EMS           Collects Email Marketing Server Information
  END           Finalizes the Data Collection
  EPM           Collects Enterprise Performance Management System Information
  EPMA          Collects Enterprise Performance Management Architect Info.
  EPPM          Collects Primavera Enterprise Project Portfolio Management
                Info
  ES            Collects Oracle Entitlements Server Information
  ESB           Collects Enterprise Service Bus Information
  ESS           Collects Oracle Essbase Information
  ESSO          Collects Oracle Enterprise Single Sign-On Information
  ESST          Collects Oracle Essbase Studio Information
  EXA           Collects Exadata Information
  EXL           Collects Oracle Exalogic Information
  EXLTCS        Collects Oracle Exalytics Information
  EXTRA         Collects User Defined Data
  FCM           Collects Oracle Hyperion Financial Close Management
                Information
  FDM           Collects Oracle Hyperion Financial Data Management Information
  FILTER        Controls Report Content Filtering
  GFS           Collects Oracle GlassFish Server Information
  GRDN          Collects Oracle Guardian Information
  GRID          Controls Grid Control Data Collection
  GTW           Collects Transparent/Procedural Gateway Information
  HCM           Collects Oracle Hyperion Calculation Manager Information
  HDM           Collects Oracle Hyperion Disclosure Management Information
  HDRM          Collects Hyperion Data Relationship Management Information
  HFM           Collects Oracle Hyperion Financial Management Information
  HFR           Collects Oracle Hyperion Financial Reporting Information
  HIR           Collects Oracle Hyperion Interactive Reporting Information
  HPC           Collects Oracle Hyperion Profitability and Cost Management
  HPL           Collects Oracle Hyperion Planning Information
  HPS           Collects Oracle Hyperion Performance Scorecard Information
  HPSV          Collects Oracle Hyperion Provider Services Information
  HSF           Collects Oracle Hyperion Strategic Finance Information
  HSS           Collects Oracle Hyperion Shared Services Information
  HSV           Collects Oracle Hyperion Smart View for Office Information
  HWA           Collects Oracle Hyperion Web Analysis Information
  IA            Collects Intelligent Agent Information
  IAS           Collects Web Server Information
  IFS           Collects iFS (iFS, CMSDK, Files) Information
  INFA          Collects Informatica Information
  INFRA         Collects Oracle Fusion Middleware Infrastructure 12c Info.
  INIT          Controls Oracle Fusion Middleware Data Collection
  INST          Collects the Oracle Installation Information
  IPM           Collects Oracle WebCenter Content: Imaging Information
  IPS           Collects Oracle Incident Packaging Service Information
  IPSA          Collects Oracle Communications IP Service Activator
                Information
  IREQ          Handles the Oracle Instance Collection Requests
  IWPS          Collects Oracle iPlanet Web Proxy Server Information
  IWS           Collects Oracle iPlanet Web Server Information
  J2EE          Collects J2EE/OC4J Information
  JBOSS         Collects JBoss Application Server Information
  JDBC          Collects Oracle Java DB Connectivity (JDBC) Information
  JDEV          Collects Oracle JDeveloper Information
  JIVE          Collects Jive Information
  LANG          Collects Oracle Language Information
  LCM           Collects Oracle Lifecycle Management Information
  LOAD          Produces the External Collection Reports
  LOG           Collects Oracle Database Trace and Log Files
  LTFS          Collects StorageTek Linear Tape File System Information
  MAIL          Collects Oracle Collaboration Suite Mail Information
  MES           Collects Oracle Messaging Exchange Server Information
  MSLG          Collects Microsoft Languages Information
  MYCL          Collects Oracle MySQL Cluster Information
  MYSQ          Collects Oracle MySQL Server Information
  NCC           Collects Network Charging and Control Information
  ND            Collects Oracle Communications Network Discovery Information
  NET           Collects Network Information
  NI            Collects Oracle Communications Network Integrity Information
  NM            Collects Oracle Communications Network Mediation Information
  NPERF         Samples Performance Information (root not required)
  OAAM          Collects Oracle Adaptive Access Manager Information
  OAM           Collects Oracle Access Manager Information
  OCAL          Collects Oracle Calendar Information
  OCCAS         Collects Converged Application Server Information
  OCDB          Collects Oracle Content Database Information
  OCFS          Collects Oracle Cluster File System Information
  OCM           Interacts with the Oracle Configuration Manager
  OCOMC         Collects Offline Mediation Controller Information
  OCS           Controls Oracle Collaboration Suite Data Collection
  OCSG          Collects Oracle Communications Service Gatekeeper Information
  ODC           Collects Oracle WebCenter Enterprise Capture Information
  ODI           Collects Oracle Data Integrator Information
  ODM           Collects Oracle Data Mining Information
  OES           Collects Oracle Express Server Information
  OFA           Collects Oracle Fusion Applications Information
  OFAP          Collects Oracle Fusion Applications Provisioning Information
  OGG           Collects Oracle GoldenGate Information
  OHS           Collects Oracle HTTP Server 12c Information
  OIA           Collects Oracle Identity Analytics Information
  OID           Collects Oracle Internet Directory Information
  OIF           Collects Oracle Identity Federation 10g Information
  OIM           Collects Oracle Identity Manager Information
  OLAP          Collects OLAP Information
  OMM           Collects Oracle Multimedia or Oracle interMedia Information
  ONET          Collects Oracle Net Information
  OS            Collects the Operating System Information
  OSB           Collects Oracle Service Bus Information
  OSM           Collects Order and Service Management Information
  OSSO          Collects Oracle OpenSSO Information
  OTD           Collects Oracle Traffic Director Information
  OUD           Collects Oracle Unified Directory Information
  OVD           Collects Oracle Virtual Directory Information
  OVMM          Collects Oracle VM Manager Information
  OVMS          Collects Oracle VM Server Information
  OW            Collects Oracle Waveset Information
  OWB           Collects Oracle Warehouse Builder Information
  OWSM          Collects Oracle Web Services Manager Information
  PAPP          Collects PeopleSoft Information from Tuxedo Application Server
  PDA           Collects Oracle Portal Information
  PDBA          Collects PeopleSoft Information from an Oracle Database
  PDC           Collects Oracle Communications Pricing Design Center
                Information
  PERF          Collects Performance Information
  PLNC          Collects Oracle PL/SQL Native Compilation Information
  PR            Collects Oracle Hyperion SQR Production Reporting Information
  PROF          Collects the User Profile
  PS            Collects Oracle Communications Policy Services Information
  PSCH          Collects PeopleSoft Information from Process Scheduler
  PSFT          Controls PeopleSoft Data Collections
  PWEB          Collects PeopleSoft Information from Web Application Server
  RACD          Performs an Oracle Database Hang Analysis
  REMOTE        Performs the Remote Data Collections
  RET           Collects Oracle Retail Information
  RPERF         Samples Performance Information (root privileges required)
  RSRC          Collects Oracle Database Resource Manager Information
  RTC           Collects Real Time Communication Information
  SAMPLE        Controls Sampling
  SAMPLE.EXTRA  Samples User Defined Data
  SC            Collects Oracle Communications Service Controller Information
  SEBL          Collects Siebel Information
  SES           Collects Oracle Secure Enterprise Search Information
  SOA           Collects Oracle SOA Suite Information
  SP            Collects SQL*Plus/iSQL*Plus Information
  SSO           Collects Single Sign-On Information
  STA           Collects StorageTek Tape Analytics Information
  STATUS        Produces the Remote Data Collection Reports
  STC           Collects Streams Configuration Information
  STM           Collects Streams Monitoring Information
  TOMCAT        Collects Apache Tomcat Information
  TOPL          Collects Oracle TopLink Information
  TTEN          Collects Oracle TimesTen In-Memory Database Information
  TUX           Collects Oracle Tuxedo Information
  UCM           Collects Oracle WebCenter Universal Content Management
                Information
  UIM           Collects Unified Inventory Management Information
  UOA           Collects Oracle Universal Online Archive Information
  WAC           Collects Web Access Client Information
  WC            Collects Oracle WebCenter Suite Information
  WCA           Collects Oracle WebCenter Analytics Information
  WCI           Collects Oracle WebCenter Interaction Information
  WCS           Collects Oracle WebCenter Sites Information
  WEBC          Collects Oracle Web Cache Information
  WG            Collects Oracle WebGate Information
  WKSP          Collects Workspaces Information
  WLI           Collects Oracle WebLogic Integration Information
  WLS           Collects Oracle WebLogic Server Software and Domain
                Information
  WMC           Collects Webmail Client Information
  WREQ          Handles Collection Requests from Oracle WebLogic Server
                Modules
  WRLS          Collects Wireless Information
  WS            Collects Oracle Web Services Information
  WSP           Collects IBM WebSphere Application Server Information
  XDB           Collects XDB Information
  XPLR          Performs Oracle Explorer Collections

4.1主要Module说明

参考Remote Diagnostic Agent (RDA) 4 – Content Modules Man Page [ID 330760.1]
RAC模块用来Collects Cluster Information收集集群信息
RACD模块则负责收集RAC数据库挂起的相关信息Performs a Database Hang Analysis。

5.RDA的profile

我们在配置RDA的时可以直接执行./rda.sh,脚本会提示我们需要选择启用哪些Module,但是因为Module过多,整个配置过程就会浪费很多时间。
为了避免每配置一套新环境都要大费周章确认那么多模块, 所以在RDA中定义了很多典型场景使用的profile, 这些profile已经配好了固定的一些Module,下面我们来看一下RDA profile:

$   ./rda.sh -L profiles
Available profiles:
  AS10g                            Oracle Application Server 10g problems
  AS10g_Discoverer                 Discoverer 10g problems
  AS10g_Identity                   Oracle Identity Management 10g problems
  AS10g_IdentityFed                Oracle Identity Federation 10g problems
  AS10g_MidTier                    Oracle Application Server 10g Middle Tier
                                   problems
  AS10g_Repository                 Oracle Application Server 10g metadata
                                   repository problems
  AS10g_WebLogicPortal             Oracle WebLogic Portal 10g problems
  AS10g_WebTier                    Oracle Application Server 10g WebTier
                                   problems
  AS_BackupRecovery                Oracle Application Server backup/recovery
                                   problems
  Act                              Oracle Application Overview
  AppsCheck                        Equivalent to Apps Check
  Apps_DB_Assessment               Oracle Applications Database assessment
                                   collections
  AsmFileSystem                    Oracle ASM Cluster File System problems
  Asm_Assessment                   Oracle ASM assessment collections
  Beehive                          Oracle Beehive problems
  CloudControl12c                  Cloud Control 12c problems
  CloudControl13c                  Cloud Control 13c problems
  ClusterFileSystem                Oracle Cluster File System problems
  Com_ASAP                         Oracle Communications ASAP problems
  Com_CM                           Oracle Communications Configuration Manager
                                   problems
  Com_IPSA                         Oracle Communications IPSA Software
                                   problems
  Com_NCC                          Oracle Communications Network Charging and
                                   Control problems
  Com_ND                           Oracle Communications Network Discovery
                                   problems
  Com_NI                           Oracle Communications Network Integrity
                                   problems
  Com_NM                           Oracle Communications Network Mediation
                                   problems
  Com_OCCAS                        Oracle Communications Converged Application
                                   Server problems
  Com_OCSG                         Oracle Communications Service Gatekeeper
                                   problems
  Com_OSM                          Oracle Communications Order and Service
                                   Management problems
  Com_PS                           Oracle Communications Policy Services
                                   problems
  Com_SC                           Oracle Communications Service Controller
                                   problems
  Com_SC_Db                        Oracle Communications Service Controller
                                   with Database problems
  Com_UIM                          Oracle Communications Unified Inventory
                                   Management problems
  DB10g                            Oracle Database 10g problems
  DB11g                            Oracle Database 11g problems
  DB12c                            Oracle Database 12c problems
  DB8i                             Oracle Database 8i problems
  DB9i                             Oracle Database 9i problems
  DB_Assessment                    Oracle Database assessment collections
  DB_BackupRecovery                Oracle Database backup and recovery
                                   problems
  DB_Ips                           Oracle Incident Packaging Service problems
  DB_Perf                          Oracle Database performance problems
  DataGuard                        Data Guard problems
  DirectNFS                        Direct NFS problems
  EMAgent11g                       EM Agent 11g problems
  EMAgent12c                       EM Agent 12c problems
  EMAgent13c                       EM Agent 13c problems
  EnterpriseDataQuality            Oracle Enterprise Data Quality problems
  EnterpriseSearch                 Oracle Secure Enterprise Search problems
  Exadata_Assessment               Oracle Exadata assessment collections
  Exadata_CellBrownout             Oracle Exadata long brownout due to cell
                                   failure problems
  Exadata_CellFailure              Oracle Exadata cell failure problems
  Exadata_DatabaseCrash            Oracle Exadata database crash problems
  Exadata_DatabaseHang             Oracle Exadata database hang problems
  Exadata_FailedDrives             Oracle Exadata failed drives problems
  Exadata_FlashDrives              Oracle Exadata flash drives problems
  Exadata_IbSwitch                 Oracle Exadata IB switch problems
  Exadata_Ilom                     Oracle Exadata ILOM problems
  Exadata_ListenerHang             Oracle Exadata listener hang problems
  Exadata_Network                  Oracle Exadata general network problems
  Exadata_NetworkCable             Oracle Exadata network cabling problems
  Exadata_RacInstance              Oracle Exadata RAC instance problems
  Exadata_SickCell                 Oracle Exadata sick cell problems
  Exalogic_DriveFailure            Oracle Exalogic drive failure problems
  Exalogic_Gateway                 Oracle Exalogic gateway problems
  Exalogic_HealthHwSw              Oracle Exalogic hardware and software
                                   health problems
  Exalogic_HealthNet               Oracle Exalogic network health problems
  Exalogic_IbFabric                Oracle Exalogic IB fabric problems
  Exalogic_IbSwitch                Oracle Exalogic IB switch problems
  Exalogic_Ilom                    Oracle Exalogic ILOM problems
  Exalogic_Network                 Oracle Exalogic general network problems
  Exalogic_Patch                   Oracle Exalogic image patches problems
  Exalogic_Raid                    Oracle Exalogic RAID card problems
  Exalogic_Temp                    Oracle Exalogic ambient temperature
                                   problems
  Exalytics                        Oracle Exalytics problems
  FM11g_Bi                         Business Intelligence Enterprise Edition
                                   11g problems
  FM11g_Bia                        Business Intelligence Applications problems
  FM11g_WlsBi                      Business Intelligence Enterprise Edition
                                   11g with WLS
  FM11g_WlsBia                     Business Intelligence Applications with WLS
  FusionApps                       Oracle Fusion Applications problems
  GlassFishServer                  Oracle GlassFish Server problems
  GoldenGate                       Oracle GoldenGate problems
  GridControl10g                   Grid Control 10g problems
  GridControl11g                   Grid Control 11g problems
  Hyperion1112_CB                  Oracle Crystal Ball problems
  Hyperion1112_EAS                 Oracle Essbase Administration Services
                                   11.1.2.x problems
  Hyperion1112_EPM                 Oracle Enterprise Performance Management
                                   System 11.1.2.x problems
  Hyperion1112_EPMA                Oracle Enterprise Performance Management
                                   Architect 11.1.2.x problems
  Hyperion1112_ESS                 Oracle Essbase 11.1.2.x problems
  Hyperion1112_ESST                Oracle Essbase Studio 11.1.2.x problems
  Hyperion1112_FCM                 Oracle Hyperion Financial Close Management
                                   11.1.2.x problems
  Hyperion1112_FDM                 Oracle Hyperion Financial Data Management
                                   11.1.2.x problems
  Hyperion1112_HCM                 Oracle Hyperion Calculation Manager
                                   11.1.2.x problems
  Hyperion1112_HDM                 Oracle Hyperion Disclosure Management
                                   11.1.2.x problems
  Hyperion1112_HDRM                Oracle Hyperion Data Relationship
                                   Management 11.1.2.x problems
  Hyperion1112_HFM                 Oracle Hyperion Financial Management
                                   11.1.2.x problems
  Hyperion1112_HFR                 Oracle Hyperion Financial Reporting
                                   11.1.2.x problems
  Hyperion1112_HIR                 Oracle Hyperion Interactive Reporting
                                   11.1.2.x problems
  Hyperion1112_HPC                 Oracle Hyperion Profitability and Cost
                                   Management 11.1.2.x problems
  Hyperion1112_HPL                 Oracle Hyperion Planning 11.1.2.x problems
  Hyperion1112_HPS                 Oracle Hyperion Performance Scorecard
                                   11.1.2.x problems
  Hyperion1112_HPSV                Oracle Hyperion Provider Services 11.1.2.x
                                   problems
  Hyperion1112_HSF                 Oracle Hyperion Strategic Finance 11.1.2.x
                                   problems
  Hyperion1112_HSS                 Oracle Hyperion Shared Services 11.1.2.x
                                   problems
  Hyperion1112_HSV                 Oracle Hyperion Smart View 11.1.2.x
                                   problems
  Hyperion1112_HWA                 Oracle Hyperion Web Analysis 11.1.2.x
                                   problems
  Hyperion1112_PR                  Oracle Hyperion SQR Production Reporting
                                   11.1.2.x problems
  InterMedia                       Oracle interMedia problems
  Jdbc                             Oracle Java DB Connectivity (JDBC) problems
  LifecycleManagement              Oracle Lifecycle Management problems
  Linux                            Linux problems
  LinuxPerf                        Linux performance problems
  Maa_Assessment                   Maximum Availability Architecture
                                   assessment collections
  Maa_Exa_Assessment               Maximum Availability Architecture with
                                   Exadata assessment collections
  Multimedia                       Oracle Multimedia problems
  MySQLCluster                     Oracle MySQL Cluster problems
  MySQLDatabase                    Oracle MySQL Server problems
  OFM11g_Discoverer                OFM Discoverer problems (11g)
  OFM11g_IDGov                     OFM Idm Governance problems (11g)
  OFM11g_Identity                  OFM Idm problems (11g) : no WLS
  OFM11g_Oam                       OFM Access Manager problems (11g)
  OFM11g_Oim                       OFM Identity Manager problems (11g)
  OFM11g_Portal                    OFM Portal problems (11g): no WLS
  OFM11g_WebTier                   OFM Web Tier problems (11g) : no WLS
  OFM11g_WlsIdentity               OFM Idm problems (11g)
  OFM11g_WlsPortal                 OFM Portal problems (11g)
  OFM11g_WlsWebTier                OFM Web Tier problems (11g)
  OFM12c_Infra                     OFM Infrastructure problems (12c)
  OFM12c_Ohs                       OFM HTTP Server standalone problems (12c)
  OFM12c_OhsInfra                  OFM HTTP Server with Infra problems (12c)
  OFM_Bam                          OFM BAM problems (11g/12c+)
  OFM_Cohr                         OFM Coherence problems (11g/12c+)
  OFM_Ecm                          OFM WebCenter Content problems (11g/12c+)
  OFM_JDev                         OFM JDeveloper problems (11g/12c+)
  OFM_Odi                          OFM ODI problems (11g/12c+) : no WLS
  OFM_OsbMax                       OFM OSB problems (11g/12c+) : full
  OFM_OsbMin                       OFM OSB problems (11g/12c+) : minimum
  OFM_OudAdv                       OFM Unified Directory problems (advanced)
  OFM_OudStd                       OFM Unified Directory problems (standard)
  OFM_Owsm                         OFM OWSM problems (11g/12c+)
  OFM_SoaMax                       OFM SOA Suite problems (11g/12c+) : full
  OFM_SoaMin                       OFM SOA Suite problems (11g/12c+) : minimum
  OFM_Tuxedo                       OFM Tuxedo problems (11g/12c+)
  OFM_UcmWls                       OFM WebCenter UCM problems (11g/12c+)
  OFM_WebCenter                    OFM WebCenter problems (11g/12c+)
  OFM_WebCenterSites               OFM WebCenter Sites problems (11g/12c+)
  OFM_WebGate                      OFM WebGate problems (10g/11g)
  OFM_WebServices                  OFM Web Services problems (11g/12c+)
  OFM_Wls                          OFM WebLogic Server problems (11g/12c+)
  OFM_WlsFormsReports              OFM Forms/Reports problems (11g/12c+)
  OFM_WlsOdi                       OFM ODI problems (11g/12c+)
  OSMonitor                        Operating System performance sampling
  OVMManager                       Oracle VM Manager problems
  Pda10g                           Oracle Portal 10g problems
  Pda11g                           Oracle Portal 11g problems
  Pda9i                            Oracle Portal 9i problems
  PeopleSoft_Appl                  PeopleSoft application server assessment
                                   collections
  PeopleSoft_DB                    PeopleSoft Oracle Database tier assessment
                                   collections
  PeopleSoft_Sched                 PeopleSoft process scheduler assessment
                                   collections
  PeopleSoft_Web                   PeopleSoft Web application server
                                   assessment collections
  Primavera_Eppm                   Primavera Enterprise Project Portfolio
                                   Management problems
  Provisioning                     Oracle Fusion Applications Provisioning
                                   problems
  Rac                              Real Application Cluster problems
  Rac_AdvancedAsm                  Cluster with ASM problems (ASM advanced
                                   mode)
  Rac_Asm                          Cluster with ASM problems
  Rac_Assessment                   Real Application Cluster assessment
                                   collections
  Rac_Perf                         Cluster performance problems
  Retail                           Oracle Retail problems
  Security                         Filter sensitive information from the
                                   reports
  Siebel                           Siebel problems
  Siebel_DB                        Siebel with Oracle Database problems
  StorageTekLTFS                   StorageTek Linear Tape File System problems
  StorageTekTape                   StorageTek Tape Analytics problems
  SupportInformer70                Oracle Communication BRM 7.0 problems
  SupportInformer72                Oracle Communication BRM 7.2 problems
  SupportInformer73                Oracle Communication BRM 7.3 problems
  SupportInformer74                Oracle Communication BRM 7.4 problems
  SupportInformer75                Oracle Communication BRM 7.5 problems
  TimesTen                         Oracle TimesTen problems
  TimesTenLog                      Oracle TimesTen problems with logs
                                   collected
  TopLink10g                       Oracle TopLink 10g problems
  WarehouseBuilder                 Oracle Warehouse Builder problems
  WebCenterContent10g              Oracle WebCenter 10g with Oracle Content
                                   Services problems
  WebLogicServer                   Oracle WebLogic Server problems (any
                                   version)
  WebSphere                        IBM WebSphere Application Server problems

5.1 profile说明

参考Remote Diagnostic Agent (RDA) 4 – Profile Manual Pages [ID 391983.1]
DB11g这个profile是用来收集11g Database数据库的诊断信息的
而DB10g 是收集10g Database诊断信息
DB_Perf是收集数据库性能诊断信息

5.2 查看profile预设的Module

$ ./rda.sh -M -p DB10g
NAME
    Profile DB10g - Oracle Database 10g problems

MODULES
    The DB10g profile uses the following modules:
      DB:DCdb    Controls Oracle RDBMS Data Collection
      DB:DCdba   Collects Oracle RDBMS Information
      DB:DCdbm   Collects Oracle RDBMS Memory Information
      DB:DClog   Collects Oracle Database Trace and Log Files
      DB:DCsp    Collects SQL*Plus/iSQL*Plus Information
      EM:DCagt   Collects Enterprise Manager Agent Information
      EM:DCdbc   Collects Database Control Information
      EM:DCgrid  Controls Grid Control Data Collection
      OS:DCinst  Collects the Oracle Installation Information
      OS:DCnet   Collects Network Information
      OS:DConet  Collects Oracle Net Information
      OS:DCos    Collects the Operating System Information
      OS:DCperf  Collects Performance Information
      OS:DCprof  Collects the User Profile

COPYRIGHT NOTICE
    Copyright (c) 2002, 2016, Oracle and/or its affiliates. All rights
    reserved.

TRADEMARK NOTICE
    Oracle and Java are registered trademarks of Oracle and/or its affiliates.
    Other names may be trademarks of their respective owners.

6.组合profile

除了单独使用某个profile外,我们还可以组合使用多个profile,使用-p profile1-profile2这样的语法即可,如:

./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB10g-DataGuard
./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB10g-Rac

7.配置文件

RDA经过配置后会默认将配置信息写到其目录下的setup.cfg文件中,之后再使用rda.sh收集信息即会沿用该cfg文件:

$cat setup.cfg

# Oracle Remote Diagnostic Agent - Setup Information
###############################################################################

#------------------------------------------------------------------------------
# Data Collection Overview
#------------------------------------------------------------------------------
# S000INI=pending
# S010CFG=pending
# S020SMPL=pending
# S090OCM=pending
# S100OS=pending
# S105PROF=pending
.....

8.RDA完整性检测

可以使用./rda.sh命令对现有的RDA软件做完整性检测,保证RDA没有被修改过:

./rda.sh –cv

关于紫砂壶

感悟技术人生
此条目发表在工具分类目录,贴了标签。将固定链接加入收藏夹。