文档文库
手机版
投诉建议
热门搜索： 心得体会 演讲稿 思想汇报
首页 > Oracle11g新特性实验之一-ADRCI工具使用

Oracle11g新特性实验之一-ADRCI工具使用

发布时间：   来源：文档文库   
小 中 大
字号：
手机查看
Oracle11g新特性实验之一-ADRCI工具使用

Oracle11g新特性实验之一-
ADRCI工具使用

V1.0




Oracle11g新特性实验之一-ADRCI工具使用
目录

1.2.
概述3
基本命令..........................................................................................3
2.1.HELP................................................................................................................32.2.SETHOMES....................................................................................................62.3.SHOWALERT................................................................................................62.4.ADRCI批处理..............................................................................................112.5.SHOWINCIDENT/SHOWPROBLEM.......................................................12
3.4.5.

TRACE打包及解包(IPS............................................................15ADRCI命令列表..........................................................................22参考资料：....................................................................................24


Oracle11g新特性实验之一-ADRCI工具使用
1.概述
ADRCI工具是Oracle11g才推出的新工具，主要用来管理alert文件、trace文件、dump文件、健康监事报告等。
这一篇简单介绍ADRCI工具。
用过11g的人都会发现，11g中alert文件以及trace文件的存放位置都发生了变化。从原来的ORACLE_BASE/admin/INSTANCE_NAME目录变成了ORACLE_BASE/diag/rdbms/DBNAME/INSTANCE_NAME目录。
Oracle之所以修改了这个跨越多个版本都没有修改过的参数设置，就是因为Oracle在11g中推出了ADRCI。这个工具可以统一管理ASM实例和多个数据库实例的alert文件、后台trace文件、用户trace文件，dump文件等等。
而且这个工具可以快速查询错误相关的所有trace文件，并将这些文件打包到一个zip文件，以便将问题相关的信息提供给Oracle的技术支持。
2.基本命令
看一下ADRCI工具的简单命令：
2.1.HELP
[root@scmmsdnl1~]#su-oracle[oracle@scmmsdnl1~]$adrci
ADRCI:Release11.2.0.1.0-Productionon星期五1月1815:08:192013
Copyright(c1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
ADRbase="/u01/app/oracle"adrci>help
HELP[topic]
AvailableTopics:CREATEREPORTECHOEXITHELPHOSTIPSPURGERUN
SETBASESETBROWSERSETCONTROL

Oracle11g新特性实验之一-ADRCI工具使用
SETECHOSETEDITOR
SETHOMES|HOME|HOMEPATHSETTERMOUTSHOWALERTSHOWBASESHOWCONTROLSHOWHM_RUN
SHOWHOMES|HOME|HOMEPATHSHOWINCDIRSHOWINCIDENTSHOWPROBLEMSHOWREPORTSHOWTRACEFILESPOOL
ThereareothercommandsintendedtobeuseddirectlybyOracle,type"HELPEXTENDED"toseethelist
HELP列出了ADRCI工具的所有命令，还可以通过HELP加个别命令的方式来列出这个命令的具体语法，比如：
adrci>HELPIPSHELPIPS[topic]AvailableTopics:ADD
ADDFILE
ADDNEWINCIDENTSCHECKREMOTEKEYSCOPYINFILECOPYOUTFILECREATEPACKAGEDELETEPACKAGEFINALIZEPACKAGEGENERATEPACKAGEGETMANIFESTGETMETADATAGETREMOTEKEYSPACKREMOVE
REMOVEFILE
SETCONFIGURATIONSHOWCONFIGURATIONSHOWFILESSHOWINCIDENTSUNPACKFILE

Oracle11g新特性实验之一-ADRCI工具使用
USEREMOTEKEYSadrci>HELPIPSADDUsage:IPSADD
[INCIDENT|PROBLEM|PROBLEMKEY|SECONDS|TIMETO]PACKAGE
Purpose:Addincidentstoanexistingpackage.Arguments:
:IDofincidenttoaddtopackagecontents.:IDofproblemtoaddtopackagecontents.:Problemkeytoaddtopackagecontents.
:Numberofsecondsbeforenowforaddingpackagecontents.:Startoftimerangetolookforincidentsin.:Endoftimerangetolookforincidentsin.Example:
ipsaddincident22package12adrci>HELPSHOWPROBLEM
Usage:SHOWPROBLEM[-p][-last|-all]
[-orderby(field1,field2,...[ASC|DSC]]
Purpose:Showtheprobleminformation.Bydefault,thiscommandwillonlyshowthelast50problems.Options:
[-p]:Thepredicatestringmustbedouble-quoted.Thefieldnamesthatuserscanspecifyinthepredicateare:PROBLEM_IDnumberPROBLEM_KEYtext(550FIRST_INCIDENTnumberFIRSTINC_TIMEtimestampLAST_INCIDENTnumberLASTINC_TIMEtimestampIMPACT1numberIMPACT2numberIMPACT3numberIMPACT4number
SERVICE_REQUESTtext(64BUG_NUMBERtext(64
[-last|-all]:Thisoptionallowsuserstoeitherselectthelastofqualifiedproblemstoshowortoshowallthequalifiedproblems.Ifthisoptionisnotspecified,thiscommandwillonlyshow50incidents.[-orderby(field1,field2,...[ASC|DSC]]:Ifspecified,theresultswillbeorderedbythespecifiedfields'values.Bydefault,itwillbe

Oracle11g新特性实验之一-ADRCI工具使用
intheascendingorderunless"DSC"isspecified.Notethatthefieldnamesthatcanbespecifiedherearefromthe"PROBLEM"relation.Examples:showproblem
showproblem-p"problem_id>123"
2.2.SETHOMES
在使用前需要设置正确的HOMEPATHadrci>showhomesADRHomes:
diag/asm/+asm/+ASM1
diag/tnslsnr/scmmsdnl1/listener
diag/tnslsnr/scmmsdnl1/listener_scan1adrci>sethomepathdiag/asm/+asm/+ASM2
2.3.SHOWALERT
showalert用于查看log.xml中的信息,格式化成文本格式！adrci>showalert
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
Outputtheresultstofile:/tmp/alert_31940_4751_+ASM1_1.ado2010-03-0813:21:07.947000+08:00StartingORACLEinstance(normalLICENSE_MAX_SESSION=0
LICENSE_SESSIONS_WARNING=0
Interfacetype1eth2192.168.1.0configuredfromGPnPProfileforuseasaclusterinterconnect
Interfacetype1bond010.228.5.0configuredfromGPnPProfileforuseasapublicinterface
SharedmemorysegmentforinstancemonitoringcreatedPickedlatch-freeSCNscheme3
UsingLOG_ARCHIVE_DEST_1parameterdefaultvalueas/u01/app/11.2.0/grid/dbs/arch
Autotuneofundoretentionisturnedon.LICENSE_MAX_USERS=0SYSauditingisdisabled
NOTE:VolumesupportenabledStartingup:

Oracle11g新特性实验之一-ADRCI工具使用
OracleDatabase11gEnterpriseEditionRelease11.2.0.1.0-64bitProduction
WiththeRealApplicationClustersandAutomaticStorageManagementoptions.
Usingparametersettingsinclient-sidepfile
/u01/app/11.2.0/grid/dbs/init+ASM1.oraonmachinescmmsdnl1Systemparameterswithnon-defaultvalues:large_pool_size=12Minstance_type="asm"
remote_login_passwordfile="EXCLUSIVE"asm_power_limit=1
diagnostic_dest="/u01/app/grid"Clustercommunicationisconfiguredtousethefollowinginterface(sforthisinstance192.168.1.1
clusterinterconnectIPCversion:OracleUDP/IP(genericIPCVendor1proto2
PMONstartedwithpid=2,OSid=10829
VKTMstartedwithpid=3,OSid=10831atelevatedpriority
VKTMrunningat(10millisecprecisionwithDBRMquantum(100msGEN0startedwithpid=4,OSid=10835DIAGstartedwithpid=5,OSid=10837PINGstartedwithpid=6,OSid=10839PSP0startedwithpid=7,OSid=10841DIA0startedwithpid=8,OSid=10843
--查看结尾的100行记录
adrci>showalert-tail100
2012-10-1817:12:24.015000+08:00
NOTE:cachemounting(notfirstexternalredundancygroup1/0x59587505(DATA
kjbdomattsendtoinst2
NOTE:attachedtorecoverydomain1
NOTE:LGWRattemptingtomountthread1fordiskgroup1(DATANOTE:LGWRfoundthread1closedatABA25.10331NOTE:LGWRmountedthread1fordiskgroup1(DATA
NOTE:LGWRopeningthread1atfcn0.655847ABA26.10332NOTE:cachemountinggroup1/0x59587505(DATAsucceededNOTE:cacheendingmount(successofgroupDATAnumber=1incarn=0x59587505kfdp_query(DATA:3kfdp_queryBg(:3
NOTE:Instanceupdatedcompatible.asmto11.2.0.0.0forgrp1SUCCESS:diskgroupDATAwasmounted

Oracle11g新特性实验之一-ADRCI工具使用
SUCCESS:ALTERDISKGROUPALLMOUNT/*asmagent*/
SQL>ALTERDISKGROUPALLENABLEVOLUMEALL/*asmagent*/SUCCESS:ALTERDISKGROUPALLENABLEVOLUMEALL/*asmagent*/2012-10-1817:12:26.006000+08:00
WARNING:failedtoonlinediskgroupresourceora.DATA.dg(unabletocommunicatewithCRSD/OHASD
StartingbackgroundprocessASMB
ASMBstartedwithpid=24,OSid=85102012-10-1817:13:29.482000+08:00ALTERSYSTEMSET
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP(HOST=scmmsdnl1_vip(PORT=1521'SCOPE=MEMORYSID='+ASM1';2012-10-2000:04:12.241000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-10-3009:02:36.474000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-11-0117:23:01.291000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-12-1309:41:54.917000+08:00
Reconfigurationstarted(oldinc24,newinc26Listofinstances:1(myinst:1
GlobalResourceDirectoryfrozen
*deadinstancedetected-domain1invalid=TRUECommunicationchannelsreestablished
MasterbroadcastedresourcehashvaluebitmapsNon-localProcessblockscleanedout
LMS0:0GCSshadowscancelled,0closed,0XwsurvivedSetmasternodeinfo
Submittedallremote-enqueuerequestsDwn-cvtsreplayed,VALBLKsdubiousAllgrantableenqueuesgrantedPostSMONtostart1stpassIR
SubmittedallGCSremote-cacherequestsPostSMONtostart1stpassIRFixwriteingcsresourcesReconfigurationcomplete
NOTE:PSTenablingheartbeating(grp1kfdp_query(DATA:4kfdp_queryBg(:4
NOTE:SMONstartinginstancerecoveryforgroupDATAdomain1(mounted

Oracle11g新特性实验之一-ADRCI工具使用
NOTE:F1X0foundondisk0au2fcn0.0
NOTE:startingrecoveryofthread=2ckpt=26.4211group=1(DATANOTE:SMONwaitingforthread2recoveryenqueue
NOTE:SMONabouttobeginrecoverylockclaimsfordiskgroup1(DATANOTE:advancingckptforthread=2ckpt=26.4211
NOTE:SMONdidinstancerecoveryforgroupDATAdomain12012-12-1309:46:35.748000+08:00
Reconfigurationstarted(oldinc26,newinc28Listofinstances:12(myinst:1
GlobalResourceDirectoryfrozenCommunicationchannelsreestablished
MasterbroadcastedresourcehashvaluebitmapsNon-localProcessblockscleanedout
LMS0:0GCSshadowscancelled,0closed,0XwsurvivedSetmasternodeinfo
Submittedallremote-enqueuerequestsDwn-cvtsreplayed,VALBLKsdubiousAllgrantableenqueuesgranted
SubmittedallGCSremote-cacherequestsFixwriteingcsresourcesReconfigurationcomplete
2012-12-1401:41:11.565000+08:00NOTE:ASMclientexited
SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-12-1402:03:04.460000+08:00
NOTE:ASMclientdnldb1:dnldbdisconnectedunexpectedly.NOTE:checkclientalertlog.
NOTE:Processstaterecordedintracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_9158.trc2012-12-1509:47:13.864000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-12-1509:47:16.899000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-12-1510:14:46.467000+08:00
Reconfigurationstarted(oldinc28,newinc30Listofinstances:1(myinst:1
GlobalResourceDirectoryfrozen
*deadinstancedetected-domain1invalid=TRUECommunicationchannelsreestablished

Oracle11g新特性实验之一-ADRCI工具使用
MasterbroadcastedresourcehashvaluebitmapsNon-localProcessblockscleanedout
LMS0:0GCSshadowscancelled,0closed,0XwsurvivedSetmasternodeinfo
Submittedallremote-enqueuerequestsDwn-cvtsreplayed,VALBLKsdubiousAllgrantableenqueuesgrantedPostSMONtostart1stpassIR
SubmittedallGCSremote-cacherequestsPostSMONtostart1stpassIRFixwriteingcsresourcesReconfigurationcompletekfdp_query(DATA:5kfdp_queryBg(:5
NOTE:SMONstartinginstancerecoveryforgroupDATAdomain1(mountedNOTE:F1X0foundondisk0au2fcn0.0
NOTE:startingrecoveryofthread=2ckpt=27.4398group=1(DATANOTE:SMONwaitingforthread2recoveryenqueue
NOTE:SMONabouttobeginrecoverylockclaimsfordiskgroup1(DATANOTE:advancingckptforthread=2ckpt=27.4398
NOTE:SMONdidinstancerecoveryforgroupDATAdomain12012-12-1510:19:15.089000+08:00
Reconfigurationstarted(oldinc30,newinc32Listofinstances:12(myinst:1
GlobalResourceDirectoryfrozenCommunicationchannelsreestablished
MasterbroadcastedresourcehashvaluebitmapsNon-localProcessblockscleanedout
LMS0:0GCSshadowscancelled,0closed,0XwsurvivedSetmasternodeinfo
Submittedallremote-enqueuerequestsDwn-cvtsreplayed,VALBLKsdubiousAllgrantableenqueuesgranted
SubmittedallGCSremote-cacherequestsFixwriteingcsresourcesReconfigurationcomplete
2012-12-1511:28:05.281000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2012-12-2122:05:55.923000+08:00SystemStatedumpedtotracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_diag_8440.trc2013-01-0619:02:39.359000+08:00

Oracle11g新特性实验之一-ADRCI工具使用
NOTE:ASMclientdnldb1:dnldbdisconnectedunexpectedly.NOTE:checkclientalertlog.
NOTE:Processstaterecordedintracefile
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_ora_23338.trc
2.4.ADRCI批处理
除了上面交互式的方式外，还可以调用脚本，或者指定一系列命令来批量执行命令：
[oracle@rac2~]$adrci-helpSyntax:
adrci[-help][script=script_filename]
[exec="one_command[;one_command;...]"]
OptionsDescription(Default
-----------------------------------------------------------------scriptscriptfilename(Nonehelphelponthecommandoptions(Noneexecexecasetofcommands(None-----------------------------------------------------------------[oracle@rac2~]$adrciexec="showbase;showhome;sethomediag/asm/+asm/+ASM2;showalert-tail10"ADRbaseis"/u01/app/oracle"ADRHomes:
diag/tnslsnr/rac2/listenerdiag/rdbms/rac/rac2diag/rdbms/rac1/rac12
diag/clients/user_oracle/host_349980017_80diag/asm/+asm/+ASM2
2013-01-1613:34:49.874000+08:00
NOTE:LGWRopeningthread1atfcn0.9252ABA7.895
NOTE:cachemountinggroup1/0x6098A443(DATAsucceededNOTE:cacheendingmount(successofgroupDATAnumber=1incarn=0x6098a443
GMONqueryinggroup1at4forpid18,osid4264
NOTE:Instanceupdatedcompatible.asmto11.2.0.0.0forgrp1SUCCESS:diskgroupDATAwasmounted
SUCCESS:ALTERDISKGROUPALLMOUNT/*asmagentcallcrs*//*{0:0:2}*/SQL>ALTERDISKGROUPALLENABLEVOLUMEALL/*asmagent*//*{0:0:2}*/SUCCESS:ALTERDISKGROUPALLENABLEVOLUMEALL/*asmagent*//*{0:0:2}*/
2013-01-1613:34:51.686000+08:00
WARNING:failedtoonlinediskgroupresourceora.DATA.dg(unabletocommunicatewithCRSD/OHASD

Oracle11g新特性实验之一-ADRCI工具使用
NOTE:AttemptingvotingfilerefreshondiskgroupDATANOTE:VotingfilerelocationisrequiredindiskgroupDATANOTE:AttemptingvotingfilerelocationondiskgroupDATANOTE:[crsd.bin@rac2(TNSV1-V34315]openingOCRfileStartingbackgroundprocessASMB
ASMBstartedwithpid=25,OSid=4329
NOTE:client+ASM2:+ASMregistered,osid4331,mbr0x02013-01-1613:35:05.961000+08:00
NOTE:clientrac12:rac1registered,osid4804,mbr0x2NOTE:clientrac2:racregistered,osid4805,mbr0x12013-01-1613:35:55.491000+08:00ALTERSYSTEMSET
local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP(HOST=10.228.13.111(PORT=1521'SCOPE=MEMORYSID='+ASM2';2013-01-1810:25:00.040000+08:00
Timedriftdetected.PleasecheckVKTMtracefileformoredetails.
2.5.SHOWINCIDENT/SHOWPROBLEM
在ADRCI众多命令中，比较常用的命令包括SHOWINCIDENT和SHOWPROBLEM。看看这两个命令的使用：adrci>showhomesADRHomes:
diag/asm/+asm/+ASM1
diag/tnslsnr/scmmsdnl1/listener
diag/tnslsnr/scmmsdnl1/listener_scan1adrci>showhomepathADRHomes:
diag/asm/+asm/+ASM1
diag/tnslsnr/scmmsdnl1/listener
diag/tnslsnr/scmmsdnl1/listener_scan1adrci>sethomepathdiag/asm/+asm/+ASM1adrci>showhomepathADRHomes:
diag/asm/+asm/+ASM1
adrci>showincident
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
INCIDENT_IDPROBLEM_KEYCREATE_TIME

Oracle11g新特性实验之一-ADRCI工具使用
--------------------
---------------------------------------------------------------------------------------------------
1601ORA6032010-03-0911:16:52.420000+08:00
7362ORA4452010-04-1410:18:11.287000+08:00
7363ORA4452010-04-2212:52:10.847000+08:00
8002ORA6032010-04-2714:10:24.055000+08:00
12163ORA4452011-07-3019:39:49.828000+08:00
12803ORA6032011-08-0318:48:01.461000+08:00
13604ORA6032012-04-0619:34:33.297000+08:007rowsfetched
adrci>showproblem
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
PROBLEM_IDPROBLEM_KEYLAST_INCIDENTLASTINC_TIME--------------------
-----------------------------------------------------------------------------------------------------------------------
1ORA603136042012-04-0619:34:33.297000+08:00
2ORA445121632011-07-3019:39:49.828000+08:002rowsfetched
Oracle将每次错误信息作为一个INCIDENT，通过SHOWINCIDENT可以很方便的了解alert文件中包含所有的错误信息，以及发生的时间点。
而SHOWPROBLEM的结果更加清晰，它会根据Oracle的错误号，将相同的错误信息合并到一起。通过这个结果，可以了解数据库出现了哪些不同的错误信息。
无论是SHOWPROBLEM、SHOWINCIDENT还是SHOWALERT命令，Oracle都支持定制查询结果，比如只返回ORA-60%错误的PROBLEM：

adrci>showproblem-p"problem_keylike'%60%'"

Oracle11g新特性实验之一-ADRCI工具使用
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
PROBLEM_IDPROBLEM_KEYLAST_INCIDENTLASTINC_TIME--------------------
-----------------------------------------------------------------------------------------------------------------------
1ORA603136042012-04-0619:34:33.297000+08:001rowsfetched
adrci>showincident-modedetail-p"incident_id=13604"
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
**********************************************************INCIDENTINFORECORD1
**********************************************************INCIDENT_ID13604STATUSready
CREATE_TIME2012-04-0619:34:33.297000+08:00PROBLEM_ID1
CLOSE_TIMEFLOOD_CONTROLLEDnoneERROR_FACILITYORAERROR_NUMBER603ERROR_ARG1ERROR_ARG2ERROR_ARG3ERROR_ARG4ERROR_ARG5ERROR_ARG6ERROR_ARG7ERROR_ARG8ERROR_ARG9ERROR_ARG10ERROR_ARG11ERROR_ARG12SIGNALLING_COMPONENTVOSSIGNALLING_SUBCOMPONENTSUSPECT_COMPONENT

Oracle11g新特性实验之一-ADRCI工具使用
SUSPECT_SUBCOMPONENTECIDIMPACTS0
PROBLEM_KEYORA603FIRST_INCIDENT1601
FIRSTINC_TIME2010-03-0911:16:52.420000+08:00LAST_INCIDENT13604
LASTINC_TIME2012-04-0619:34:33.297000+08:00IMPACT10IMPACT20IMPACT30IMPACT40
KEY_NAMEProcIdKEY_VALUE26.137
KEY_NAMEClientProcId
KEY_VALUEoracle@scmmsdnl1.5923_46916835856000OWNER_ID1INCIDENT_FILE
/u01/app/grid/diag/asm/+asm/+ASM1/incident/incdir_13604/+ASM1_o000_5923_i13604.trc
OWNER_ID1INCIDENT_FILE
/u01/app/grid/diag/asm/+asm/+ASM1/trace/+ASM1_o000_5923.trc1rowsfetched
3.trace打包及解包(IPS
数据库日志文件众多，手工打包容易疏漏，使用ADRCI框架的IPS命令，可以将问题相关的trace文件，打包为一个zip文件，以提供给Oracle的支持人员或者其他分析支持人员。
adrci>helpipsHELPIPS[topic]AvailableTopics:ADD
ADDFILE
ADDNEWINCIDENTSCHECKREMOTEKEYSCOPYINFILECOPYOUTFILECREATEPACKAGEDELETEPACKAGE

Oracle11g新特性实验之一-ADRCI工具使用
FINALIZEPACKAGEGENERATEPACKAGEGETMANIFESTGETMETADATAGETREMOTEKEYSPACKREMOVE
REMOVEFILE
SETCONFIGURATIONSHOWCONFIGURATIONSHOWFILESSHOWINCIDENTSUNPACKFILEUSEREMOTEKEYS
IPS包括的命令很多，介绍两种常用的打包方法。最简单的方法莫过于直接使用PACK命令：
adrci>showproblem-p"problem_keylike'%60%'"
ADRHome=/u01/app/grid/diag/asm/+asm/+ASM1:
*************************************************************************
PROBLEM_IDPROBLEM_KEYLAST_INCIDENTLASTINC_TIME--------------------
-----------------------------------------------------------------------------------------------------------------------
1ORA603136042012-04-0619:34:33.297000+08:001rowsfetched
adrci>ipspackproblemin/tmp
Generatedpackage1infile/tmp/IPSPKG_20130118162327_COM_1.zip,modecomplete
另一种方法是利用CREATEPACKAGE命令，然后添加相关的INCIDENT，最后通过GENERATEPACKAGE命令来生成PACKAGE。
adrci>ipscreatepackage
Createdpackage1withoutanycontents,correlationleveltypicaladrci>ipsaddincident13604package1Addedincident13604topackage
……[可以继续更多的problem及incident]adrci>ipsgeneratepackage1in/tmp
Generatedpackage1infile/tmp/IPSPKG_20130118162327_COM_1.zip,modecomplete

Oracle11g新特性实验之一-ADRCI工具使用
最后简单介绍一下UNPACK命令，这个命令可以将得到的zip文件解压到指定目录：
[grid@scmmsdnl1tmp]$adrci
ADRCI:Release11.2.0.1.0-ProductiononFriJan1816:36:312013
Copyright(c1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
ADRbase="/u01/app/grid"
adrci>ipsgetmetadatafromfile/tmp/IPSPKG_20130118162327_COM_1.zipIPSmetadatafromfile/tmp/IPSPKG_20130118162327_COM_1.zip:DIA-48119:errorencounteredwhenattemptingtoremoveafile[./metadata.xml][0]
DIA-48190:OSunlinksystemcallfailure
Linux-x86_64Error:1:OperationnotpermittedAdditionalinformation:1
【必须把packge文件放在有写入权限的目录！】
[grid@scmmsdnl1~]$pwd/home/grid
[grid@scmmsdnl1~]$cdtestdiag/
[grid@scmmsdnl1testdiag]$cp/tmp/IPSPKG_20130118162327_COM_1.zip.[grid@scmmsdnl1testdiag]$pwd/home/grid/testdiag
[grid@scmmsdnl1testdiag]$ls-l总计6140
-rw-r--r--1gridoinstall627411101-1816:37IPSPKG_20130118162327_COM_1.zip[grid@scmmsdnl1testdiag]$adrci
ADRCI:Release11.2.0.1.0-ProductiononFriJan1816:37:592013
Copyright(c1982,2009,Oracleand/oritsaffiliates.Allrightsreserved.
ADRbase="/u01/app/grid"
adrci>ipsgetmetadatafromfile./IPSPKG_20130118162327_COM_1.zipIPSmetadatafromfile./IPSPKG_20130118162327_COM_1.zip:----------------------------------------------------------

Oracle11g新特性实验之一-ADRCI工具使用
1
IPSPKG_20130118162327Complete1
1
2013-01-1816:25:21.258335+08:00/u01/app/grid
/u01/app/grid/diag/asm/+asm/+ASM1asm+asm+ASM1
1
adrci>ipsunpackfile./IPSPKG_20130118162327_COM_1.zipinto/home/grid/testdiag/unpack
Unpackingfile./IPSPKG_20130118162327_COM_1.zipintotarget/home/grid/testdiag/unpack
查看unpack后的文件及目录：
adrci>quit
[grid@scmmsdnl1testdiag]$cdunpack/[grid@scmmsdnl1unpack]$ls-l总计4
drwxrwxr-x3gridoinstall409601-1816:40diag[grid@scmmsdnl1unpack]$find..
./diag
./diag/asm
./diag/asm/+asm
./diag/asm/+asm/+ASM1./diag/asm/+asm/+ASM1/lck
./diag/asm/+asm/+ASM1/lck/AM_2099277876_66242055.lck./diag/asm/+asm/+ASM1/lck/AM_994187642_3287667720.lck./diag/asm/+asm/+ASM1/lck/AM_4123867812_464947195.lck./diag/asm/+asm/+ASM1/lck/AM_117463809_1252689677.lck./diag/asm/+asm/+ASM1/lck/AM_53417_2985279723.lck
./diag/asm/+asm/+ASM1/lck/AM_1477507928_3848095858.lck./diag/asm/+asm/+ASM1/lck/AM_2087871662_4269132395.lck./diag/asm/+asm/+ASM1/lck/AM_1919660852_3200803573.lck./diag/asm/+asm/+ASM1/lck/AM_1737460353_941080040.lck

Oracle11g新特性实验之一-ADRCI工具使用
./diag/asm/+asm/+ASM1/lck/AM_2876149918_855262320.lck./diag/asm/+asm/+ASM1/lck/AM_2569157681_2857696958.lck./diag/asm/+asm/+ASM1/lck/AM_1762885_3826749810.lck./diag/asm/+asm/+ASM1/lck/AM_1618_3044626670.lck
./diag/asm/+asm/+ASM1/lck/AM_1502621355_3638225870.lck./diag/asm/+asm/+ASM1/lck/AM_1744845641_3861997533.lck./diag/asm/+asm/+ASM1/lck/AM_53421_2401899358.lck
./diag/asm/+asm/+ASM1/lck/AM_1096102262_3454819329.lck./diag/asm/+asm/+ASM1/lck/AM_1919660854_3704060414.lck./diag/asm/+asm/+ASM1/lck/AM_3063883707_458774509.lck./diag/asm/+asm/+ASM1/lck/AM_2485072945_164397129.lck./diag/asm/+asm/+ASM1/lck/AM_3219651335_1369860572.lck./diag/asm/+asm/+ASM1/lck/AM_1_2089646048.lck
./diag/asm/+asm/+ASM1/lck/AM_53419_3606358678.lck
./diag/asm/+asm/+ASM1/lck/AM_4294531585_3603614071.lck./diag/asm/+asm/+ASM1/lck/AM_1096102193_3488045378.lck./diag/asm/+asm/+ASM1/lck/AM_2087871759_1054152112.lck./diag/asm/+asm/+ASM1/lck/AM_1762783_4031814035.lck./diag/asm/+asm/+ASM1/lck/AM_423666793_1876373544.lck./diag/asm/+asm/+ASM1/lck/AM_3218196182_2691928421.lck./diag/asm/+asm/+ASM1/lck/AM_1479503217_1058909787.lck./diag/asm/+asm/+ASM1/lck/AM_3216766131_2188903675.lck./diag/asm/+asm/+ASM1/lck/AM_2020575435_1685934094.lck./diag/asm/+asm/+ASM1/lck/AM_3216668543_3129272988.lck./diag/asm/+asm/+ASM1/lck/AM_1521063874_363843526.lck./diag/asm/+asm/+ASM1/lck/AM_2904361128_3186785985.lck./diag/asm/+asm/+ASM1/lck/AM_3172236303_1050790107.lck./diag/asm/+asm/+ASM1/lck/AM_58174112_2445060518.lck./diag/asm/+asm/+ASM1/lck/AM_53417_1688101061.lck
./diag/asm/+asm/+ASM1/lck/AM_1919660852_3403801080.lck./diag/asm/+asm/+ASM1/lck/AM_1506961005_3222638125.lck./diag/asm/+asm/+ASM1/trace
./diag/asm/+asm/+ASM1/trace/+ASM1_ora_10570.trm./diag/asm/+asm/+ASM1/trace/+ASM1_lmon_8599.trm./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8512.trc./diag/asm/+asm/+ASM1/trace/alert_+ASM1.log./diag/asm/+asm/+ASM1/trace/+ASM1_lmd0_8601.trc./diag/asm/+asm/+ASM1/trace/+ASM1_lmd0_8601.trm./diag/asm/+asm/+ASM1/trace/+ASM1_diag_8591.trc./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8512.trm./diag/asm/+asm/+ASM1/trace/+ASM1_dia0_8597.trm./diag/asm/+asm/+ASM1/trace/+ASM1_dia0_8597.trc./diag/asm/+asm/+ASM1/trace/+ASM1_lms0_8606.trc./diag/asm/+asm/+ASM1/trace/+ASM1_o000_5923.trm

Oracle11g新特性实验之一-ADRCI工具使用
./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8370.trm./diag/asm/+asm/+ASM1/trace/+ASM1_gmon_8624.trc./diag/asm/+asm/+ASM1/trace/+ASM1_rbal_8622.trc./diag/asm/+asm/+ASM1/trace/+ASM1_ora_10570.trc./diag/asm/+asm/+ASM1/trace/+ASM1_gmon_8624.trm./diag/asm/+asm/+ASM1/trace/+ASM1_diag_8591.trm./diag/asm/+asm/+ASM1/trace/+ASM1_o000_5923.trc./diag/asm/+asm/+ASM1/trace/+ASM1_rbal_8622.trm./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8521.trc./diag/asm/+asm/+ASM1/trace/+ASM1_lms0_8606.trm./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8370.trc./diag/asm/+asm/+ASM1/trace/+ASM1_lmon_8599.trc./diag/asm/+asm/+ASM1/trace/+ASM1_ora_8521.trm./diag/asm/+asm/+ASM1/alert
./diag/asm/+asm/+ASM1/alert/log.xml./diag/asm/+asm/+ASM1/cdump./diag/asm/+asm/+ASM1/incident
./diag/asm/+asm/+ASM1/incident/incdir_13604
./diag/asm/+asm/+ASM1/incident/incdir_13604/+ASM1_o000_5923_i13604.trm
./diag/asm/+asm/+ASM1/incident/incdir_13604/+ASM1_o000_5923_i13604.trc
./diag/asm/+asm/+ASM1/metadata
./diag/asm/+asm/+ASM1/metadata/HM_INFO.ams./diag/asm/+asm/+ASM1/metadata/AMS_XACTION.ams
./diag/asm/+asm/+ASM1/metadata/DDE_USER_ACTION_PARAMETER_DEF.ams./diag/asm/+asm/+ASM1/metadata/HM_FDG_SET.ams
./diag/asm/+asm/+ASM1/metadata/INC_METER_INFO.ams./diag/asm/+asm/+ASM1/metadata/INC_METER_CONFIG.ams
./diag/asm/+asm/+ASM1/metadata/IPS_PACKAGE_UNPACK_HISTORY.ams./diag/asm/+asm/+ASM1/metadata/EM_DIAG_JOB.ams./diag/asm/+asm/+ASM1/metadata/IPS_PACKAGE.ams
./diag/asm/+asm/+ASM1/metadata/INC_METER_SUMMARY.ams
./diag/asm/+asm/+ASM1/metadata/DDE_USER_INCIDENT_ACTION_MAP.ams./diag/asm/+asm/+ASM1/metadata/INCCKEY.ams./diag/asm/+asm/+ASM1/metadata/VIEWCOL.ams
./diag/asm/+asm/+ASM1/metadata/IPS_PACKAGE_INCIDENT.ams./diag/asm/+asm/+ASM1/metadata/DDE_USER_ACTION_DEF.ams./diag/asm/+asm/+ASM1/metadata/INC_METER_IMPT_DEF.ams./diag/asm/+asm/+ASM1/metadata/IPS_PACKAGE_HISTORY.ams./diag/asm/+asm/+ASM1/metadata/PROBLEM.ams./diag/asm/+asm/+ASM1/metadata/SWEEPERR.ams
./diag/asm/+asm/+ASM1/metadata/EM_TARGET_INFO.ams./diag/asm/+asm/+ASM1/metadata/ADR_CONTROL.ams

Oracle11g新特性实验之一-ADRCI工具使用
./diag/asm/+asm/+ASM1/metadata/INCIDENT.ams
./diag/asm/+asm/+ASM1/metadata/EM_USER_ACTIVITY.ams./diag/asm/+asm/+ASM1/metadata/HM_FINDING.ams
./diag/asm/+asm/+ASM1/metadata/INC_METER_PK_IMPTS.ams./diag/asm/+asm/+ASM1/metadata/INCIDENT_FILE.ams./diag/asm/+asm/+ASM1/metadata/IPS_FILE_COPY_LOG.ams./diag/asm/+asm/+ASM1/metadata/ADR_INVALIDATION.ams./diag/asm/+asm/+ASM1/metadata/IPS_CONFIGURATION.ams./diag/asm/+asm/+ASM1/metadata/HM_MESSAGE.ams./diag/asm/+asm/+ASM1/metadata/PICKLEERR.ams
./diag/asm/+asm/+ASM1/metadata/DDE_USER_ACTION_PARAMETER.ams./diag/asm/+asm/+ASM1/metadata/DDE_USER_ACTION.ams./diag/asm/+asm/+ASM1/metadata/HM_RECOMMENDATION.ams
./diag/asm/+asm/+ASM1/metadata/DDE_USER_INCIDENT_TYPE.ams./diag/asm/+asm/+ASM1/metadata/VIEW.ams
./diag/asm/+asm/+ASM1/metadata/IPS_REMOTE_PACKAGE.ams./diag/asm/+asm/+ASM1/metadata/IPS_PACKAGE_FILE.ams./diag/asm/+asm/+ASM1/metadata/IPS_FILE_METADATA.ams./diag/asm/+asm/+ASM1/metadata/HM_RUN.ams./diag/asm/+asm/+ASM1/incpkg
./diag/asm/+asm/+ASM1/incpkg/pkg_1
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/INCCKEY.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/PROBLEM.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/EM_USER_ACTIVITY.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_FILE_METADATA.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_ACTION_DEF.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_HISTORY.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/HM_RUN.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_PACKAGE.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_INCIDENT_ACTION_MAP.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_INCIDENT.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_INCIDENT_TYPE.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_ACTION.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_ACTION_PARAMETER.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_FILE_COPY_LOG.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/INCIDENT.dmp

Oracle11g新特性实验之一-ADRCI工具使用
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_CONFIGURATION.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/IPS_PACKAGE_FILE.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/DDE_USER_ACTION_PARAMETER_DEF.dmp
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/export/INCIDENT_FILE.dmp./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/metadata.xml
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/manifest_1_1.html./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/config.xml
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/manifest_1_1.txt./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/manifest_1_1.xml./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/evmd.log./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/evtf.log./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/crsd.l06./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/oclskd.log./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/crsdiag.log
./diag/asm/+asm/+ASM1/incpkg/pkg_1/seq_1/crs/alertscmmsdnl1.log./diag/asm/+asm/+ASM1/ir./diag/asm/+asm/+ASM1/stage./diag/asm/+asm/+ASM1/sweep./diag/asm/+asm/+ASM1/hm
4.ADRCI命令列表
Table16-2ListofADRCIcommands
Command
Description
CREATEREPORT
CreatesareportforthespecifiedreporttypeandID.Echoestheinputstring.ExitsthecurrentADRCIsession.
ExecutesoperatingsystemcommandsfromADRCI.
InvokestheIPSutility.SeeTable16-3fortheIPScommandsavailablewithinADRCI.
ECHOEXITHOSTIPS
QUITRUN
ExitsthecurrentADRCIsession.RunsanADRCIscript.
SETBASESetstheADRbaseforthecurrentADRCIsession.

Oracle11g新特性实验之一-ADRCI工具使用
CommandDescription
SETBROWSERSETCONTROLSETECHO
Reservedforfutureuse.
SetpurgingpoliciesforADRcontents.Togglescommandoutput.
SETEDITOR
Setsthedefaulteditorfordisplayingtraceandalertlogcontents.
SETHOMEPATHMakescurrentoneormoreADRhomes.SETTERMOUTSHOWALERTSHOWBASE
Togglesterminaloutput.Showsalertlogmessages.ShowsthecurrentADRbase.
SHOWCONTROLShowsADRinformation,includingthecurrentpurging
policy.SHOWHM_RUNSHOWHOMEPATH
ShowsHealthMonitorruninformation.Showsthecurrenthomepath.ListsthecurrentADRhomes.
SHOWHOMES
SHOWINCDIRSHOWINCIDENT
Liststhetracefilescreatedforthespecifiedincidents.Outputsalistofincidents.
SHOWPROBLEMOutputsalistofproblems.
SHOWREPORTSHOWTRACEFILESPOOL

ShowsareportforthespecifiedreporttypeandID.Listsqualifiedtracefilenames.Directsoutputtoafile.
Table16-3IPSCommandSet
Command
Description
IPSADD
Addsanincident,problem,orproblemkeytoapackage.
IPSADDFILEIPSADDNEW
INCIDENTS
Addsafiletoapackage.
Findsandaddsnewincidentsfortheproblemsinthespecifiedpackage.
IPSCOPYINFILE
CopiesfilesintotheADRfromtheexternalfilesystem.

Oracle11g新特性实验之一-ADRCI工具使用
Command
Description
IPSCOPYOUTFILECopiesfilesoutoftheADRtotheexternalfile
system.IPSCREATEPACKAGECreatesanew(logicalpackage.
IPSDELETEPACKAGEDeletesapackageanditscontentsfromtheADR.
IPSFINALIZE
Finalizesapackagebeforeuploading.
GeneratesaZIPfileofthespecifiedpackagecontentsinthetargetdirectory.
IPSGENERATEPACKAGE
IPSGETMANIFESTIPSGETMETADATAIPSPACK
RetrievesanddisplaysthemanifestfromapackageZIPfile.
ExtractsmetadatafromapackageZIPfileanddisplaysit.
Createsaphysicalpackage(ZIPfiledirectlyfromincidents,problems,orproblemkeys.
IPSREMOVE
Removesincidentsfromanexistingpackage.
IPSREMOVEFILEIPSSET
CONFIGURATIONIPSSHOWCONFIGURATION
Removeafilefromanexistingpackage.
ChangesthevalueofanIPSconfigurationparameter.
DisplaysthevaluesofIPSconfigurationparameters.
IPSSHOWFILES
Liststhefilesinapackage.
IPSSHOWINCIDENTSListstheincidentsinapackage.IPSUNPACKFILE

UnpackagesapackageZIPfileintoaspecifiedpath.
5.参考资料：
http://yangtingkun.itpub.net/post/468/481227
Oracle®DatabaseUtilities11gRelease2(11.2PartNumberE10701-03：16ADRCI:ADRCommandInterpreter

本文来源：https://www.2haoxitong.net/k/doc/919599e40242a8956bece4d3.html

《Oracle11g新特性实验之一-ADRCI工具使用.doc》
将本文的Word文档下载到电脑，方便收藏和打印
推荐度：
点击下载文档

文档为doc格式
相
关
案
例

相关推荐

推荐内容

重庆大学2013届毕业生就业工作总结研讨会议程 建党90周年红歌推荐曲目 完整版人一生应该做哪些事 黑龙江省哈尔滨市道里区2014年中考英语二模试题(扫描版) 考公务员背常识(先记住再看效果) 牛津译林版英语七上《unit7》错题集 2019年小学三年级作文200字范文-我崇拜的人 湖南省司法鉴定服务收费管理办法 【呕心沥血整理】2014全国一级建造师考试 市政公用工程管理与实务 精选案例分析(含解题技巧-陈明教授) 全能之王 汤姆逊 TG585 v7 无线路由器 设置方法
网站内容来自网络，如有侵权请联系我们，立即删除！ Copyright © 范文写作网京ICP备16605803号