快速部署RDA Remote Diagnostic Agent

RDA Remote Diagnostic Agent远程诊断代理是Oracle Support售后服务使用的标准工具之一，当用户在Metalink上提交SR(TAR)时可能Oracle GCS(Global Customer Service)支持会需要让用户从MOS上下载RDA工具，通过RDA收集丰富的数据库环境信息(如包含OS、DB、CRS等)，以便原厂售后直接从RDA report中抓取诊断信息，避免了因诊断信息不足 而反复信息交互所浪费的时间 ； 此外Oracle的一些ACS高级客户服务的现场服务过程中也会利用到RDA，例如当用户要求ACS到现场进行月度或季度巡检是RDA就是标准的检查工具。   说了这么多， 你可能还是不太了解RDA。 这不要紧，你可以把RDA看成一套由oracle定义了很多模块的脚本工具盒， 用它可以收集到诊断过程复杂的Oracle产品问题的各种信息。  可以从My Oracle Support(metalink)的《Remote Diagnostic Agent (RDA) 4 - Getting Started [ID 314422.1]》专栏中下载到各个平台的最新版RDA。     虽然RDA是Oracle Support使用的工具 ， 但是并不是说非原厂售后就看不懂RDA也不能利用到这款工具。  RDA从脚本、模块到最后生成的报告都是自然可读的。   譬如Maclean.Liu 我 在诊断较复杂的问题过程中也会用到RDA， 我甚至推荐在数据库巡检、健康检查过程中也使用RDA， 当然是配合其他工具一起使用。   在使用RDA之前我们需要完成配置工作，所谓配置就是选择我们要使用的RDA module和一些临时设置，先来认识一下有哪些module:  

将下载到的rda zip包解压[oracle@vrh8 ~]$ unzip /tmp/p9079828_418_LINUX.zip [oracle@vrh8 ~]$ cd rda[oracle@vrh8 rda]$ ./rda.sh -h
Usage: rda.pl [-bcdflntvwxy] [-ABCDEHIKLMPQRSTV] [-e list] [-m dir][-s name] [-o out] [-p prof] arg ...-A      Authentify user through the setup file-B      Start background collection-C      Collect diagnostic information-D      Delete specified modules from the setup-E      Explain specified error numbers-H      Halt background collection-I      Regenerate the index-K      Kill background collection-L      List the modules available-M      Display the related manual pages-O      Render output specifications from STDIN-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      Don't backup setup file before saving-c      Check the RDA installation and exit-d      Set debug mode-e list Specify a list of alternate setting definitions (var=val,...)-f      Set force mode-h      Display the command usage and exit-l      Use a lock file to prevent concurrent usage of a setup file-m dir  Specify the module directory ('modules' by default)-n      Start a new data collection-o out  Specify the file for background collection output redirection-p prof Specify the setup profile ('Default' by default)-q      Set quiet mode-s name Specify the setup name ('setup' by default)-t      Set trace mode-v      Set verbose mode-w      Wait as long as the background collection daemon is active-x      Produce module cross reference-y      Accept all defaults and skip all pauses列出所有可用module[oracle@vrh8 rda]$ ./rda.sh -L ModuleAvailable data collection modules are:ACFS     Collects ASM Cluster File System InformationACT      Collects Oracle E-Business Suite Application InformationADBA     Collects ACS Oracle Database AssessmentADX      Collects AutoConfig and Rapid Clone InformationAGT      Collects Enterprise Manager Agent InformationAPEX     Collects APEX InformationASAP     Collects Oracle Communications ASAP InformationASBR     Collects Application Server Backup and Recovery InformationASG      Collects Application Server Guard InformationASIT     Collects Oracle Application Server Installation InformationASM      Collects Automatic Storage Management InformationB2B      Collects Oracle Business to Business InformationBAM      Collects Business Activity Monitoring InformationBEE      Collects Beehive InformationBI       Collects Oracle Business Intelligence Enterprise Edition Info.BPEL     Collects Oracle BPEL Process Manager InformationBR       Collects Database Backup and Recovery InformationBRM      Collects Oracle Communications BRM InformationCCR      Collects OCM Diagnostic InformationCFG      Collects Key Configuration InformationCOHR     Collects Oracle Coherence InformationCONT     Collects Oracle Content Services InformationCRID     Collects Oracle Access Manager (COREid) InformationD2PC     Collects Distributed Transaction InformationDB       Controls RDBMS Data CollectionDBA      Collects RDBMS InformationDBC      Collects Database Control InformationDBM      Collects RDBMS Memory InformationDEV      Collects Oracle Developer InformationDG       Collects Data Guard InformationDNFS     Collects Direct NFS InformationDSCS     Collects Discussions InformationDSCV     Collects Oracle Discoverer InformationECM      Controls Oracle Enterprise Content Management 11g Data CollectionEM       Collects Enterprise Manager OMS and Repository Info (Obsolete)END      Finalizes the Data CollectionEPMA     Collects Enterprise Performance Management Architect InformationESB      Collects Enterprise Service Bus InformationESS      Collects Oracle Essbase InformationESSO     Collects Oracle Enterprise Single Sign-On InformationEXA      Collects Exadata InformationFLTR     Controls Report Content FilteringGRDN     Collects Oracle Guardian InformationGRID     Controls Grid Control Data CollectionGTW      Collects Transparent/Procedural Gateway InformationHFM      Collects Oracle Hyperion Financial Management informationHPL      Collects Oracle Hyperion Planning InformationIA       Collects Intelligent Agent InformationIAS      Collects Web Server InformationIFS      Collects iFS (iFS, CMSDK, Files) InformationINI      Initializes the Data CollectionINST     Collects the Oracle Installation InformationIPSA     Collects Oracle Communications IP Service Activator InformationJ2EE     Collects J2EE/OC4J InformationJDBC     Collects Oracle Java DB Connectivity (JDBC) InformationJDEV     Collects Oracle JDeveloper InformationJIVE     Collects Jive InformationLANG     Collects Oracle Language InformationLOAD     Produces the External Collection ReportsLOG      Collects Database Trace and Log FilesMAIL     Collects Oracle Collaboration Suite Mail InformationMSLG     Collects Microsoft Languages InformationND       Collects Oracle Communications Network Discovery InformationNET      Collects Network InformationNM       Collects Oracle Communications Network Mediation InformationNPRF     Samples Performance Information (root not required)OCAL     Collects Oracle Calendar InformationOCFS     Collects Oracle Cluster File System InformationOCM      Setting up Configuration Manager InterfaceOCS      Controls Oracle Collaboration Suite Data CollectionODI      Collects Oracle Data Integrator InformationODM      Collects Oracle Data Mining InformationOES      Collects Oracle Express Server InformationOID      Collects Oracle Internet Directory InformationOIM      Collects Oracle Identity Manager InformationOLAP     Collects OLAP InformationOMM      Collects Oracle Multimedia or Oracle interMedia InformationOMS      Collects Oracle Management Server Information (obsolete)ONET     Collects Oracle Net InformationOS       Collects the Operating System InformationOVD      Collects Oracle Virtual Directory InformationOVMM     Collects Oracle VM Manager InformationOVMS     Collects Oracle VM Server InformationOWB      Collects Oracle Warehouse Builder InformationOWSM     Collects Oracle Web Services Manager InformationPDA      Collects Oracle Portal InformationPDBA     Collects PeopleSoft Information from an Oracle DatabasePERF     Collects Performance InformationPLNC     Collects Oracle PL/SQL Native Compilation InformationPROF     Collects the User ProfilePS       Collects Oracle Communications Policy Services InformationPWEB     Collects PeopleSoft Information from Web Application ServerRAC      Collects Cluster InformationRACD     Performs a Database Hang AnalysisRDSP     Produces the Remote Data Collection ReportsRET      Collects Oracle Retail InformationREXE     Performs the Remote Data CollectionsRPRF     Samples Performance Information (root privileges required)RSRC     Collects Database Resource Manager InformationRTC      Collects Real Time Communication InformationSEBL     Collects Siebel InformationSES      Collects Oracle Secure Enterprise Search InformationSMPL     Controls SamplingSOA      Collects Oracle SOA Suite InformationSP       Collects SQL*Plus/iSQL*Plus InformationSSO      Collects Single Sign-On InformationSTC      Collects Streams Configuration InformationSTM      Collects Streams Monitoring InformationTOPL     Collects Oracle TopLink InformationTTEN     Collects Oracle TimesTen In-Memory Database InformationUCM      Collects Oracle Universal Content Management InformationUOA      Collects Oracle Universal Online Archive 11g InformationWAC      Collects Web Access Client InformationWCI      Collects Oracle WebCenter InformationWEBC     Collects Oracle Web Cache InformationWKSP     Collects Workspaces InformationWLS      Collects Oracle WebLogic Server InformationWMC      Collects Webmail Client InformationWRLS     Collects Wireless InformationXDB      Collects XDB InformationXSMP     Samples User Defined DataXTRA     Collects User Defined Data

    如以上列表中RAC模块用来Collects Cluster Information收集集群信息， 而RACD模块则负责收集RAC数据库挂起的相关信息Performs a Database Hang Analysis。   我们在配置RDA的时可以直接执行./rda.sh， 脚本会提示我们需要选择启用哪些Module，但是因为Module过多，整个配置过程就会浪费很多时间。   为了避免每配置一套新环境都要大费周章确认那么多模块， 所以在RDA中定义了很多典型场景使用的profile， 这些profile已经配好了固定的一些Module ， 下面我们来看一下RDA profile:    

列出所有目前可用的profile[oracle@vrh8 rda]$ ./rda.sh -L profiles
Available profiles are:9iAS               Oracle Application Server 9i problemsAS10g              Oracle Application Server 10g problemsAS10g_Identity     Oracle Identity Management 10g problemsAS10g_MidTier      Oracle Application Server 10g Middle Tier problemsAS10g_Repository   Oracle Application Server 10g metadata repository problemsAS10g_WebTier      Oracle Application Server 10g WebTier problemsAS_BackupRecovery  Oracle Application Server backup/recovery problemsAct                Oracle Application OverviewAppsCheck          Equivalent to AppsCheckAsmFileSystem      Oracle ASM Cluster File System problemsBam                Business Activity Monitoring problemsBeehive            Oracle Beehive problemsDB10g              Oracle Database 10g problemsDB11g              Oracle Database 11g problemsDB8i               Oracle Database 8i problemsDB9i               Oracle Database 9i problemsDB_Assessment      Oracle Database assessment collectionsDB_BackupRecovery  Oracle Database backup and recovery problemsDB_Perf            Oracle Database performance problemsDataGuard          Data Guard problemsDirectNFS          Direct NFS problemsDiscoverer10g      Oracle Discoverer 10g problemsDiscoverer11g      Oracle Discoverer 11g problemsEnterpriseSearch   Oracle Secure Enterprise Search problemsEssbase            Oracle Essbase problemsFM11g_Bi           Business Intelligence Enterprise Edition 11g problemsFM11g_Ecm          Oracle Enterprise Content Management 11g problemsFM11g_Forms        Oracle Forms 11g problemsFM11g_Identity     Oracle Identity Management 11g problemsFM11g_Odi          Oracle Data Integrator Standalone 11g problemsFM11g_Portal       Oracle Portal 11g problemsFM11g_Reports      Oracle Reports 11g problemsFM11g_Soa          Oracle SOA Suite 11g problemsFM11g_WebTier      Oracle Fusion Middleware 11g Web Tier problemsFM11g_WlsBi        Business Intelligence Enterprise Edition 11g with WLSFM11g_WlsForms     Oracle Forms 11g with WLS problemsFM11g_WlsIdentity  Oracle Identity Management 11g with WLS problemsFM11g_WlsOdi       Oracle Data Integrator Suite 11g with WLS problemsFM11g_WlsPortal    Oracle Portal 11g with WLS problemsFM11g_WlsReports   Oracle Reports 11g with WLS problemsFM11g_WlsWebTier   Oracle Fusion Middleware 11g Web Tier with WLS problemsFinManagement      Oracle Hyperion Financial Management problemsGridControl        Grid Control problemsInterMedia         Oracle interMedia problemsLinux              Linux problemsLinuxPerf          Linux performance problemsMaa_Assessment     Maximum Availability Architecture assessment collectionsMultimedia         Oracle Multimedia problemsOSMonitor          Operating System performance samplingOVMManager         Oracle VM Manager problemsPda10g             Portal 10g problemsPda11g             Portal 11g problemsPda9i              Portal 9i problemsPeopleSoft_DB      PeopleSoft Oracle Database tier assessment collectionsPeopleSoft_Web     PeopleSoft Web application server assessment collectionsRac                Real Application Cluster problemsRac_AdvancedAsm    Cluster with ASM problems (ASM advanced mode)Rac_Asm            Cluster with ASM problemsRac_Assessment     Real Application Cluster assessment collectionsRac_Perf           Cluster performance problemsRetail             Oracle Retail problemsSecurity           Filter sensitive information from the reportsSupportInformer70  Oracle Communication BRM 7.0 problemsSupportInformer72  Oracle Communication BRM 7.2 problemsSupportInformer73  Oracle Communication BRM 7.3 problemsSupportInformer74  Oracle Communication BRM 7.4 problemsTimesTen           Oracle TimesTen problemsTopLink10g         Oracle TopLink 10g problemsWebCenter10g       Oracle WebCenter 10g problemsWebCenter11g       Oracle WebCenter 11g problemsWebCenterCont10g   Oracle WebCenter 10g with Oracle Content Services problemsWebLogicServer     Oracle WebLogic Server problems

    上例列出了该版本RDA默认就有的Profile ， 如DB11g这个profile是用来收集11g Database数据库的诊断信息的， 而DB10g 是收集10g Database诊断信息的， DB_Perf是收集数据库性能诊断信息的。 可以具体了解 这些profile 预设了哪些Module:    

[oracle@vrh8 rda]$ ./rda.sh -M -p DB11g
NAMEProfile DB11g - Oracle Database 11g problemsMODULESThe DB11g profile uses the following modules:OS        Collects the Operating System InformationPROF      Collects the User ProfilePERF      Collects Performance InformationNET       Collects Network InformationONET      Collects Oracle Net InformationINST      Collects the Oracle Installation InformationDB        Controls RDBMS Data CollectionDBA       Collects RDBMS InformationDBM       Collects RDBMS Memory InformationLOG       Collects Database Trace and Log FilesDNFS      Collects Direct NFS InformationSP        Collects SQL*Plus/iSQL*Plus InformationGRID      Controls Grid Control Data CollectionAGT       Collects Enterprise Manager Agent InformationDBC       Collects Database Control Information[oracle@vrh8 rda]$ ./rda.sh -M -p DB10g
NAMEProfile DB10g - Oracle Database 10g problemsMODULESThe DB10g profile uses the following modules:OS        Collects the Operating System InformationPROF      Collects the User ProfilePERF      Collects Performance InformationNET       Collects Network InformationONET      Collects Oracle Net InformationINST      Collects the Oracle Installation InformationDB        Controls RDBMS Data CollectionDBA       Collects RDBMS InformationDBM       Collects RDBMS Memory InformationLOG       Collects Database Trace and Log FilesSP        Collects SQL*Plus/iSQL*Plus InformationGRID      Controls Grid Control Data CollectionAGT       Collects Enterprise Manager Agent InformationDBC       Collects Database Control Information

    除了module之外profile可能还定义了一些临时变量如force_onet_tests 是否强制做oracle net网络测试等， 可以用-f( Set force mode)选项来列出这些temporary settings：    

[oracle@vrh8 rda]$ ./rda.sh -fM -p DB10g
NAMEProfile DB10g - Oracle Database 10g problemsMODULESThe DB10g profile uses the following modules:OS        Collects the Operating System InformationPROF      Collects the User ProfilePERF      Collects Performance InformationNET       Collects Network InformationONET      Collects Oracle Net InformationINST      Collects the Oracle Installation InformationDB        Controls RDBMS Data CollectionDBA       Collects RDBMS InformationDBM       Collects RDBMS Memory InformationLOG       Collects Database Trace and Log FilesSP        Collects SQL*Plus/iSQL*Plus InformationGRID      Controls Grid Control Data CollectionAGT       Collects Enterprise Manager Agent InformationDBC       Collects Database Control InformationSETTINGSThe DB10g profile sets the following temporary settings:force_db_tests=1force_dba_tests=1force_dbm_tests=1force_log_tests=1force_onet_tests=1

    也可以列出全部预定义的profile的Module信息:    

[oracle@vrh8 rda]$ ./rda.sh -xv profiles
Treating profiles ...
Profile Cross ReferenceDefined Profiles:9iAS               S100OS, S105PROF, S110PERF, S120NET, S130INST, S300IAS,S305ASBR, S306ASG, S310J2EE, S330SSO, S340OID, S350WEBCAS10g              S100OS, S105PROF, S110PERF, S120NET, S130INST, S300IAS,S305ASBR, S306ASG, S310J2EE, S330SSO, S340OID, S350WEBCAS10g_Identity     S100OS, S105PROF, S110PERF, S120NET, S130INST, S300IAS,S305ASBR, S306ASG, S310J2EE, S330SSO, S340OID, S342OVDAS10g_MidTier      S100OS, S105PROF, S110PERF, S120NET, S130INST, S249WRLS,S290DEV, S300IAS, S310J2EE, S325PDA, S350WEBC, S390DSCVAS10g_Repository   S100OS, S105PROF, S110PERF, S120NET, S130INST, S300IAS,S305ASBR, S306ASG, S310J2EEAS10g_WebTier      S100OS, S105PROF, S110PERF, S120NET, S130INST, S300IAS,S310J2EE, S350WEBC, S410GRIDAS_BackupRecovery  S100OS, S300IAS, S305ASBRAct                S100OS, S105PROF, S110PERF, S130INST, S500ACTAppsCheck          S100OS, S105PROF, S110PERF, S130INST, S500ACTAsmFileSystem      S100OS, S105PROF, S120NET, S122ONET, S130INST, S402ASM,S403ACFSBam                S100OS, S105PROF, S110PERF, S120NET, S374BAM
..........

      使用-Q 选项可以更详细地列出profile相关的问题：    

[oracle@vrh8 rda]$ ./rda.sh -Q -p DB11gNAMES120NET - Collects Network InformationSETTING DESCRIPTIONNETWORK_PING_TESTS"Do you want RDA to perform the network ping tests (Y/N)?"LOCAL_NODE"Enter the name of the node the script is running on (used for pingtests)"WAN_NODE"Enter a remote node connecting to this server (used for ping tests)"RDBMS_NODE"Enter the node hosting the database instance (used for ping tests)"WEB_NODE"Enter the node where the Web Server/Forms server is on (used for pingtests)"...............

    通过继承profile的定义可以快速配置RDA，例如我们尝试使用DB11g这个profile:    

[oracle@vrh8 rda]$ ./rda.sh -S -p DB11g使用profile后RDA问你的问题明显减少了哦之后在运行rda.sh就会收集信息了[oracle@vrh8 rda]$ ./rda.sh
-------------------------------------------------------------------------------
RDA Data Collection Started 06-Feb-2012 01:23:22
-------------------------------------------------------------------------------
Processing Initialization module ...
Enter the password for 'SYSTEM':
Please re-enter it to confirm:
Processing OCM module ...
Processing PERF module ...
Processing CFG module ...
Processing OS module ..

    可能你还是觉得麻烦："我使用oracle操作系统用户登录的，为啥每次还要输密码呢？直接sysdba不行吗？" 对于有些内部视图X$ View的查询也确实需要sysdba权限， 我们可以如下设置来使用sysdba身份：  

[oracle@vrh8 rda]$ ./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB11g[oracle@vrh8 rda]$ ./rda.sh
-------------------------------------------------------------------------------
RDA Data Collection Started 06-Feb-2012 01:27:37
-------------------------------------------------------------------------------
Processing Initialization module ...
Processing OCM module ...
Processing PERF module ...
Processing CFG module ...
Processing OS module ...

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

[oracle@vrh8 rda]$ ./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB11g-DataGuard使用-p profile1-profile2这样的模式即可

    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
# S110PERF=pending
# S120NET=pending
# S122ONET=pending
# S130INST=pending
# S200DB=skip
# S201DBA=pending
# S203DBM=pending
# S204LOG=pending
# S205BR=pending
# S212DNFS=skip
# S213SP=skip
# S400RAC=pending
# S400RACD=skip
# S401OCFS=skip
# S405DG=pending
# S410GRID=skip
# S420AGT=skip
# S430DBC=skip
# S909RDSP=skip
# S919LOAD=pending
# S990FLTR=skip
www.oracledatabase12g.com
www.askmaclean.com
# S999END=pending
.................

    除了最常见的DB11g 、 DB10g外还有一些很有用的profile可以加速我们对问题的诊断， 在这里分享一下：    

For 11g./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB11g./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p DB11g
--收集alert文本./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1,DBCONTROL_SERVER_IN_USE=1 -p DB11g
--收集DBcontrol信息./rda.sh -vSCRPfy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p DB11g
--收集诊断信息并打包DB10g ./rda.sh -S -p DB10g./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB10g./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,DBCONTROL_SERVER_IN_USE=1 -p DB10gDB9i./rda.sh -S -p DB9i./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB9iDB_BackupRecovery 收集备份恢复信息./rda.sh -S -p DB_BackupRecovery./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,RMAN_IN_USE=0 -p DB_BackupRecovery
--不使用RMAN备份./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,RMAN_IN_USE=1,RMAN_CATALOG=0 -p DB_BackupRecovery
--使用RMAN但不使用CATALOG恢复目录./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,RMAN_IN_USE=1,RMAN_CATALOG=1,RMAN_SCHEMA=rman,RMAN_EXPORT_USER=rman@catlogdb -p DB_BackupRecoveryDB_Perf 收集数据库性能信息./rda.sh -S -p DB_Perf./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DB_Perf./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,PERF_START_TIME=11-Mar-2010_12:00,PERF_END_TIME=11-Mar-2010_13:00 -p DB_Perf
--指定收集性能信息的时间段 DataGuard 收集dg 信息./rda.sh -S -p DataGuard./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DataGuard./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ONET_IN_USE=1,ALERT_TEXT=1 -p DataGuard
--同时也收集Oracle Net Services信息RAC 收集Real Application Cluster CRS信息./rda.sh -S -p Rac./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p RacRAC ASM   收集 Rac + Clusterware + Asm 信息./rda.sh -S -p Rac_Asm./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ASM_ORACLE_SID=+ASM1 -p Rac_AsmRac_AdvancedAsm 收集更详细的Rac + Clusterware + Asm 信息./rda.sh -S -p Rac_AdvancedAsm./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ASM_ORACLE_SID=+ASM1 -p Rac_AdvancedAsmRac_Perf  收集RAC数据库性能信息./rda.sh -S -p Rac_Perf./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p Rac_Perf./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,PERF_START_TIME=11-Mar-2010_12:00,PERF_END_TIME=11-Mar-2010_13:00 -p Rac_PerfDirectNFS ./rda.sh -S -p DirectNFS./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p DirectNFSAsmFileSystem./rda.sh -S -p AsmFileSystem./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p AsmFileSystemDB_Assessment ./rda.sh -S -p Rac_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p Rac_AssessmentRac_Assessment./rda.sh -S -p Rac_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p Rac_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ASM_ORACLE_SID=+ASM1 -p Rac_AssessmentMaa_Assessment./rda.sh -S -p Maa_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/ -p Maa_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ASM_ORACLE_SID=+ASM1 -p Maa_AssessmentExadata_Assessment./rda.sh -S -p Exadata_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p Exadata_Assessment./rda.sh -vSCRPfy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1,EXA_COLLECT_CELL=0 -p Exadata_Assessment./rda.sh -vSCRPfy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p Exadata_AssessmentMaa_Exa_Assessment./rda.sh -S -p Maa_Exa_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p Maa_Exa_Assessment./rda.sh -Sy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1,EXA_COLLECT_CELL=0 -p Maa_Exa_Assessment./rda.sh -vSCRPfy -e SQL_SYSDBA=1,SQL_LOGIN=/,ALERT_TEXT=1 -p Maa_Exa_Assessment

      还可以利用rda对OS做数据库软件安装前的预检查，如将需要安装11.2g,则执行 ./rda.sh -T hcve：    

[oracle@vrh8 rda]$ ./rda.sh -T hcve
Processing HCVE tests ...
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux-x86)
2. Oracle Database 10g R1 (10.1.0) Preinstall (Linux AMD64)
3. Oracle Database 10g R1 (10.1.0) Preinstall (IA-64 Linux)
4. Oracle Database 10g R2 (10.2.0) Preinstall (Linux AMD64)
5. Oracle Database 10g R2 (10.2.0) Preinstall (IA-64 Linux)
6. Oracle Database 10g R2 (10.2.0) Preinstall (Linux-x86)
7. Oracle Database 11g R1 (11.1.0) Preinstall (Linux AMD64)
8. Oracle Database 11g R1 (11.1.0) Preinstall (Linux-x86)
9. Oracle Database 11g R2 (11.2.0) Preinstall (Linux-x86)
ID     NAME                 RESULT  VALUE
====== ==================== ======= ==========================================
A00010 OS Certified?        PASSED  Adequate
A00050 Enter ORACLE_HOME    RECORD  /s01/oracle/product/10.2.0/db_1
A00060 ORACLE_HOME Valid?   PASSED  OHexists
A00070 O_H Permissions OK?  PASSED  CorrectPerms
A00080 oraInventory Permiss PASSED  oraInventoryOK
A00090 Got ld,nm,ar,make?   PASSED  ld_nm_ar_make_found
A00100 Umask Set to 022?    PASSED  UmaskOK
A00120 Limit Processes      PASSED  Adequate
A00130 Limit Descriptors    PASSED  Adequate
A00140 LDLIBRARYPATH Unset? PASSED  UnSet
A00180 JAVA_HOME Unset?     PASSED  UnSet
A00190 Enter JDK Home       RECORD
A00200 JDK Version          FAILED  JDK home is missing
A00210 Other O_Hs in PATH?  FAILED  OratabEntryInPath
A00220 Other OUI Up?        PASSED  NoOtherOUI
A00230 /tmp Adequate?       PASSED  TempSpaceOK
A00240 Disk Space OK?       PASSED  DiskSpaceOK
A00250 Swap (in MB)         RECORD  5951
A00260 RAM (in MB)          PASSED  3955
A00270 Swap OK?             PASSED  SwapToRAMOK
A00280 Network              PASSED  Connected
A00290 IP Address           RECORD  192.168.1.191
A00300 Domain Name          RECORD  oracle.com
A00310 DNS Lookup           FAILED  nslookup host.domain
A00320 /etc/hosts Format    FAILED  Missing host.domain
A00330 Kernel Parameters OK PASSED  KernelOK
A00380 Tainted Kernel?      PASSED  NotVerifiable
A00400 ip_local_port_range  PASSED  RangeOK
A00480 EL4 RPMs OK?         SKIPPED NotEL4
A00490 EL5 RPMs OK?         FAILED  [kernel-headers(i386)] not installed ..>
A00530 RHEL4 RPMs OK?       SKIPPED NotRedHat
A00540 RHEL5 RPMs OK?       SKIPPED NotRedHat
A00570 SUSE SLES10 RPMs OK? SKIPPED NotSuSE
A00580 SUSE SLES11 RPMs OK? SKIPPED NotSuSE
Result file: /home/oracle/rda/output/RDA_HCVE_A200DB11R2_lnx_res.htm

    上例对OS做了Oracle Database 11g R2 (11.2.0) Preinstall的预安装检查 ，并给出了检查结果。       还可以使用./rda.sh命令对现有的RDA软件做完整性检测，保证RDA没有被修改过:    

[oracle@vrh8 rda]$ ./rda.sh -cv
Loading the file list ...
Checking the directory '.' ...
Checking the directory 'RDA' ...
Checking the directory 'RDA/Handle' ...
Checking the directory 'RDA/Library' ...
Checking the directory 'RDA/Library/Remote' ...
Checking the directory 'RDA/Local' ...
Checking the directory 'RDA/Object' ...
Checking the directory 'RDA/Operator' ...
Checking the directory 'RDA/Value' ...
Checking the directory 'hcve' ...
Checking the directory 'modules' ...
No issues found