Oracle数据库信息收集工具RDA使用指南

OracleRDA使用指南“://service.hundsun/bbs/space/viewspacepost.aspx?postid=65“://service.hundsun/bbs/space/viewspacepost.aspx?postid=65RDA是RemoteDiagnosticAgent的简称，是用来收集、分析oracle数据库的工具，运行该工具不会转变系统的任何参数，RDA收集的相关数据格外全面，可以简化我们日常监控RDA样可以为快速解决问题供给一个有力的保证。一、支持的操作系统IBMIBMAIXIntelLinux〔RedHatandSuSE〕HP-UX〔10.*and11.*〕HPTru64SequentDynix/PtxSunSolaris〔2.6-2.10〕WindowsXPProfessionalWindows2000WorkstationandServerWindows2003ServerOracle产品OracleRDBMSServer〔StandardandEnterpriseEditions，适用任意版本〕OracleRACCluster〔只需要在其中一个节点收集即可〕三、主要用于诊断数据库以下问题性能、安装、配置、升级、移植以及内部错误问题。四、RDA的安装及信息收集RDA下载地址：地址：Ftp://62/EAS客户问题诊断/工具/ORACLE工具包名：rda_4.8-070607.tar.gzRDA安装、配置：rdadwindows环境命令，rda.shlinux/unix1、工具包下载完后如在linux、unix下使用，不要在window操作系统下做解压缩，脚本的文件格式会破坏。2、ftp上传是承受二进制方式。3、执行解压缩命令#tar#tarxvfrda_4.8-070607.tar.gz#chown–Roracle:dba./rda//rda属主为Oracle用户windows下直接通过winrar等压缩软件解压4、在解压缩后的名目下执行./rda.sh〔rdad〕-c测试是否正常5、在数据库创立用户下执行〔一般即为oracle用户〕RDA配置exportexportORACLE_SID=easnm〔生产库或测试库实例名windowsseteasnm〔生产库或测试库实例名〕./rda.sh〔rdad〕-S//第一次配置前面始终回车，始终到提示输入system用户密码，提示如下：输入密码后回车，(也可以直接输入‘/’,此时默认为sysdba，不用输入密码)，此时需要输入Y，再回车。向导后续会让你答复当前数据库的假设干问题Y/rda名目下会生成配置文件setup.cfgsetup.bakRDA命令重配置〔./rda.sh〔rdad〕-Sf〕RDA信息采集安装配置完毕后开头采集数据：./rda.sh./rda.sh〔rdad〕-v在采集过程中有可能需要你输入数据库相关用户的密码，输入即可，通常不用输。采集完成后，在rda名目下依据初始配置文件会生成格式为zip的报告文件以及采集日志，默认文件位置为./output/RDA.$machine_name.zipftp取出后发送到总部研发ftp效劳〔即RDA工具下载地址解压缩该文件访问<report_group> start.htm，可以看到这次采集的数据的具体信息使用时留意：1、有时不能生成zip格式的报告文件，这跟客户端是否安装压缩工具有关，需要自行解压缩相关报告文件。2、假设需要再次采集，掩盖已生成的报告文件，执行命令：./rda.sh〔rdad〕-vf3、假设需要重配置，再次采集信息，生成报告文件，执行命令：./rda.sh〔rdad〕-SvfRDA采集数据内容〔初始参数、运行大事、日常监控等〕在日常的维护当中，我们主要1、关注RDBMS下的几个统计信息。DatabaseSPFileParametersspfile中数据库相关初始参数的设置SGAInformation查看系统全局区当前内存信息SessionsandProcesses采集时间内的数据库会话相关信息V$System_Event数据库实例整个运行期间全部进程大事的等待统计视图V$Session_Wait会话等待大事以及相关定位信息数据LatchInformation竞争相关信息Tablespaces数据库表空间信息〔表空间类型、对应数据文件使用率、是否可扩展等等〕DatabaseFiles数据库对应数据文件信息〔文件位置、使用率等〕InvalidObjects失效的数据库对象，日常监控假设觉察有失效，需要维护人员手工重编译allerrors日常执行的数据库错误在V$System_Event、V$Session_Wait〔bufferbusywaitsdbfilescatteredread、dbfilesequentialreadenqueuefreebufferwaitslatchfreelogfilesynclogfileparallewrite这些大事。2、关注RDBMSLog/TraceFiles的信息alert.log数据库系统级日志lasterrors数据库最近的特别日志、依据trace文件位置，可以查看具体错误信息使用演示1、解压源程序文件到相应名目：E:\rda_4[1].1-051205\rda>dirVolumeindriveEhasnolabel.VolumeSerialNumberisB866-D396DirectoryofE:\rda_4[1].1-051205\rda12/05/200511:09AM<DIR>.12/05/200511:09AM<DIR>..03/28/200509:15PM 4,087DISCLAIM.txt12/05/200511:00AM<DIR>modules12/02/200508:53PM<DIR>RDA11/08/200504:16PM 2,918rda.bat12/05/200511:04AM 26,891rda.pl11/22/200507:59PM 3,017rda.sh11/24/200509:28AM 12,662README_Unix.txt11/24/200509:15AM 12,546README_Windows.txt6File(s) 62,121bytes4Dir(s) 2,722,107,392bytesfree,依据提示选择不同选项E:\rda_4[1].1-051205\rda>rda.bat-SS010CFG:CollectsKeyConfigurationInformationS999END:FinalizestheDataCollectionS000INI:InitializestheDataCollectionTheoutputfileprefixisusedtoeasilyidentifyallfilesbelongingtothesamedatacollection.Itmuststartwithaletterandmayonlycontainalphanumericalcharacters.EntertheprefixforallthefilesgeneratedHit”Return”toacceptthedefault(RDA):dbnewEnterthedirectoryusedforallthefilesgeneratedHit”Return”toacceptthedefault(output):E:\rda_4[1].1-051205\rda\outputDoyouwanttokeepreportpackagesfrompreviousruns(Y/N)?Hit”Return”toacceptthedefault(N):EntertheOracleHometobeanalyzedHit”Return”toacceptthedefault(E:\oracle\product\10.2.0\db_1):EnterthedomainnameofthisserverHit”Return”toacceptthedefault:Warning:NodomainhasbeenspecifiedPress”Enter”toContinueS020SMPL:ControlsSamplingS100OS:CollectstheOperatingSystemConfigurationS105PROF:CollectstheUserProfileS110PERF:CollectsPerformanceInformationS120NET:CollectsNetworkInformationShouldthenetworkpingtestsbeperformed(Y/N)?Hit”Return”toacceptthedefault(N):S125GTW:CollectsTransparent/ProceduralGatewayInformationAreTransparent/ProceduralGatewaysinstalledonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S130INST:CollectstheOracleInstallationInformationS200DB:ControlsRDBMSDataCollectionIsthereadatabaseonthisnodetobeanalyzed?(Y/N)Hit”Return”toacceptthedefault(Y):EntertheOracleSIDtobeanalyzedHit”Return”toacceptthedefault:dbnewIstheINIT.ORAforthedatabasetobeanalyzedlocatedonthismachine?(Y/N)Hit”Return”toacceptthedefault(Y):nEnteranOracleUserID(useridonly)toviewDBA_andV$tablesIfRDAwillberunundertheOraclesoftwareowner”sID,entera”/”here,andselectYattheSYSDBAprompttoavoidbeingpromptedforthedatabasepasswordatruntime.Hit”Return”toacceptthedefault(system):Is”system”asysdbauser(willconnectassysdba)(Y/N)?Hit”Return”toacceptthedefault(N):S201DBA:CollectsRDBMSInformationS204LOG:CollectsDatabaseTraceandLogFilesS205BR:CollectsDatabaseBackup/RecoveryInformationArethebackup/recoveryinformationtobegathered?(Y/N)Hit”Return”toacceptthedefault(N):S210OLAP:CollectsOLAPInformationIsOracleExpressServerinstalledonthismachine?(Y/N)Hit”Return”toacceptthedefault(N):S220IA:CollectsIntelligentAgentInformationIstheOracleIntelligentAgentinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S240MAIL:CollectsEmailServerInformationIstheOracleE-mailServerinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S260OMS:CollectsOMSInformationIstheOracleOEMManagementServerinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S290DEV:CollectsForms/ReportsInformationIsForms/Reportsinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S300IAS:CollectsWebServerInformationAreOracleWebApplicationServer,OracleiAS,Oracle9iAS,orOracleAS10ginstalledandshouldtheybeanalyzed(Y/N)?Hit”Return”toacceptthedefault(Y):EnterthelocationofapacheconfandlogfilesHit”Return”toacceptthedefault(\home\oracle\iasprod\Apache\Apache):Warning:Thespecifieddirectorydoesnot-yet-existsPress”Enter”toContinueEnterthebaseurlforthewebserverHit”Return”toacceptthedefault(://TCSBJ-2MHP12X:7777):EnterthebaseurlorDADtoconnecttodatabaseHit”Return”toacceptthedefault(://TCSBJ-2MHP12X:7777/pls/DAD):ShouldthecompleteDCMrepositorybeanalyzed(Y/N)?Hit”Return”toacceptthedefault(N):S310J2EE:CollectsJ2EEStandaloneInformationIstheOracleJ2EE/OC4Jstandaloneinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S320IFS:CollectsiFS(iFS,CMSDK,Files)InformationIsInternetFileSystem(iFS,CMSDK,Files)installedandshoulditbeanalyzed(Y/N)?Hit”Return”toacceptthedefault(N):S322ECM:CollectsEnterpriseContentManagementInformationShouldEnterpriseContentManagementbeanalyzed(Y/N)?Hit”Return”toacceptthedefault(N):S340OID:CollectsOracleInternetDirectoryInformationIsOracleInternetDirectoryinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S350WEBC:CollectsWebCacheInformationIsOracleWebCacheinuseonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S400RAC:CollectsClusterInformationIsthisbeingrunonaclusteredenvironment(Y/N)?Hit”Return”toacceptthedefault(N):S410GRID:CollectsGridInformationIstheGridcontrolfor10Ginstalledonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S420AGT:CollectsAgentServerInformationIstheCentralAgentfor10Ginstalledonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):S430DBC:CollectsDatabaseControlServerInformationIstheDatabaseControlfor10Ginstalledonthisnode(Y/N)?Hit”Return”toacceptthedefault(N):yEnterthedirectorywhereDatabaseControlisinstalledHit”Return”toacceptthedefault(E:\oracle\product\10.2.0\db_1\TCSBJ-2MHP12X._dbnew):Warning:Thespecifieddirectorydoesnot-yet-existsPress”Enter”toContinueS800NPRF:SamplesPerformanceInformation(rootnotrequired)S801RPRF:SamplesPerformanceInformation(rootprivilegesrequired)S898XSMP:SamplesUserDefinedDataS998XTRA:CollectsUserDefinedDataAtthispoint,itshouldbepossibletocollectthediagnosticinformation.sqlplusshouldconnecttothedatabasewiththeuseridspecifiedduringthesetup.Withthesamecommandusedsofar,startthedatacollection:rda.bat[-v]orperlrda.pl[-v]The-voptionisoptional.Itallowstoseethecollectionprogression.Onceithascompleted,theresultswillbepackagedforsendingittoOracleSupportServices,ifthisfilewasgeneratedtoassistinresolvingaTAR.Selectivedatacollectionisalsopossible.Formoredetails,thecommandusagecanbedisplayedbyspecifyingthe-hoption,orcompletemanualwiththe-Moption.3、开头收集相关信息E:\rda_4[1].1-051205\rda>rda.batRDADataCollectionStarted21-Mar-20072:28:44PMProcessingInitializationmodule...Enterthepasswordfor”SYSTEM”:orac