?完整记录一则Oracle 11.2.0.4单实例打PSU补丁的过程
时间:2022-03-14 03:24
本文记录了打PSU的全过程,意在体会数据库打PSU补丁的整个过程。
1.OPatch替换为最新版本
2.数据库软件应用19221551补丁程序
3.数据库应用补丁
4.验证PSU补丁是否应用成功
1.OPatch替换为最新版本
[oracle@DB usr2]$ id uid=500(oracle) gid=500(oinstall) 组=500(oinstall),501(dba) 环境=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023 [oracle@DB usr2]$ cd /opt/app/oracle/product/11.2.0/dbhome_1/OPatch/ [oracle@DB OPatch]$ ls crs docs emdpatch.pl jlib ocm opatch opatch.bat opatchdiag opatchdiag.bat opatch.ini opatch.pl opatchprereqs oplan [oracle@DB OPatch]$ ./opatch version OPatch Version: 11.2.0.3.4 OPatch succeeded. [oracle@DB OPatch]$ cd .. [oracle@DB dbhome_1]$ mv OPatch/ OPatch_bak [oracle@DB dbhome_1]$ unzip /usr2/p6880880_112000_Linux-x86-64.zip Archive: /usr2/p6880880_112000_Linux-x86-64.zip creating: OPatch/ creating: OPatch/jlib/ inflating: OPatch/jlib/oracle.opatch.classpath.jar inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar inflating: OPatch/jlib/opatch.jar creating: OPatch/jlib/fa/ inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.windows.jar inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.unix.jar inflating: OPatch/jlib/fa/oracle.opatch.fa.classpath.jar inflating: OPatch/jlib/opatchsdk.jar inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar creating: OPatch/oplan/ inflating: OPatch/oplan/oplan.bat creating: OPatch/oplan/jlib/ inflating: OPatch/oplan/jlib/oplan.jar inflating: OPatch/oplan/jlib/osysmodel-utils.jar inflating: OPatch/oplan/jlib/patchsdk.jar inflating: OPatch/oplan/jlib/JMXDrivers.jar inflating: OPatch/oplan/jlib/Validation.jar inflating: OPatch/oplan/jlib/bundle.jar inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar inflating: OPatch/oplan/jlib/OuiDriver.jar inflating: OPatch/oplan/jlib/automation.jar creating: OPatch/oplan/jlib/jaxb/ inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar inflating: OPatch/oplan/jlib/jaxb/activation.jar inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar inflating: OPatch/oplan/jlib/EMrepoDrivers.jar inflating: OPatch/oplan/jlib/CRSProductDriver.jar inflating: OPatch/oplan/jlib/ValidationRules.jar creating: OPatch/oplan/jlib/apache-commons/ inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar inflating: OPatch/oplan/jlib/OsysModel.jar inflating: OPatch/oplan/oplan inflating: OPatch/oplan/README.txt inflating: OPatch/oplan/README.html creating: OPatch/opatchprereqs/ inflating: OPatch/opatchprereqs/prerequisite.properties creating: OPatch/opatchprereqs/opatch/ inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: OPatch/opatchprereqs/opatch/rulemap.xml creating: OPatch/opatchprereqs/oui/ inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml inflating: OPatch/emdpatch.pl inflating: OPatch/opatch.pl inflating: OPatch/opatch inflating: OPatch/opatch.bat inflating: OPatch/README.txt creating: OPatch/docs/ inflating: OPatch/docs/Prereq_Users_Guide.txt inflating: OPatch/docs/Users_Guide.txt inflating: OPatch/docs/FAQ creating: OPatch/crs/ inflating: OPatch/crs/patch11203.pl creating: OPatch/crs/log/ inflating: OPatch/crs/patch11202.pl inflating: OPatch/crs/auto_patch.pl inflating: OPatch/crs/patch112.pl inflating: OPatch/crs/installPatch.excl inflating: OPatch/opatchdiag.bat creating: OPatch/ocm/ inflating: OPatch/ocm/ocm_platforms.txt extracting: OPatch/ocm/ocm.zip creating: OPatch/ocm/lib/ inflating: OPatch/ocm/lib/emocmclnt.jar inflating: OPatch/ocm/lib/emocmclnt-14.jar inflating: OPatch/ocm/lib/http_client.jar inflating: OPatch/ocm/lib/osdt_jce.jar inflating: OPatch/ocm/lib/jnet.jar inflating: OPatch/ocm/lib/emocmcommon.jar inflating: OPatch/ocm/lib/xmlparserv2.jar inflating: OPatch/ocm/lib/log4j-core.jar inflating: OPatch/ocm/lib/jcert.jar inflating: OPatch/ocm/lib/jsse.jar inflating: OPatch/ocm/lib/osdt_core3.jar inflating: OPatch/ocm/lib/regexp.jar creating: OPatch/ocm/bin/ inflating: OPatch/ocm/bin/emocmrsp extracting: OPatch/version.txt inflating: OPatch/opatch.ini inflating: OPatch/opatchdiag [oracle@DB dbhome_1]$ ls apex cfgtoollogs css deinstall EMStage instantclient jdev log nls OPatch_bak oui precomp scheduler srvm uix assistants clone ctx demo has inventory jdk md oc4j opmn owb racg slax suptools usm bin config cv diagnostics hs j2ee jlib mesg odbc oracore owm rdbms sqldeveloper sysman utl ccr crs dbs dv ide javavm ldap mgw olap oraInst.loc perl relnotes sqlj timingframework wwg cdata csmig dc_ocm emcli install jdbc lib network OPatch ord plsql root.sh sqlplus ucp xdk [oracle@DB dbhome_1]$ cd OPatch [oracle@DB OPatch]$ ./opatch version OPatch Version: 11.2.0.3.6 OPatch succeeded.
2.数据库软件应用19221551补丁程序
[oracle@DB usr2]$ cd /opt [oracle@DB opt]$ cd app [oracle@DB app]$ ls oracle oraInventory [oracle@DB app]$ mkdir patch [oracle@DB app]$ ls oracle oraInventory patch [oracle@DB app]$ cd patch/ [oracle@DB patch]$ ls [oracle@DB patch]$ unzip /usr2/p19121551_112040_Linux-x86-64.zip Archive: /usr2/p19121551_112040_Linux-x86-64.zip creating: 19121551/ creating: 19121551/18031668/ creating: 19121551/18031668/files/ creating: 19121551/18031668/files/psu/ creating: 19121551/18031668/files/psu/11.2.0.4.2/ inflating: 19121551/18031668/files/psu/11.2.0.4.2/catpsu.sql inflating: 19121551/18031668/files/psu/11.2.0.4.2/catpsu_rollback.sql creating: 19121551/18031668/files/bin/ inflating: 19121551/18031668/files/bin/diskmon.bin creating: 19121551/18031668/files/lib/ creating: 19121551/18031668/files/lib/libclient11.a/ inflating: 19121551/18031668/files/lib/libclient11.a/knxo.o creating: 19121551/18031668/files/lib/libnnz11.a/ inflating: 19121551/18031668/files/lib/libnnz11.a/ssl_rec_read_readrecord.o creating: 19121551/18031668/files/lib/libcommon11.a/ inflating: 19121551/18031668/files/lib/libcommon11.a/sageindex.o inflating: 19121551/18031668/files/lib/libcommon11.a/sagetxn.o inflating: 19121551/18031668/files/lib/libcommon11.a/kaf4.o inflating: 19121551/18031668/files/lib/libcommon11.a/sagedata.o inflating: 19121551/18031668/files/lib/libcommon11.a/fplibtest.o inflating: 19121551/18031668/files/lib/libcommon11.a/sagecache.o inflating: 19121551/18031668/files/lib/libnnz11.so creating: 19121551/18031668/files/lib/libcell11.a/ inflating: 19121551/18031668/files/lib/libcell11.a/osslib.o inflating: 19121551/18031668/files/lib/libcell11.a/sosstcp.o creating: 19121551/18031668/files/lib/libserver11.a/ inflating: 19121551/18031668/files/lib/libserver11.a/knlc.o inflating: 19121551/18031668/files/lib/libserver11.a/kzd.o inflating: 19121551/18031668/files/lib/libserver11.a/knlogc.o inflating: 19121551/18031668/files/lib/libserver11.a/kdil.o inflating: 19121551/18031668/files/lib/libserver11.a/knal.o inflating: 19121551/18031668/files/lib/libserver11.a/xty.o inflating: 19121551/18031668/files/lib/libserver11.a/ktsp.o inflating: 19121551/18031668/files/lib/libserver11.a/kkt.o inflating: 19121551/18031668/files/lib/libserver11.a/ktfb.o inflating: 19121551/18031668/files/lib/libserver11.a/krsm.o inflating: 19121551/18031668/files/lib/libserver11.a/kdx.o inflating: 19121551/18031668/files/lib/libserver11.a/rfrdb.o inflating: 19121551/18031668/files/lib/libserver11.a/knl.o inflating: 19121551/18031668/files/lib/libserver11.a/krvxb.o inflating: 19121551/18031668/files/lib/libserver11.a/krse.o inflating: 19121551/18031668/files/lib/libserver11.a/kcl.o inflating: 19121551/18031668/files/lib/libserver11.a/knip.o inflating: 19121551/18031668/files/lib/libserver11.a/atb.o inflating: 19121551/18031668/files/lib/libserver11.a/knlcsx.o inflating: 19121551/18031668/files/lib/libserver11.a/kdbl.o inflating: 19121551/18031668/files/lib/libserver11.a/kjbm.o inflating: 19121551/18031668/files/lib/libserver11.a/knlcsv.o inflating: 19121551/18031668/files/lib/libserver11.a/knanr.o inflating: 19121551/18031668/files/lib/libserver11.a/kcrfr.o inflating: 19121551/18031668/files/lib/libserver11.a/krr.o inflating: 19121551/18031668/files/lib/libserver11.a/kcvs.o inflating: 19121551/18031668/files/lib/libserver11.a/krf.o inflating: 19121551/18031668/files/lib/libserver11.a/kni.o inflating: 19121551/18031668/files/lib/libserver11.a/kntg.o inflating: 19121551/18031668/files/lib/libserver11.a/kxdrs.o inflating: 19121551/18031668/files/lib/libserver11.a/knalse.o inflating: 19121551/18031668/files/lib/libserver11.a/kcfis.o inflating: 19121551/18031668/files/lib/libserver11.a/kfdp.o inflating: 19121551/18031668/files/lib/libserver11.a/knac.o inflating: 19121551/18031668/files/lib/libserver11.a/rfrld.o inflating: 19121551/18031668/files/lib/libserver11.a/kcbr.o inflating: 19121551/18031668/files/lib/libserver11.a/kjr.o inflating: 19121551/18031668/files/lib/libserver11.a/kpolob.o inflating: 19121551/18031668/files/lib/libserver11.a/knasp.o inflating: 19121551/18031668/files/lib/libserver11.a/kzp.o inflating: 19121551/18031668/files/lib/libserver11.a/krsk.o inflating: 19121551/18031668/files/lib/libserver11.a/ktel.o inflating: 19121551/18031668/files/lib/libserver11.a/ksfd.o inflating: 19121551/18031668/files/lib/libserver11.a/knals.o inflating: 19121551/18031668/files/lib/libserver11.a/kcbz.o inflating: 19121551/18031668/files/lib/libserver11.a/knalf.o inflating: 19121551/18031668/files/lib/libserver11.a/kxdam.o inflating: 19121551/18031668/files/lib/libserver11.a/kfg.o inflating: 19121551/18031668/files/lib/libserver11.a/kcb.o inflating: 19121551/18031668/files/lib/libserver11.a/rfrpd.o inflating: 19121551/18031668/files/lib/libserver11.a/knalsp.o inflating: 19121551/18031668/files/lib/libserver11.a/knas.o inflating: 19121551/18031668/files/lib/libserver11.a/kkdl.o inflating: 19121551/18031668/files/lib/libserver11.a/knasx.o inflating: 19121551/18031668/files/lib/libserver11.a/msqimb.o inflating: 19121551/18031668/files/lib/libserver11.a/krst.o inflating: 19121551/18031668/files/lib/libserver11.a/krd.o inflating: 19121551/18031668/files/lib/libserver11.a/kfd.o creating: 19121551/18031668/files/lib/libpls11_pic.a/ inflating: 19121551/18031668/files/lib/libpls11_pic.a/pkv_pic.o creating: 19121551/18031668/files/lib/libgeneric11.a/ inflating: 19121551/18031668/files/lib/libgeneric11.a/qci.o inflating: 19121551/18031668/files/lib/libgeneric11.a/kgl.o inflating: 19121551/18031668/files/lib/libgeneric11.a/kopt.o creating: 19121551/18031668/files/lib/libpls11.a/ inflating: 19121551/18031668/files/lib/libpls11.a/pkv.o inflating: 19121551/18031668/files/lib/libasmclntsh11.so creating: 19121551/18031668/files/lib/libasmclntsh11.a/ inflating: 19121551/18031668/files/lib/libasmclntsh11.a/kfgp.o inflating: 19121551/18031668/files/lib/libasmclntsh11.a/kgfm.o inflating: 19121551/18031668/files/lib/libcell11.so creating: 19121551/18031668/files/lib/libasmclnt11.a/ inflating: 19121551/18031668/files/lib/libasmclnt11.a/kfgp.o inflating: 19121551/18031668/files/lib/libasmclnt11.a/kgfm.o creating: 19121551/18031668/files/rdbms/ creating: 19121551/18031668/files/rdbms/lib/ inflating: 19121551/18031668/files/rdbms/lib/diskmon.o creating: 19121551/18031668/files/rdbms/lib/libperfsrv11.a/ inflating: 19121551/18031668/files/rdbms/lib/libperfsrv11.a/kaf4_PERF.o inflating: 19121551/18031668/files/rdbms/lib/orion.o creating: 19121551/18031668/files/rdbms/admin/ inflating: 19121551/18031668/files/rdbms/admin/spawrio.sql inflating: 19121551/18031668/files/rdbms/admin/prvtdadv.plb inflating: 19121551/18031668/files/rdbms/admin/bundledata_PSU.xml inflating: 19121551/18031668/files/rdbms/admin/prvtadv.plb creating: 19121551/18031668/etc/ creating: 19121551/18031668/etc/config/ inflating: 19121551/18031668/etc/config/inventory.xml inflating: 19121551/18031668/etc/config/actions.xml inflating: 19121551/18031668/etc/config/deploy.xml creating: 19121551/18031668/etc/xml/ inflating: 19121551/18031668/etc/xml/GenericActions.xml inflating: 19121551/18031668/etc/xml/ShiphomeDirectoryStructure.xml extracting: 19121551/README.txt creating: 19121551/19121551/ creating: 19121551/19121551/files/ creating: 19121551/19121551/files/psu/ creating: 19121551/19121551/files/psu/11.2.0.4.4/ inflating: 19121551/19121551/files/psu/11.2.0.4.4/catpsu.sql inflating: 19121551/19121551/files/psu/11.2.0.4.4/catpsu_rollback.sql creating: 19121551/19121551/files/lib/ creating: 19121551/19121551/files/lib/libcommon11.a/ inflating: 19121551/19121551/files/lib/libcommon11.a/k2u.o inflating: 19121551/19121551/files/lib/libcommon11.a/kpccap.o inflating: 19121551/19121551/files/lib/libcommon11.a/ktsg.o inflating: 19121551/19121551/files/lib/libcommon11.a/k2m.o inflating: 19121551/19121551/files/lib/libcommon11.a/kll.o creating: 19121551/19121551/files/lib/libserver11.a/ inflating: 19121551/19121551/files/lib/libserver11.a/krbb.o inflating: 19121551/19121551/files/lib/libserver11.a/qesma.o inflating: 19121551/19121551/files/lib/libserver11.a/opivsn.o inflating: 19121551/19121551/files/lib/libserver11.a/kjfm.o inflating: 19121551/19121551/files/lib/libserver11.a/xty.o inflating: 19121551/19121551/files/lib/libserver11.a/kjbr.o inflating: 19121551/19121551/files/lib/libserver11.a/kkt.o inflating: 19121551/19121551/files/lib/libserver11.a/krsh.o inflating: 19121551/19121551/files/lib/libserver11.a/kjx.o inflating: 19121551/19121551/files/lib/libserver11.a/kjfc.o inflating: 19121551/19121551/files/lib/libserver11.a/kks.o inflating: 19121551/19121551/files/lib/libserver11.a/kzax.o inflating: 19121551/19121551/files/lib/libserver11.a/ksp.o inflating: 19121551/19121551/files/lib/libserver11.a/kjbl.o inflating: 19121551/19121551/files/lib/libserver11.a/krsv.o inflating: 19121551/19121551/files/lib/libserver11.a/kkzl.o inflating: 19121551/19121551/files/lib/libserver11.a/kks1.o inflating: 19121551/19121551/files/lib/libserver11.a/kcl.o inflating: 19121551/19121551/files/lib/libserver11.a/kewr.o inflating: 19121551/19121551/files/lib/libserver11.a/kjb.o inflating: 19121551/19121551/files/lib/libserver11.a/atb.o inflating: 19121551/19121551/files/lib/libserver11.a/qerus.o inflating: 19121551/19121551/files/lib/libserver11.a/kjcts.o inflating: 19121551/19121551/files/lib/libserver11.a/ktu.o inflating: 19121551/19121551/files/lib/libserver11.a/kdd.o inflating: 19121551/19121551/files/lib/libserver11.a/kjbm.o inflating: 19121551/19121551/files/lib/libserver11.a/kxib.o inflating: 19121551/19121551/files/lib/libserver11.a/qesmboim.o inflating: 19121551/19121551/files/lib/libserver11.a/kjbdom.o inflating: 19121551/19121551/files/lib/libserver11.a/psdpgi.o inflating: 19121551/19121551/files/lib/libserver11.a/kcbl.o inflating: 19121551/19121551/files/lib/libserver11.a/kcbt.o inflating: 19121551/19121551/files/lib/libserver11.a/kjm.o inflating: 19121551/19121551/files/lib/libserver11.a/kkscs.o inflating: 19121551/19121551/files/lib/libserver11.a/dmqx.o inflating: 19121551/19121551/files/lib/libserver11.a/updexe.o inflating: 19121551/19121551/files/lib/libserver11.a/qesmm.o inflating: 19121551/19121551/files/lib/libserver11.a/kcbr.o inflating: 19121551/19121551/files/lib/libserver11.a/ktb.o inflating: 19121551/19121551/files/lib/libserver11.a/kkpam.o inflating: 19121551/19121551/files/lib/libserver11.a/kjfs.o inflating: 19121551/19121551/files/lib/libserver11.a/kpospf.o inflating: 19121551/19121551/files/lib/libserver11.a/kjctc.o inflating: 19121551/19121551/files/lib/libserver11.a/kdu.o inflating: 19121551/19121551/files/lib/libserver11.a/kjs.o inflating: 19121551/19121551/files/lib/libserver11.a/kju.o inflating: 19121551/19121551/files/lib/libserver11.a/kjdd.o inflating: 19121551/19121551/files/lib/libserver11.a/kjfz.o inflating: 19121551/19121551/files/lib/libserver11.a/kjdx.o inflating: 19121551/19121551/files/lib/libserver11.a/kcb.o inflating: 19121551/19121551/files/lib/libserver11.a/kwqic.o inflating: 19121551/19121551/files/lib/libserver11.a/qespc.o inflating: 19121551/19121551/files/lib/libserver11.a/kjp.o inflating: 19121551/19121551/files/lib/libserver11.a/qerup.o inflating: 19121551/19121551/files/lib/libserver11.a/kji.o inflating: 19121551/19121551/files/lib/libserver11.a/kxs.o inflating: 19121551/19121551/files/lib/libserver11.a/opipls.o inflating: 19121551/19121551/files/lib/libserver11.a/kjdr.o inflating: 19121551/19121551/files/lib/libserver11.a/kjcs.o creating: 19121551/19121551/files/lib/libgeneric11.a/ inflating: 19121551/19121551/files/lib/libgeneric11.a/qmx0.o inflating: 19121551/19121551/files/lib/libgeneric11.a/qci.o inflating: 19121551/19121551/files/lib/libgeneric11.a/kgl.o inflating: 19121551/19121551/files/lib/libgeneric11.a/qcdo.o inflating: 19121551/19121551/files/lib/libgeneric11.a/kgnfs.o inflating: 19121551/19121551/files/lib/libgeneric11.a/qcso.o inflating: 19121551/19121551/files/lib/libgeneric11.a/kgh.o inflating: 19121551/19121551/files/lib/libgeneric11.a/kgl2.o inflating: 19121551/19121551/files/lib/libgeneric11.a/kgbt.o creating: 19121551/19121551/files/ord/ creating: 19121551/19121551/files/ord/jlib/ inflating: 19121551/19121551/files/ord/jlib/ordim.jar inflating: 19121551/19121551/files/ord/jlib/ordimimg.jar creating: 19121551/19121551/files/sysman/ creating: 19121551/19121551/files/sysman/jlib/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/ inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/DBMsgID.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/DBMsg.class creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/adm/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/adm/util/ inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/db/adm/util/BeanUtils.class creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/ inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/DBObjectSQLGenerator.class creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/ creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainRulesSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/WindowSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/WindowGroupSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/JobSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainStepsSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/Job.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ClassSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ScheduleSQLGenerator.class inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ProgramSQLGenerator.class creating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/baseline/ inflating: 19121551/19121551/files/sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/baseline/BaselineSQLGenerator.class creating: 19121551/19121551/files/rdbms/ creating: 19121551/19121551/files/rdbms/lib/ inflating: 19121551/19121551/files/rdbms/lib/jox.o creating: 19121551/19121551/files/rdbms/lib/libknlopt.a/ inflating: 19121551/19121551/files/rdbms/lib/libknlopt.a/jox.o creating: 19121551/19121551/files/rdbms/lib/libdbtools11.a/ inflating: 19121551/19121551/files/rdbms/lib/libdbtools11.a/krmb.o inflating: 19121551/19121551/files/rdbms/lib/libdbtools11.a/krmk4.o inflating: 19121551/19121551/files/rdbms/lib/libdbtools11.a/krmk3.o inflating: 19121551/19121551/files/rdbms/lib/ins_rdbms.mk creating: 19121551/19121551/files/rdbms/mesg/ inflating: 19121551/19121551/files/rdbms/mesg/oraus.msb inflating: 19121551/19121551/files/rdbms/mesg/oraus.msg creating: 19121551/19121551/files/rdbms/admin/ extracting: 19121551/19121551/files/rdbms/admin/kspauv14.var inflating: 19121551/19121551/files/rdbms/admin/prvtpckl.plb inflating: 19121551/19121551/files/rdbms/admin/c1102000.sql inflating: 19121551/19121551/files/rdbms/admin/catbundle.sql inflating: 19121551/19121551/files/rdbms/admin/bundledata_PSU.xml creating: 19121551/19121551/etc/ creating: 19121551/19121551/etc/config/ inflating: 19121551/19121551/etc/config/inventory.xml inflating: 19121551/19121551/etc/config/composite.xml inflating: 19121551/19121551/etc/config/actions.xml inflating: 19121551/19121551/etc/config/deploy.xml creating: 19121551/19121551/etc/xml/ inflating: 19121551/19121551/etc/xml/GenericActions.xml inflating: 19121551/19121551/etc/xml/ShiphomeDirectoryStructure.xml creating: 19121551/17478514/ creating: 19121551/17478514/files/ creating: 19121551/17478514/files/psu/ creating: 19121551/17478514/files/psu/11.2.0.4.1/ inflating: 19121551/17478514/files/psu/11.2.0.4.1/catpsu.sql inflating: 19121551/17478514/files/psu/11.2.0.4.1/catpsu_rollback.sql creating: 19121551/17478514/files/bin/ inflating: 19121551/17478514/files/bin/xsl inflating: 19121551/17478514/files/bin/xmlcg inflating: 19121551/17478514/files/bin/xvm inflating: 19121551/17478514/files/bin/lxinst creating: 19121551/17478514/files/lib/ creating: 19121551/17478514/files/lib/libclient11.a/ inflating: 19121551/17478514/files/lib/libclient11.a/knoggcap.o creating: 19121551/17478514/files/lib/libxml11.a/ inflating: 19121551/17478514/files/lib/libxml11.a/lpxm.o inflating: 19121551/17478514/files/lib/libxml11.a/lpxfsm.o creating: 19121551/17478514/files/lib/libserver11.a/ inflating: 19121551/17478514/files/lib/libserver11.a/kjbr.o inflating: 19121551/17478514/files/lib/libserver11.a/kqlf.o inflating: 19121551/17478514/files/lib/libserver11.a/kjx.o inflating: 19121551/17478514/files/lib/libserver11.a/kjbl.o inflating: 19121551/17478514/files/lib/libserver11.a/kkss.o inflating: 19121551/17478514/files/lib/libserver11.a/kjb.o inflating: 19121551/17478514/files/lib/libserver11.a/ksfdss.o inflating: 19121551/17478514/files/lib/libserver11.a/kjbm.o inflating: 19121551/17478514/files/lib/libserver11.a/qkajoi.o inflating: 19121551/17478514/files/lib/libserver11.a/kcfis.o inflating: 19121551/17478514/files/lib/libserver11.a/kf.o inflating: 19121551/17478514/files/lib/libserver11.a/kfds.o inflating: 19121551/17478514/files/lib/libserver11.a/kjs.o inflating: 19121551/17478514/files/lib/libserver11.a/kju.o inflating: 19121551/17478514/files/lib/libserver11.a/ksfd.o inflating: 19121551/17478514/files/lib/libserver11.a/kjdx.o inflating: 19121551/17478514/files/lib/libserver11.a/kjdr.o inflating: 19121551/17478514/files/lib/libserver11.a/kff.o inflating: 19121551/17478514/files/lib/libserver11.a/kfd.o inflating: 19121551/17478514/files/lib/libserver11.a/xct.o creating: 19121551/17478514/files/lib/libpls11_pic.a/ inflating: 19121551/17478514/files/lib/libpls11_pic.a/pevmexe_pic.o creating: 19121551/17478514/files/lib/libgeneric11.a/ inflating: 19121551/17478514/files/lib/libgeneric11.a/qcs.o inflating: 19121551/17478514/files/lib/libgeneric11.a/qcd.o creating: 19121551/17478514/files/lib/libpls11.a/ inflating: 19121551/17478514/files/lib/libpls11.a/pevmexe.o creating: 19121551/17478514/files/md/ creating: 19121551/17478514/files/md/admin/ inflating: 19121551/17478514/files/md/admin/catmd10i.sql inflating: 19121551/17478514/files/md/admin/sdodbmig.sql inflating: 19121551/17478514/files/md/admin/sdopatch.sql creating: 19121551/17478514/files/patch/ creating: 19121551/17478514/files/patch/scripts/ inflating: 19121551/17478514/files/patch/scripts/bug17088068.sql creating: 19121551/17478514/files/rdbms/ creating: 19121551/17478514/files/rdbms/admin/ inflating: 19121551/17478514/files/rdbms/admin/catbundle.sql inflating: 19121551/17478514/files/rdbms/admin/utlu112x.sql inflating: 19121551/17478514/files/rdbms/admin/bundledata_PSU.xml inflating: 19121551/17478514/files/rdbms/admin/utlu112i.sql creating: 19121551/17478514/etc/ creating: 19121551/17478514/etc/config/ inflating: 19121551/17478514/etc/config/inventory.xml inflating: 19121551/17478514/etc/config/actions.xml inflating: 19121551/17478514/etc/config/deploy.xml creating: 19121551/17478514/etc/xml/ inflating: 19121551/17478514/etc/xml/GenericActions.xml inflating: 19121551/17478514/etc/xml/ShiphomeDirectoryStructure.xml inflating: 19121551/README.html creating: 19121551/18522509/ creating: 19121551/18522509/files/ creating: 19121551/18522509/files/psu/ creating: 19121551/18522509/files/psu/11.2.0.4.3/ inflating: 19121551/18522509/files/psu/11.2.0.4.3/catpsu.sql inflating: 19121551/18522509/files/psu/11.2.0.4.3/catpsu_rollback.sql creating: 19121551/18522509/files/lib/ inflating: 19121551/18522509/files/lib/asmcmdsys.pm inflating: 19121551/18522509/files/lib/asmcmdambr.pm creating: 19121551/18522509/files/lib/libserver11.a/ inflating: 19121551/18522509/files/lib/libserver11.a/jskr.o inflating: 19121551/18522509/files/lib/libserver11.a/xpl.o inflating: 19121551/18522509/files/lib/libserver11.a/kzekm.o inflating: 19121551/18522509/files/lib/libserver11.a/jscr.o inflating: 19121551/18522509/files/lib/libserver11.a/kkdo.o inflating: 19121551/18522509/files/lib/libserver11.a/kdlf.o inflating: 19121551/18522509/files/lib/libserver11.a/xty.o inflating: 19121551/18522509/files/lib/libserver11.a/qermt.o inflating: 19121551/18522509/files/lib/libserver11.a/ktsp.o inflating: 19121551/18522509/files/lib/libserver11.a/kkdc.o inflating: 19121551/18522509/files/lib/libserver11.a/kkt.o inflating: 19121551/18522509/files/lib/libserver11.a/ktfb.o inflating: 19121551/18522509/files/lib/libserver11.a/ktspsrch.o inflating: 19121551/18522509/files/lib/libserver11.a/qermd.o inflating: 19121551/18522509/files/lib/libserver11.a/kks.o inflating: 19121551/18522509/files/lib/libserver11.a/knahs.o inflating: 19121551/18522509/files/lib/libserver11.a/knipc.o inflating: 19121551/18522509/files/lib/libserver11.a/kds.o inflating: 19121551/18522509/files/lib/libserver11.a/krvxb.o inflating: 19121551/18522509/files/lib/libserver11.a/delexe.o inflating: 19121551/18522509/files/lib/libserver11.a/krvg.o inflating: 19121551/18522509/files/lib/libserver11.a/upsexe.o inflating: 19121551/18522509/files/lib/libserver11.a/cvw.o inflating: 19121551/18522509/files/lib/libserver11.a/qerfx.o inflating: 19121551/18522509/files/lib/libserver11.a/qees.o inflating: 19121551/18522509/files/lib/libserver11.a/qesltc.o inflating: 19121551/18522509/files/lib/libserver11.a/kzradmape.o inflating: 19121551/18522509/files/lib/libserver11.a/ksk.o inflating: 19121551/18522509/files/lib/libserver11.a/qerus.o inflating: 19121551/18522509/files/lib/libserver11.a/kdlw.o inflating: 19121551/18522509/files/lib/libserver11.a/ktsk.o inflating: 19121551/18522509/files/lib/libserver11.a/dgl.o inflating: 19121551/18522509/files/lib/libserver11.a/kql.o inflating: 19121551/18522509/files/lib/libserver11.a/kzradma.o inflating: 19121551/18522509/files/lib/libserver11.a/kjbm.o inflating: 19121551/18522509/files/lib/libserver11.a/qerltc.o inflating: 19121551/18522509/files/lib/libserver11.a/ksfv.o inflating: 19121551/18522509/files/lib/libserver11.a/kkm.o inflating: 19121551/18522509/files/lib/libserver11.a/qerel.o inflating: 19121551/18522509/files/lib/libserver11.a/krvrd.o inflating: 19121551/18522509/files/lib/libserver11.a/kfdp.o inflating: 19121551/18522509/files/lib/libserver11.a/kqld.o inflating: 19121551/18522509/files/lib/libserver11.a/updexe.o inflating: 19121551/18522509/files/lib/libserver11.a/kzradm.o inflating: 19121551/18522509/files/lib/libserver11.a/kpolob.o inflating: 19121551/18522509/files/lib/libserver11.a/ktb.o inflating: 19121551/18522509/files/lib/libserver11.a/kdt.o inflating: 19121551/18522509/files/lib/libserver11.a/kkpap.o inflating: 19121551/18522509/files/lib/libserver11.a/kwqbm.o inflating: 19121551/18522509/files/lib/libserver11.a/kkj.o inflating: 19121551/18522509/files/lib/libserver11.a/kqr.o inflating: 19121551/18522509/files/lib/libserver11.a/insexe.o inflating: 19121551/18522509/files/lib/libserver11.a/qesso.o inflating: 19121551/18522509/files/lib/libserver11.a/qesel.o inflating: 19121551/18522509/files/lib/libserver11.a/ktsplb.o inflating: 19121551/18522509/files/lib/libserver11.a/qesld.o inflating: 19121551/18522509/files/lib/libserver11.a/kcbz.o inflating: 19121551/18522509/files/lib/libserver11.a/qkadrv.o inflating: 19121551/18522509/files/lib/libserver11.a/qerdl.o inflating: 19121551/18522509/files/lib/libserver11.a/kfg.o inflating: 19121551/18522509/files/lib/libserver11.a/kcb.o inflating: 19121551/18522509/files/lib/libserver11.a/kaf.o inflating: 19121551/18522509/files/lib/libserver11.a/krvt.o inflating: 19121551/18522509/files/lib/libserver11.a/qkagby.o inflating: 19121551/18522509/files/lib/libserver11.a/kkdl.o inflating: 19121551/18522509/files/lib/libserver11.a/kdc.o inflating: 19121551/18522509/files/lib/libserver11.a/krvx.o inflating: 19121551/18522509/files/lib/libserver11.a/qerup.o creating: 19121551/18522509/files/lib/libpls11_pic.a/ inflating: 19121551/18522509/files/lib/libpls11_pic.a/phn_pic.o inflating: 19121551/18522509/files/lib/asmcmdbase.pm creating: 19121551/18522509/files/lib/libgeneric11.a/ inflating: 19121551/18522509/files/lib/libgeneric11.a/kgx.o inflating: 19121551/18522509/files/lib/libgeneric11.a/qcs.o inflating: 19121551/18522509/files/lib/libgeneric11.a/kgsk.o inflating: 19121551/18522509/files/lib/libgeneric11.a/kgl.o inflating: 19121551/18522509/files/lib/libgeneric11.a/kgnfs.o inflating: 19121551/18522509/files/lib/libgeneric11.a/kgl2.o inflating: 19121551/18522509/files/lib/libgeneric11.a/qct.o inflating: 19121551/18522509/files/lib/libgeneric11.a/kgl4.o creating: 19121551/18522509/files/lib/libpls11.a/ inflating: 19121551/18522509/files/lib/libpls11.a/phn.o inflating: 19121551/18522509/files/lib/asmcmdvol.pm inflating: 19121551/18522509/files/lib/libasmclntsh11.so inflating: 19121551/18522509/files/lib/asmcmdshare.pm inflating: 19121551/18522509/files/lib/asmcmdug.pm creating: 19121551/18522509/files/lib/libasmclntsh11.a/ inflating: 19121551/18522509/files/lib/libasmclntsh11.a/kgfm.o creating: 19121551/18522509/files/lib/libasmclnt11.a/ inflating: 19121551/18522509/files/lib/libasmclnt11.a/kgfm.o inflating: 19121551/18522509/files/lib/asmcmddisk.pm inflating: 19121551/18522509/files/lib/asmcmdanlz.pm creating: 19121551/18522509/files/patch/ creating: 19121551/18522509/files/patch/scripts/ inflating: 19121551/18522509/files/patch/scripts/bug17381384.sql creating: 19121551/18522509/files/rdbms/ creating: 19121551/18522509/files/rdbms/lib/ inflating: 19121551/18522509/files/rdbms/lib/jox.o creating: 19121551/18522509/files/rdbms/lib/libknlopt.a/ inflating: 19121551/18522509/files/rdbms/lib/libknlopt.a/jox.o creating: 19121551/18522509/files/rdbms/lib/libdbtools11.a/ inflating: 19121551/18522509/files/rdbms/lib/libdbtools11.a/krmr2.o inflating: 19121551/18522509/files/rdbms/lib/libdbtools11.a/krmc.o inflating: 19121551/18522509/files/rdbms/lib/libdbtools11.a/krmk5.o inflating: 19121551/18522509/files/rdbms/lib/libdbtools11.a/krmz.o creating: 19121551/18522509/files/rdbms/mesg/ inflating: 19121551/18522509/files/rdbms/mesg/oraus.msb inflating: 19121551/18522509/files/rdbms/mesg/oraus.msg creating: 19121551/18522509/files/rdbms/admin/ inflating: 19121551/18522509/files/rdbms/admin/catlmnr.sql inflating: 19121551/18522509/files/rdbms/admin/prvtredacta.plb inflating: 19121551/18522509/files/rdbms/admin/bundledata_PSU.xml creating: 19121551/18522509/etc/ creating: 19121551/18522509/etc/config/ inflating: 19121551/18522509/etc/config/inventory.xml inflating: 19121551/18522509/etc/config/actions.xml inflating: 19121551/18522509/etc/config/deploy.xml creating: 19121551/18522509/etc/xml/ inflating: 19121551/18522509/etc/xml/GenericActions.xml inflating: 19121551/18522509/etc/xml/ShiphomeDirectoryStructure.xml inflating: 19121551/patchmd.xml inflating: PatchSearch.xml [oracle@DB patch]$ ls 19121551 PatchSearch.xml [oracle@DB patch]$ ls -lh 总用量 40K drwxr-xr-x. 6 oracle oinstall 4.0K 10月 10 21:20 19121551 -rw-rw-r--. 1 oracle oinstall 36K 10月 15 02:43 PatchSearch.xml [oracle@DB patch]$ cd 19121551/ [oracle@DB 19121551]$ ls 17478514 18031668 18522509 19121551 patchmd.xml README.html README.txt [oracle@DB 19121551]$ pwd /opt/app/patch/19121551 [oracle@DB 19121551]$ /opt/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle 中间补丁程序安装程序版本 11.2.0.3.6 版权所有 (c) 2013, Oracle Corporation。保留所有权利。 preREQ session Oracle Home : /opt/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /opt/app/oraInventory from : /opt/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-12-04_21-48-36下午_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@DB 19121551]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 4 21:30:55 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> !lsnrctl stop LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-DEC-2014 21:31:31 Copyright (c) 1991, 2013, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MetarDB)(PORT=1521))) The command completed successfully SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [oracle@DB 19121551]$ ls 17478514 18031668 18522509 19121551 patchmd.xml README.html README.txt [oracle@DB 19121551]$ /opt/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply Oracle 中间补丁程序安装程序版本 11.2.0.3.6 版权所有 (c) 2013, Oracle Corporation。保留所有权利。 Oracle Home : /opt/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /opt/app/oraInventory from : /opt/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-12-04_21-32-34下午_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following executables are active : /opt/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1 UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-12-04_21-32-34下午_1.log OPatch failed with error code 73 [oracle@DB 19121551]$ /opt/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch lspatches 此 Oracle 主目录中未安装任何中间补丁程序。 [oracle@DB 19121551]$ ps -ef|grep ora root 33525 6221 0 17:13 ? 00:00:00 sshd: oracle [priv] oracle 33529 33525 0 17:14 ? 00:00:14 sshd: oracle@notty oracle 33530 33529 0 17:14 ? 00:00:00 /usr/bin/xterm -ls -display localhost:10.0 oracle 33552 33530 0 17:14 pts/3 00:00:00 -bash root 41164 34924 0 17:49 pts/1 00:00:00 su - oracle oracle 41165 41164 0 17:49 pts/1 00:00:00 -bash oracle 41194 41165 0 17:49 pts/1 00:00:00 sqlplus as sysdba root 56251 53828 0 21:45 pts/2 00:00:00 su - oracle oracle 56252 56251 0 21:45 pts/2 00:00:00 -bash oracle 56785 56252 0 21:52 pts/2 00:00:00 ps -ef oracle 56786 56252 0 21:52 pts/2 00:00:00 grep ora [oracle@DB 19121551]$ kill -9 41194 [oracle@DB 19121551]$ /opt/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply Oracle 中间补丁程序安装程序版本 11.2.0.3.6 版权所有 (c) 2013, Oracle Corporation。保留所有权利。 Oracle Home : /opt/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /opt/app/oraInventory from : /opt/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-12-04_21-53-20下午_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17478514 18031668 18522509 19121551 是否继续? [y|n] y User Responded with: Y All checks passed. 提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager 并启动它。如果您使用 My Oracle Support 电子邮件地址/用户名, 操作将更简单。 有关详细信息, 请访问 http://www.oracle.com/support/policies.html。 电子邮件地址/用户名: 尚未提供电子邮件地址以接收有关安全问题的通知。 是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知: y 请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。 (Oracle 主目录 = ‘/opt/app/oracle/product/11.2.0/dbhome_1‘) 本地系统是否已准备打补丁? [y|n] y User Responded with: Y Backing up files... Applying sub-patch ‘17478514‘ to OH ‘/opt/app/oracle/product/11.2.0/dbhome_1‘ 正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.sdo, 11.2.0.4.0 打补丁... 正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁... 正在为组件 oracle.xdk, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁... 正在为组件 oracle.sdo.locator, 11.2.0.4.0 打补丁... 正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁... Verifying the update... Applying sub-patch ‘18031668‘ to OH ‘/opt/app/oracle/product/11.2.0/dbhome_1‘ 正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.crs, 11.2.0.4.0 打补丁... 正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁... 正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁... Verifying the update... Applying sub-patch ‘18522509‘ to OH ‘/opt/app/oracle/product/11.2.0/dbhome_1‘ 正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁... 正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁... Verifying the update... Applying sub-patch ‘19121551‘ to OH ‘/opt/app/oracle/product/11.2.0/dbhome_1‘ 正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁... 正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁... 正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁... 正在为组件 oracle.ordim.client, 11.2.0.4.0 打补丁... 正在为组件 oracle.ordim.jai, 11.2.0.4.0 打补丁... Verifying the update... Composite patch 19121551 successfully applied. Log file location: /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-12-04_21-53-20下午_1.log OPatch succeeded.
3.数据库打补丁
[oracle@DB 19121551]$ cd /opt/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/ [oracle@DB admin]$ sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 4 21:57:18 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> conn /as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1.3395E+10 bytes Fixed Size 2265904 bytes Variable Size 7415532752 bytes Database Buffers 5939134464 bytes Redo Buffers 38313984 bytes Database mounted. Database opened. SQL> @catbundle.sql psu apply PL/SQL procedure successfully completed. Function created. Function created. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Generating apply and rollback scripts... Check the following file for errors: /opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TRAIL_GENERATE_2014Dec04_21_57_47.log Apply script: /opt/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_TRAIL_APPLY.sql Rollback script: /opt/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_TRAIL_ROLLBACK.sql PL/SQL procedure successfully completed. Executing script file... SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT SQL> SELECT ‘/opt/app/oracle/cfgtoollogs/catbundle/‘ || ‘catbundle_PSU_‘ || name || ‘_APPLY_‘ || TO_CHAR(SYSDATE, ‘YYYYMonDD_hh24_mi_ss‘, ‘NLS_DATE_LANGUAGE=‘‘AMERICAN‘‘‘) || ‘.log‘ AS spool_file FROM v$database; SQL> SPOOL &spool_file SQL> exec sys.dbms_registry.set_session_namespace(‘SERVER‘) PL/SQL procedure successfully completed. SQL> PROMPT Processing Oracle Database Packages and Types... Processing Oracle Database Packages and Types... SQL> ALTER SESSION SET current_schema = sys; Session altered. SQL> @?/rdbms/admin/prvtdadv.plb SQL> CREATE OR REPLACE PACKAGE BODY dbms_advisor wrapped 2 a000000 3 1 4 abcd 5 abcd 6 abcd 7 abcd 8 abcd 9 abcd 10 abcd 11 abcd 12 abcd 13 abcd 14 abcd 15 abcd 16 abcd 17 abcd 18 abcd 19 b 20 104fe 2839 21 mgnPYoOWABPIrz+XwtchwZ0ytz0wg81M9iAFV0UiT3PV49ZMtCKGb7wh3toipGenfaK2THrx 22 biH46YVhWDFwBclhPp9LZ6rk7i7ToczToT6f2kmvfmFKQkIZ1fqclvqQhodXFy9+4LurNLX4 23 xgfki3Oduxy5JNDkjl/OT0zTmFAFSS9T3F0VynJu0uFZpbt6wObnfdAsNwxJUnKQka2ka9A+ 24 kg03Fz8hFZpFwVDthb/0qljigF2WmF1l2aS7Ja6GXa2xwD2liY1ZcGGuUSqSeF96HNsjGpL7 25 aCgoIjfcOYgwPJbQDxQ4GyFqc4WR/TzScPzssUbu0WePN1IuJNeUjTInQcbqrQFYsOIxbF1F 26 X/rERpl8wN/70sXMcqaW94iF8RA+Py33Gz7/Z7Zswo/S8uA110WeZTyfjYYaUFzDyqemNas0 27 79KfXEMUPHCtlLt3p+8T+KlvhhIlD4YQOVEQUzf0vibuRa6LM6R1E7sAWEOG7EP/oXCJQ/Em 28 fRFx4VVFXAbseys6sGXBqFkMp4TEKvoqRdLjl/bo3p+DK78RjPYtGimjsXvFC6Vwpgyny3ts 29 Q6OLpBfaP0T7cdoeG7dAIGuYZDLo2yhaOJIQCEORKkk0ChHrHL2eRwnZJLze3RSNv+7RTobj 30 +uT8dmb2//848eHS2sVcqFLkjvHsde/P2fAcIJjQcWig4wsauO/xKA5DzNd6mBk1CBKpvW0z 31 NcpvkTsyH5H5gJMv52z3Mto4GAx7+pOPsIgWDNyv4ydaMVpMeBJKu6yJVBfgQ1d08/INX9qA 32 BtFtyderYe+eSBv6xkV/pME9w5zy81ID6GFneYU/ia8UMbvCxqVa4IZMHpEt0kWvTkbcwPeM 33 a0QpHeVdL232hFX6oULJUABrFj92J7vf7/WQ6p5FMETGtl6DT+xCGPz2bLXTdRWA8589S/l9 34 7wTPNfI9UKPwqiw8OUHJ5PBqKAQR3iV6ygDsHfbAC4l468BoBjA9kdxECibBZ4Y/CV6ZHQvl 35 q387Qik2ElfIPj3eZYv1k14DejdkwaCYwbeeE023oPkiGlpMKbd0E5G0fo0caHv4DtHqPuIB 36 ZXeBp7sLkwrsK38/C+6oQpTKyI2ZYcmmHru6GxB+uwWN48mgPhnkdFVZm6zke02IIjvlo/Aq 37 sVLCVpNNdKwPnCrqTIPqTDHqEK/qMtYwjOrN2+KA1Ct7muIVIOvzJf8JeENCtE2oFGxt6l6I 38 rbMnPMqsKhaYIRaY7DfA2FDlpRUOCLaCp/UHj7SumMj4junHwJdf88HzU8ir6UU/wjPWk/i3 39 +hxHkbJ+QxKgtDN/Ep1OQC3gb0c+SSSu32gA4K73zl+KvjWjTCOMO2GjMwoBU5JvCgHlRo3r 40 DfLuREHYmLCwuiSpcMIxIMSViZ3x3u9fyp+k0V1NA1rdc/Vghaw0VisChaeWrg8lFojRpr9j 41 MbaY5kWCD8eN+r/4Xz8wSqrz0O25tBRN+VlFZzuSzOxst+FydF9P0Bdwr6e9+W9ZWjV3+Ima 42 Le4WZ3mJtfmSlD2qzrEHfzvL1o4NyLl44B9TlSxvXtuy4CjszfHJbUsPyOZQowL73Ti5Yh+o 43 jylJfqJcxdHU2gQunmtyU6fzuvndflhywV+CXGwaNT5uUK7mfsJSEpyxlYhpgbF2d4/sEfpE 44 Fv7U/xgEWuG/UvExYCa0kdeRXqQDBIcV3VMrngJ8nck7zsWs9CMvHtK0DZAiaoMGVIWyQD1K 45 GU1oAWrLsD7mqZEezAyQw9JZYoaG5UwAoaTY4Qb1uy6YV8zh1ptZ5JKvShheOe1UIKSnwuJZ 46 jhNj27Rv68OIF/wb+bnd1D4B/hHNFa1upx48OjyyXnJlvvDlhBPFXEqEdcUMyiVkZ4Gv2yPF 47 ug0qPa9WjZsNUgzdKL/7dG02Vh5iIK303NnJj7ok2QiLAfHbvTug9Iame7MOoUGXjiH3SNzN 48 dZ/ntOzBPuCCqzhdDzMiOUXQcF7FLcvZPT5GeyqVQya50zVxWOwzxAk8frEoMsJR3NBjWicq 49 WMAqXNu9ZbQrRl2ZhjahILboQn2i/4g9bZCGhxpZJAidDHPDH6Ls7oAXXdYJINVzf7QhszLl 50 q9WR8IF/TKTQkkmhp/F+ltT6OzFp1bw7PUD0nZdqDCyHJhsWeya+7mzZIP/rVke4YlHKhdjS 51 /pfFjnIKqpvWUbT0e96w5b4840o4BwfpiyAziFke76mV1GtlY6Mk++VaN/GDfCcOyoXfEAph 52 CDpie9bRvf9ZwaIbXmbFytbFrFrSHgj4vp4B6ptwVSLnhvqzUCearsH4Ps8PeerlRTzeNoH8 53 xpcrRR920H4uO6NrJmRgn5Enoitvkcg/Nid26rS6kAz2kAAEFYXfEoJZLvSPXLqbErHQerGC 54 2NygIUqs9pgZQ4ZSQD1DgsCsawCSlyZeDhuTsAIEsvE/V7OId8VsyWnGj3Fuo3s5DdgJtXdR 55 VHhgBmFS03uTHBUh6eJ/JAwGc0jmP4b3sKtIZ3VBs0cCxafS7zH9JjOwJwffJVYmYUKHjrrn 56 jasGu0OKQytnlHQ+qUajxVcOJ3A7Nfg2eC7e0S6w8FMYdKqZGEV+D0ncGJ00+4Z/nddqqxNf 57 xl5SjOh/dhtrbnJU614qr+VZn/9oNQ0fByTBSIn3hi8XfD7fMTM+WaP/rlydpRyTjhf1L9yq 58 vYVmC086r5tCPYaRR+eIrgIQoI45UNemKXT7421KxKF24SC7NvYryGE/kCVT2cfAh56qYJ9a 59 tSHztJSViVCI9rjFuwf37RQ4Jj2gqoN6+Gl5eZeK2+ztL5Nbg6oLP8AQcAEYguVpy+EACdc7 60 +f5JqUKG1E3rxDGRX6FAs0MwOdS5IqjGFghPfE7eEO6liLas/buMfpskXsXjrMjlJGa2aHLH 61 IIaObhsiGzueTJCMQT4hGoGU2+U2G+EUfRMQ5wQgGpDyI2lZV62x9bj/cWLFoW/BNcVcTbwe 62 IjLBU9FlKmjAHNsIRMBZ3qdm1m6PtYzSHkFoQ7+qaQF7EjjM4a+9f8ZLCO9Jvv9YQFxFB6JM 63 eLrYqS5F92aepaK3/DlOIuN5rQa2bPs98oJJl1cXtX4tI0IV22BA4XdipNMJNrhtJGYrH0ga 64 FFqfbIkrw1NNnYth6PfZjvQUtDYP2S2+wMT7X//CTvI2XjRSJPGUvOUYhT516KVqdiPDL/BR 65 7pHW9S9ftRJZ8GvOo2gzG50IKyOh7qeiLdXrpIJtmBIkOQ+dK6roOxnPzsgk5B5qas0fKbon 66 uk9IIhlmwj/kc4tO18YCw0YEH1O1huvNwcJHwFm/il6ghe4R7FzPVNCiGeuRmbnQUjQLkH44 67 i0GcRn+czRICE9SzUifY2IUP906DZsYGXOSVOy08oblnzKCn2qkadlCzx//sH2inpzpOg3qG 68 JngMG5aTKtWU6AFdQTbkhWhdPjz81gR9EjT07JKTbnFOrYKyyY5d9Y2HT+Duu/8QKGWGYjDc 69 irZuEqiUOJ7bLXX8OUykUa0N/RK4wgj3tqUbBd2tDFKfdJKadEcInaYpcBRf8yC1wPtyt1Va 70 drbkhRKZP1GTennu/7APQJ0a70taKvqAz1Gv0M8jcJSqM+0GyNY1fss9ap7MPG4ese3y5J0v 71 ysv/qhUSY1hGC+UZN/Zsrwg0UOEkJmFLptDNFIbaxPvw6JV3mVTKxE3Vymqy92yM/QeYNmYo 72 7JKcL+RQAw3dKBB2F30Fy62CGGqZ7bqb5DbB/3RnBVjWF+yFLtpY0bEMED6VAiQ9XSCMehGl 73 X2LSQMMDszBx91vQJLrFAIeZgyY0k9e1T54sZh/8t7YZaqmsOjz6bqbXbaqmHaNpqnuQEbs2 74 MCuJQwUQI8lr61mMFD2gJScwPO1O2Dwn6+yatyuMrTNBooOlWqprgAs+kDBOx0XHcXGILnUK 75 7qdSRyU6cQKf4ls9Hd/rbgpXvufgxrbKtHDG5YiHo6kXlK+X1M3rlyI0BhAkc4xjpp9KkKZp 76 AKVdktBDkrXPQarBmfLeJtfnRoZJGzFrbvL96jwJ9nyJh9bujv10TTGPBQnNgFgHaddLs6Hl 77 dCv2l8L88sTAoTXMjXGEG4RY3LqsV8UlL5O+MDtYNCPd9+h/oW3pqoj9As19O8eGIXoS30+d 78 h0FfbYYBn7ilS6DbcHDslL+Q8NdICdPzO4tsZtV81XeOz5iZdiThfb93B9oK6a65jhy5AoiA 79 1E3Fpc/BVhheJOmKGku0OJr3AMfcdFJwlJ/T5598qLom9wVeUwr7d813deN90ypfLmwCMVNd 80 DuhsGHhHpfuEfDNuHiFy4Ea/wUkb2DUzmOxy3dV5Q3a18UByiwo65JVUMg6itpaHWhr3Awxy 81 hkd0zTAszV598KFGuv0htvjkGpZ9RygutBLF4d8Bm+CzW2Sun1tMEXJwC/lBM6/4xzSuZkml 82 jIId2wzmFtdkZ58nTR8CZf4GxwQSUC8tfFygXvCH5V+OHY38IDfUnpvCJPxq7I/AMVt/4V+C 83 lineZHemgeVJT8Htae/L60MHLclL6dm0yVqT7fz7o5gDBsV/UhEstzGMn+/kyhRZONdJtIRQ 84 jkncy4SDd6zxCTXPMqbom6anxjlLe9+pH8Y5uMB+prDGOaWbtKaHpP3dHgsdVEdc50qGyr74 85 d0ONJRWFzU6Gug3scd9CPxDsWp42q5DffWpThY8tBM4IwkfCx828diEMndxSQRCtwEqzl2jQ 86 YknVbR1w3FUwW0LdEBfqB/tZZe1NIs9O43JzjheVQ4hKKqpJcdE8hd4PNEltlQqEdRkcOtFh 87 j3Hx3SgGYbcJlH/pNOB235e6TrZZ9ETkCDO56/iYrp03zVUHlsRPxoI+tQxk9yi/LLu8qf2l 88 pfjNmJgPuxk3D5MKqp1CUxAouSQ3mNCdmjT4UYhI6XpxDQJCEvFfhrAdyPg6M1VzxtDETxma 89 z76YtdKmP+21RwNnJDP5tF0Z+UBpPy1JvgIZ8YNbg/pqxDWby0lSmmYngfRv9M+19PM6Qxw0 90 +MbXsJpIQrMi5MHu2c2ApRKzbaizzwYSjTr/wm1toiOtqjRZIug6hhRDdUN/clQlwACMblwG 91 ZZeAGFV7jdWOU/9FuoWk3EN0gfF87GPR8aKutFwF4OaqVmN7Al3l8/laKRMnijjeOiGtRc9I 92 yBqYx7iI9BRkTxSpna+CV09H0WttwfQeN6XYI4/6OI+KUE1g7xeB9MUXqwFIkVKB+D/G+6QY 93 dUJJfwHy6BhmoN3daofVbOlFco8hS1Q9mWKr4onTa8RLQ4rRvqCNy7nJ94ah1ouIWPQVfm+i 94 JTivdW56FuE05Inqv8lqAoZ+5g4qBFRa1PaiHoi7BnerwC14MnDdlrqEQej8yhcfyOu4VD1f 95 UQOXj4rmnv+rCzWj7hq8bbvf6ZozWyGxKJ+xa4/PrO7INLk3FFJRbXpG3EWuj+Cmf9dbFcJ2 96 ptngylYK+0tWOy2PKlq81vSZjEetgm0w8B/TXx8AVKxSBEjF7qiPWF84PYBWVsHYfKRVmPhj 97 VxvEKV7A22/TvDithXlhaG8udacAV0ZOsMCG5D5HHHbsLzc0fTg1Rav8ip+vMrl7mHSTq9cy 98 arHDD5d/gtczMNJOP/hCMhkGPs3R2fQ1G3+8bBNAkPXeVXv78NJuwBUiDUoAuk569RmeonD+ 99 5vVAfxCtsMqAyQP0AU+o8wtmr3/0mDlhRpZpT9mKEFXHGXz/c4XW5/1KWLWy8bf5oXZ1qGqM 100 MfYe+8pJ6wKHpoWH3Cg2///6CH/rdEFMBagwPSxnn0potUJ2MKd6MD8VfHR61z0qtwmd+lFL 101 Ufs3699Meh+TqSzd1dKdlSYAJPhrV0yBtxsi1JEm+gCUWHTQxn1TMMXfMtE43E708InED7vj 102 o9sgxgDEgSxMpwusvcEZyy2rEioexATvV5KWlVcEZDs4dC3LCqm0YmonZ6dzN1Y5+8L8KJHe 103 shq7km0dCFEf4+BCOFC1AwJXjMS6z8xCWgyWc94g+EXZQJTOobNl4pHLjBdyXeXsHb+QA7y2 104 U5UfWb6nGp1hQXS2jhgNuVGck9E71wnE6+DvqP5qpL5sY3Wiwg3Lgi9qY/+esOdKMYlxVz0l 105 xt2ULy7Cv+kXA3uI/dgVWxpGQYE1le9dvAPbvzuQv5W5XvYhBh0sbftLNHbn2cCmVmQcBc/s 106 aoKDA4Blx+KVASN8L7Lm+MqlFd1fN+nSQ1yaGV7YdzHU0HqYpShymfjeofetRnpS9VKPs4VO 107 Xm7v1KRJYQtGDW03NciwIvxBdqvF4mk8K/J2uYqyrHt4wxuFdvZP137WQUh6QMTRiexorifa 108 Qf6jz6hzAt6H8KuSmJVUX8x2lAmKfy2tPJtunyJ3/Gji/u82C1TGW9CVUD/6AsjeQt4KMdGh 109 asODe8es2mhixqJZRw7Bbw3TSi+rKbKLMiR8wKkaeL9vTu6mYlv7oATLUCcvZ9kiqfxStusN 110 X1XUDfF4bxKxEHhkPWXx/mQ7kZEfgCnHVcvJyryA4fjcIeueMTV0Tj3eRGjFZRHjE0Yu50hl 111 XiL+jHSaaHz9MYg57XiGuA4xKYY3cNDLW89tPGDOsywDt4FDw8nfX/HDMObkwwetdb7hXwDs 112 IGzMGjb15MPzXkT2oW8p+vKYDqL6lyNwBmfVzEBnqpkjdfDkajoV6PCqSIAPnJI/yFwSixtK 113 zaKPE1WjDZt+gKNkK6ZKDcliY1JGAfY9v7uN9nLP+AZhBfxQyaaWqJnjSpDKV7Q775TxNmaq 114 dgain4Mku4NHLVYSOK+WCs4cvD5Oej4VjBHdDDOl51+o3iTObE8ZWZM0udbWRFn361PyYdJo 115 B1U7Pm0cytE4wvReFi3gOIvT/XVZh5HVSpof9ngLHLdNoa74VmSpVuIY8ut2JEjD2mN+R6Hi 116 AcDcEwXwHGFV/GjUadfoasS+ah/ystD1TudpDABwvwRL/Waelca863KFW89aCT/l6O46fqN0 117 LAP6syG0rgbjeq+HEoa8c8xUm1DQzmUBzfR+CFlraIxQ7sNR5tE0SBCoVHpqVGiUCapFd9II 118 lptqeqJKT4ALeREkSC6ql8/hGNueREiE9OB75vE+XWaZ5l50JZgbogEuCocCXuIMCGkmQV9H 119 4jzD4xfJXg8vSjKZdPvg+1801MT8oz/FAp96I0rS4TtMpWNVyOywGqLSxoqtg3wzMzfkI6CT 120 ttKoXYcuU5gA9BGFLhH9lKqgMeX7cq4p66wmbKzXP5jp6Kl3ew32yvRkJeCuvSNvstvaou21 121 eDYV8OtHQPTph/RiKMi39LYkmGFvC48a5PDPXVqCSN3rEtsfE2DcIMrCHp1XEYOEjQhv+xnL 122 iRO41jALrcmnB7T0/RF8qnm6sWERHZgqoGnvEiEDAAuEgt9W74RlfKvaTnwDnh22fGmBi0ni 123 jYY8RRLYhocLVoJc9oJ4AJjYGfMqTRSy2CON5Ik0iKHJu6BJCELDufvg8r3sYfRstBNBQzZR 124 DTY/hnAKI0aNP5OzOyPwCWZLhzadYw4RWHvizL7uhf7WmktiLNU7nuNMa+YVLBjZ3lTQm7aG 125 Pbr86Tub5ogptWBodyhOLkgpJb3km+0ySKyT4m5dbzebi6v8UfdJgcSx5CENfb+DN66zBEJl 126 Fb1fo15hzSDppM8dbwYL2GMJqIshIvBH9PUblydF0boJ41wI0uLD/bg9WLlRI+S3XXJYai8J 127 d0kJF5/24cK7TrlVzWoduBm1+Lnu+YLOwE6lrso01/YtR0uHZuM8XptvZgaN4fY8yWmGL2F1 128 8r+JowfPCMuACPxoYntD/Y9E35Zrm2T8/CYW/t0jeZ+EUmsyDm3UEKKjY6YCrUdnTwI4NbF0 129 0uoWGf/JbL/FqBgojNaLxLMmMWaNxq7OrHgNgHmFFXU08VY32/67oLoSre1WX9U3OM+9LJW8 130 nstHYNYE+2RMaNuynXbXPpqjdVJfw18gkRLTW6/UUpbsX112CHiphSpFH26SPcYbccquMF7u 131 aTxJhOX016PH7tCaecQTHZPcEZ4qZJZjRx9lLttOjBzXh6f19+ZQE+BRK7FVUo4aeWHYoHVZ 132 38f5UnW0ITDr1/ffGwm8oN7vx0dfVbIISdQEVeMbqv1Y18KYBMb8RQrqLA8P2H7mbCZloIWK 133 DnbLzayPX0/1dJyHxHbeAlcXyS3ySjGQpHzo9Y2GzrFcoAvJJFytLsxDPDKQ0nCmMjLADu2Z 134 PGyTWgTwblV0abhnFLhVcOzgPmPWgr2R+nEhTcXwiBA5slI/hVp2SH1NTtgQ0haXeHTKRVnx 135 OfNVJ2JmQln/o/BJZrA8kHY9MYN8mWrCpYm7PoSzboQopfoK1FoHYtX9jKB0PV8zCjsTz6WK 136 aYrWU1MQym50eAQsluE/0MKc/4vMX50KCJjUSOaV2KlRhuAT741oWRYZTJxDCHl6MLEJANJ1 137 uGIB+rIzEt4/WtGNlaGXpAsPadCkp+tYqd/KB0T68KPlS3DIt9lBjZpNHfdT1YqgCmX8WhRM 138 2Ab2TWOVVrqVUSDIYcjxTbLOPLALKNxol24Whovecm8KnEnVZpsUr65rXmkubB8ewFvtXJaI 139 riEdnIqdrHPNNfKhjd6u65IbIp0rY/9jOJCSn6MdNV1fcLgjapyotZQlY4OodVb+XF5n8+Pz 140 leZ3okUGwO04LdHbgDYx7ubDbV/mb9BxYZ5xZ5+1rbCP/Gc+xo41IuPSrGokN63GjpvpWpOs 141 lvHLdh9KY6XQcNGNbYQrgiamlF5J6Y45OSZQLjZk29FgKhyz0WReqy0j3OaozoLAsNKut5fy 142 8ObpdnBOJ1/FQLe2KAZEBD1UXGKtkSsyMgCfu6q1KFO1lORStTpPLLkgGbd9wjh79Fa90ZeX 143 teqt1BX0iccvJMax+OpqiLs+9NbIPVnKT8o7tg8zeP0HfK9bCKUApxLsnntB82KrMpHXcuUP 144 Zo10ywnEoTFyD/dO5pFZ1Y2M6uScRONniL/niHG5E5CqkVJ60VFNQw7FJD1AHCH33T4BCC0Y 145 3J9GG9r68+DxdnmReUxP29ja0/e0fMzXiUB1M9JBgfXcI0XvthjblHNH888j4TsshgqOFsFF 146 TIHESix3/WlHjYGLXhWpjINzXC48R4STqwuqhlCWAaJtHRSrb50/ef1snT/pqoan3C5qGl1v 147 WLk89WEMenrzjGvUPtwXMg1eD7KyjkoSzGO0eczYyPyfnSLjuo+GFK4/Q1o/Y5f8zrlu2be/ 148 OkjtbfkUNt6ufXTzP4jdBvj9c6afIOCSp1L/5jnFGRMIQrSOoRBiXMXlQMDTGPDSTpypdrik 149 YIQHs7OooPUvAABu6OVjcJdS7xmrZbOJTJJ72REPE2K5M6gGCE+XZNMYGi5rJAoXK6G7TUG+ 150 cPl47pW9BIIS3VgIhFSEqrrKt5VhNgf/b+UDvmFi0mFGHTE35icb02XIAvvrslP2FYB5gcZZ 151 k9UyIjdXK2jsLoJxZrLNWS2xKvwTYBpwN2eTTq198YBoPor7/5MrO5PQql2oaKdWxPlJwseX 152 1zkVKr+Hl/zsQyn4vOx59gHIPkZkjoqSmB8Qlq46wbY0QUf9ikGQIuo+NxQ1hnoEjXSydJyA 153 SZmXVvagsNs2CXcmITtucSxPwUfgfZ/vDCmyvw1nyUL/8Ea1EYI/nlFX75hW5OIc4kq/gYZ2 154 xHw+MGqfUGtU5VM2onRtpOldQLB6L/teTKjERyYp2j0BYknZ06oDcnB7w/U2qeeHgVlRJ9lZ 155 eCBbT+D/hhZTufSAkCZIGf9Cz5VKVELQZfdwZhsnBRYPtoHVNicO/Dn0ucWhiHd/harq2d0O 156 p9cWtBG4Hv+6gBrlW9n/PfamDwYpmMsXQXZA4NpxAyaDshs8Lj3Ww2yTybI9ZFFpcNPfpchT 157 QNkL0ZEgqgWiPgsLUuzn11nFydix1S4EmjSbEWVRge5WO6pmeJXBMVs6T9iNxDw/PrvWdeg7 158 PZMET42yo1hRDqXJc2lEsYg1E7t/JqRHpeQ2ZmBM5nw+tfo5ANev/0n6KdEhIgc9wN/0Jmsr 159 n5j8aLqhGGd3WduXpD2wHw49MCU/76u8Q/F1rduZxbCQWJLHW1hPG7xpySahVVXm8+2v6uYy 160 PbrfdxOnvm5djFPslaqzerzdPGOsbn/ZE7RMtgPojVJJl5+Z0p1sTyeZG/Uy9D0a0bszRAFS 161 IIt43ifNlO20VbZbhx87jRBhA1ExZxds0xsdvqg7bHO3NpdjIKq9hbI4vS9JlzWTtbG1+22a 162 mQw= 163 164 / Package body created. SQL> show errors; No errors. SQL> create or replace type body sys.wri$_adv_abstract_t wrapped 2 a000000 3 1 4 abcd 5 abcd 6 abcd 7 abcd 8 abcd 9 abcd 10 abcd 11 abcd 12 abcd 13 abcd 14 abcd 15 abcd 16 abcd 17 abcd 18 abcd 19 e 20 16af 370 21 B27zXNplvoaSoIlG/gzMQkcaSQQwg1VUDMfrfC+LaA9rHQf16Gp0RNwA+iXo46MoK/Gwrd7h 22 cVOndOQQFMZCL+x3p+C3r1sXis4FscTVzZdidMjyTkQ6gdJzMlQ/+IinDz/YQacP6jgy6eNL 23 CGDjNpP709bs+/7n25LFfDb8cItNEOestmvjmykDE2/A/OyMp+6WaDIHHvXTCa/tabo45/+M 24 RR5BNQiYCoZhr+98u6ldVB8C70DOKrMZ8HD9rET+XwEXPO5DA7nQinYHq0HwEujxVc1GRUpI 25 a1wcmroZeOCsUX8jzGCE9xAaMBL/L4gYw0BAPKwXPHIzeyFOQNLGYB3Pmdz0fEBP/o+sARZf 26 7zHcRaAizdq0KCs6OnqD662wIevJNVQ7CkEwNqcLYgFIWv9O8oNwH9/b8XfOOSZLyEGkhYEK 27 WK/URJf9OIa18sYwIwshe4+x1qGFQ8rQrOY5m+dXX6okdwjluwexPUlU1Ye3EDiK7xRHXWxU 28 hB0yOf/UVGDR/5PSli8I0ARYYRyCKYXJjEv5tYbsaH7kN5lZs3mXo6kwf2JsXDRn4TLLmhwz 29 4WrpaKdtMOrRBhC+4yjGklHtR61HkIIBcm067xomNayXBKjoWrtei/C+/mqMuKjiHzssH5Tz 30 Kx1cGV96CEKZBAZwKddWo9rs7Fog9T/En5MJRSMNB/s6pf/KJkLcnMJ5doh1WikZaXpZpuaD 31 IPkvuPtYwS6Ysxqs8gqjqFxYhMw1Fz+RhaSpVcu+AFtoKaPdwPLCOoUb7xP0KrIdy6voj+4D 32 H4qoV2TfxlxYuWwchCd5tp/dqIRt9lTi1PVAeDCn1lPaxmyohMFID9C08h6gJi6h4JIQgf2r 33 r2PC 34 35 / Type body created. SQL> show errors; No errors. SQL> create or replace type body sys.wri$_adv_objspace_trend_t wrapped 2 a000000 3 1 4 abcd 5 abcd 6 abcd 7 abcd 8 abcd 9 abcd 10 abcd 11 abcd 12 abcd 13 abcd 14 abcd 15 abcd 16 abcd 17 abcd 18 abcd 19 e 20 15d0a 459c 21 2CGyXWhmfQ7EGlo1OPYWuXrsMGYwg80A3sf9gOK7Hpvq0rkb6WVrlKRhho3g6vCF9yF/+jhX 22 hCz4ARinEROW8U1sKZFOxST5KpKiLMfMiQsxKzHTrda8UBEhqWAdKR7MWkqGGfab+MD5Lt/t 23 zmK6NDqaPdfSz6c7nAMebX5V4/Fg1sjO6VccgO0RMPI57o9XdrezV7lA7fpXFPpdV5kPAlWh 24 q/ErqxRyA02AUaioar1nnxEIlySgjV9v7wgUlJUFoFe7hJ7tLhXr2NqIF4oMichSMOZ9/hQc 25 LDjIP4kanhuySvio9K6i8KAg7aWUrT8uhzaGuZN8GSCkekK0K0PrUleKjSrm2elqccpojVLk 26 06/1hlLQvHl/GtuWB6DafYAyESC1oRPv0SL5rYroMXwERr58jHBuYN6OKGx1W0CfAS/LRAnA 27 /Djj8mA1eI6UQnCSCFJ4uR/+BxXdhdlwDgWrhR22lTCP33RE3v233Ji7/61B4QB/jgoCtoQ+ 28 BLVw8kqUOQC7SqrfGeX5Ij8WsIIpQQLWDrjU8Kj4NaYy50db07KuBjSjjzc3It0HHxAEzKZV 29 ytNvPXmJIs8nzyAtYKIqK4hxf8+71Lc45Ss2gFY0trdt8v3rLrrbmkJtX8xdd7GZ0Emwk8h9 30 3ldKhj8EdGvltw5PhWtK2CbdMHq0Ac1fhzZzoVrA6n/WLVrUfXTIGXCmVkl9/tcZDiyDLe4a 31 mgfhVTB1ou24bmwXhhHONDSmD7OgkD8vshVBSEFURJ8xolSgIPXf0av0LgUiw9tEBFx8bzIS 32 OFabM68Us3AlKCV860v/xbgIIaEVQRe45GyQUVMT/vFyW7qtzkOpSEGTqxdJc8qt2Ul4h3sM 33 clEUjNtt3VRs+iYAllMCUucLX8+ksNr+Um4EV/63bfy9Y4B7QSFtB3OxPfJuNnKEbWUh6L+/ 34 BcuhSmqRJa62cQ+cueelxX3thfGOYUAh0xSmLH2Mr4URkP+iUOpkBNWMD308JOMJmSiH5hdQ 35 oSFGWNYzxWfQPkKAhMisWXa/6+oz7CmkKPGKPQ6qq8u/fR4DcLQeTrJa9MsRikAh+yoJozXn 36 fC3KU2A8pOg/I1pb7wrYkwQZ/ZFIH9+FcZ0aIAfuCiH9W97o3tfQoO3vvbIaw6SrOSu97GKO 37 LKC5sPqX0i9D2VayW4ydMekC5x405AWaEesGY+VDRv+6ArkYsvpo4WIxRlruPDmz9ahwZ0UN 38 cIndEkZwwsHu9hcF4FHiaNTeN19tagGYrEYcNOMVnCoO+AjeAX3Dpf+XUIwlAW1rtsuHROwG 39 GmBVjkVgVSl/BdHFPC6+4K3ValAqkrLAI4E/9gbNpFuIAevzPTJla0+moptiRPchzuE2iSFa 40 SfQggkMSTPHLCRedMFOY2WzVtEB0LywvBXEuWh/nKpyVSUk/yoP+uOc2VMNeFKVDlOdENpXj 41 vpQOeXryDmTpQ7KoFdT9XNAmyshJ0JvRy2qc4AmeY7ohIEjas6Xpb1/wQGf8WdZrw9lr4lsS 42 W9C//ukBYXBNkoFGv/ZlIXjJtpb1Ls4C3OlAz8QfPET94VIBvI1KRWsZdjvsZsVicwm0K46d 43 dGZeewiEkYxSHKJ8a2Ys0tnaGYZWpW3HdmR2FC40JxY5a+Msp9aOsWXL1hQci7MU3Sq36CWO 44 1yxF6905K3BWvTjexRauiNG2LeGRNso7zHcQ3IDRiiRwc/fwgTflgNoO/fV9D+gjrweHZ62y 45 oKplSlsUQpCKNHaAmqbQl30jY1DDmVmFWpNRh0EChsint9LSiaXf0PXqBsVM9L9Rhwf5QGEp 46 mvVbO8UwHBopMK4/tJwsy3vku+89LDx5PQGHoeYGy/3yHMRjzZMdGJD788WfGPmzF8lbgsc0 47 8ddqU81Sg0N7i7YZtWg/6H4Yrhtq0bRNU2iiMQRjrL1Q1JaJkSX6ME1HxzQIs1dXY5cU2Iw4 48 euNJoadK1jjTS/JKBIVSMKuyMbAcFsSGadLsDchL6eJCqzkfamXnAhUKh81nsolFFu9ZC0yk 49 LIsUfU6SZyDQCfmTyzWpmwfDJuosaDiC2BGCJ5zihOUKwkTrANbXYcVmXVN800Zga8SuDRr+ 50 9yLJdckTwdkx9QDvu9EfIOickQCYRZNWsNkkhSOSi8CLf/NPnQ/RP3LR6B4+3qsqczpJ3mH/ 51 mq7BsTHXOoojLuIkce1YYgXRdwbsbpbi4ov2wANuO8nZmslGPL4nBjjuriX/drI5OJZRzhUd 52 lFM/PbKAqexAo6uE8joX3ft9u2v8hK9bJugYPn6Pvm+3nl78WZOviWUKm83oibGfsF6XO/lC 53 XkVBD9dIb8d7a4pbvOI86woTy+5jJNjou8mlQHK/xl4HqW6Hh9H/f12qIlmWwR4kFH0g62xj 54 T2ykk5guuUZ+IWW1CcI4kcxn388DNO9FMQXtYu7YybvbLBiq9lFX11Y/nUFiCF5/DRUrzdWE 55 JlKfvP/isOoD5elI6NmBzwAPcdkJQ+kRT2QWIJc8qmhHxWEVOXK9dXheh0YGu89Sk/ZWoOfN 56 ulVmqftM6DSFzzd/fh/eEsFDA5Myz1zMVEiL6lGh07Jgw/tf3XET4wPKu642wZ6Wj4kDnKVy 57 NSSMDanxIej9CbTZlgUz+trT9gaUjZTU9Vy3K9MlexJxm4+yDTLXmvZTNSE2wwtXm6RCNB5E 58 Im0mX8Gpi2r+rLHfzvmETGCog5ELw5vc5mcqdei6RzmWra6zWLjsfEyiT6Yf+5lzsGW4ZGVL 59 UBimVDNFedyNPsfAtzLPwPFGJqgyZWiFH9sjPSgHIh1jftvqxMN8O+wphufj0Kjs4s7YMX+X 60 EJ3G1z+8kjOREKkSabCGX/5jjUqMNdVYdh4YUjHL+jXK/LEdjKKYkOuZEW+NkocELvbL05cp 61 OQRSaMlXT0d8I0/dfEitni1BcHa6HgAejuAIOcb6OIDUWHDZeunYFUEUlszi/XWEwxZNpO/f 62 FoVifCqZJ3iZKILZ6lGt8QPbQy78TH12mARfCjducVAxLBU3TsNBwR6wRf7UCz0dE56/7G5W 63 WvVRNxbZ2wY2mpENJxyQdlhMMqGO2FfCYVuJ4gVgeNOLgcqaCkMJUKFcTMJCv3+rVRzZkvBK 64 CmAkybUI22+Bt0hAsCmIEmhA3DCSul9fxfCOymrKDWh7BD97I7U8TCsqQMJgCgNFsRzJkT43 65 c1d9ONk1DJAsCWu2LHanuKbPG0hYf3glGz6kRo4uHHmb98MbjdExbg9eKjgui7Ee6S0tOCqY 66 GsUszDk5O8LkOhe2uh97tKkO1zkgnG3VjOdePaMfIOIriNVL74nyUF6xu0LrO4RF5Sj+KbUd 67 krU4By0fOv3qG0EhMe6htyX57u/SDVVIHELBpjjI4sspB2tvOU4vDlZCIaG/fap7oWpLPRrF 68 KX6tnT+A0R/rbXSOIBkxhBUhKYQlNkxZL93LhlQ6Nt1W0XYfnzXNK1QrdonMafE7q0uEOJOU 69 8q0N/HykH9kn7kWgXESbgNhpQUqVYpY6EQKbfC/E4ZVX8hesJb+frbDFoE2iZP9hjuBXhNUl 70 URMf9Q3YF259badc6w1e6itTEI5terp2RVyULEWJ1ZL4qdj5x0K8U6bFFra6pq+d0phSlo5N 71 mKMmWPhjKMEOee19pSLdtEgvCITcr8cqZYy2lnPxP9JuBo3cQ8QuC1PRm3+1ExSPnneFnLF3 72 082JpqjFVh2Vc+JpO1HXelQurKzmFl4KguQnhpZb63QmdrTdNT6g+gHFhvvzPQ+8rNtgkpw7 73 yhqRk6z00olcrNneV0fIlkS/7X2BklqsUm5Plw0EylOdk4MrunF0acWAGfw/8uxHDedkeWCv 74 uGEA7Rr94kv2tWpVcYib+S1O0BiYSdYbA/YrpLTbZG+d193/RzB/TLoBEHf/5P5RxMPm+cN7 75 XzOuCH/QjtBGVbGARY9Pgsu324DCWeQ7gL5KqgmkQ0z1cR+WS2A8FKrESBLC7NuVAAtxNeG6 76 3dxX5AHTsOToWtngM1llSBKLSLCTO6s0iF0rYI9X4UpmK13N4KFvnB79bPS6MJ3Q1h0lvKSx 77 zlYbOidSf6r4W8xJz///6mNiDDYWEbnHGz4OTdo1XXm/bXL0aeosGc9jPWKz/KTum4WWxY87 78 mo7zd/sIPrSZ1raLe9erFbGogf9fTBVdXseYK2AqrAqE0QDQHA0uPVz8ZCUW9KO5ijIzg0uX 79 TQREy6qezBxpOC2i0IPluP2Wod40lVWM9UbM+dkUfYBJzLTZTWA4Zhyxu32N6TIjsPMoptdr 80 JsTnz4aXYj2VQQDZXZ4hS7IQlTQkbDQ/DBhuAlXBk0d3nRjpoERhBogNEvNHwR+89GUCZz2N 81 VRaoalcB6F6GVo9eC4DCauk048JRQwUM5XnYGZbBsZ3AtvVOWjvTWYNPfJiBStd28Q1N3416 82 IK4vT8tEaLI1zwjAMzsp0YCn5OahlhcKU7t3zvMCKbovFJg1OlglcNFIwPQnPxB/+LtJocPE 83 kAZyP2T4w9+sElq6qj48IQpk6f8P3W+SoX4blJ8GrkFLu8bcWZQSooU//DSkGMTjcF8Z2ZX9 84 JcDRe62LG09CAleNkuJZ96fWPAnDI/6YEkZ3eqxV077C6CLX9Nnuiv4RuZ7O1+1PIvpHU43X 85 fB97XpX5whg2cevCh4SytCNUwx3dMUP9Mu1RbiMFQdFc0p80VHFyhZgxMtT3iUxxcfE9kp5o 86 ht0sqWGPfzws85GgxNyBzFTylFrvttYlb1Uj0aBXG4AN2YRmiWPjPe4ymJqFOjxfQAYZQ44Z 87 8l92NK9cfIm2QwpQdllWfgxxn18YexSkhFo5VQJhUpbKmpaXriyi5x1fzDsXCg0ay8p6jPP4 88 Id2/XnGsLCkdjXsZcSWQnuEXiiI/0oWfHuaRrJbeUi3QXeEYJy29gFDLqr0Pca478FVHfkZB 89 riQ0Ep0bA7VBckgEAxBnuYNqRzLFxx8K7ezWfqI1CTqjaNddIqL3IgG3sQcWBLG6aOrFRQ5k 90 BNDgBrxa0LaYdDZQNu2Fej1Oj25IfBTJsQ4oPuoLTPlOcuFdCcnaEGq5i+E0BKGh9PNV1Vzz 91 rRXxZfqKpJjkR6M3N5yB/NfyKqilszy/JKQP5YmAehpOb9Cjss9AQO0mdCJWyHmAfTVZ6jV1 92 8yObyvWpHAdSBfukVcWK3fCmqDCRhGhdO8+0i4Y7Tbe4lNvwqDZu7wRsOJb9ooQPyKiD6JR5 93 8lXr8XMJK5HHIUUsBirGrYu608a5gt3FPxjM+k94GEJeywMkkDuxuIHuzUP1gUHl2yAfRwNr 94 9LTjaltW+z1JJ9+eu3c6GpV7vDxNq9U/wP1M7F16Bb6DBcpDhyma5RmT/yllX9fKMD2s51r1 95 R7V+TsgqX1ZpfBoDIKY4Vsr924sthjlrBOuuEBY2ZKw5RWA74bV6gb921l5c2w+dlA2DEawt 96 gbDoCk3dGzOunSwEFnbwg/+yxJki0flCzlGa0+oI8Pb5O7mResmy5aVNKOdEEX/h2cNU4TBV 97 SMT6/jR7n94PPLDv+35UE0odygrDr+EnPBY8sUFpJbQUZjOx3TfCOfVlB9I9WHQ3lRezXn9C 98 G9GMOnuEWAGrHqbLO9ZVy96HWbWmQOtLaHBXa8wnHKBgF2S3TQz9BAc10PmSAeb2WcKHtK4d 99 m+0S/TWvnXaA3hGUL12XtGSIKEdruvERHF1sJ/HbfZIhWzVNZvrIVLveayDjmHbx7suOBvfb 100 04GTNTe38wIppJmmM68/Hk+ytgA7I+sl3wW0obeq5vh/+HDtHYfdDxVJHmORb3ZnEIKQsOB0 101 PGpU4Mw9SqrRJx2H+Lqtwloep2i1zjKrGyRp10i17r+lDC+OGbdcMN/MqqxJNUdTEZO43WDu 102 RKTfZ20QJGKdd8ZQCd2Z7dhz3EDqz7MONE/oyxsSRU56iPDx0ukP0d5WaC3cvJI5Z2bT9dvG 103 uZnAfjvtcEmrM4ez6NA6W32y1Sp2qTKWutdkInHcsQN+vIU/T/+xfYqacsJwtaZhldFXNZwV 104 GShHy1ComHloPTbuZ1LK3R6I29M52duZaXLxRgDjxmR/hOXb8ZdYCcu65Zd1l1Trxjjc8dmF 105 m61+5qx/ZWvlhPHdNq4rw8xfP+MT2yiFRfICfvh5IsTFQ+pDdpmh5XHMyOrkMkmN4S3B499R 106 FCvJ2C/71Jjke0szs7KMPwwvuSjYUj4gCkHnL84zHUg1HcWyW7GLpngYiYid0ccVw3UTQwaL 107 yC8tCVjMXmFrMuzylFYXtfOVOCEqmYSGMdfTDShX2Fz6JzNIKrWdiArhThkjjUdkmyNqMJE7 108 l8mc6/2jHRtuYZwnVi4M12XIylDtMQcX3Y7Zi5xQvFanwQ4Kud0oK8x5USdYgarG+gNz1gcc 109 Yp54noti5bKh8fw9wQPmFdKozIwoRc5fdsgwio+73dtP9jCmtgjzf6PuLeCJf6eJkwtOyWzD 110 K0c6KkJ4uhdHich/XuYDUDRsfnEV0qH0cZPf2ZlSmEnVjDtBfGXaZ/fejgNZboo7NNYvf14R 111 0rtLPXx0F/n4ByuL03zD3gsvOcyL4s8vdqluNVLIYPSv1bJKO/UryeKNhGRW6QyUAdpl8t6T 112 LixwdagmDTJf9wcVAXpoOL843MplUiSk9C/2c8FMRa2/MnozzCQ4Zq8mihmRWprJWTbXHS37 113 espRqCuTy+eZ43k2QP6sDsU0EPMEayWxtLZmKw56LV6lXVFowhcpFq1E+kK4Ql62yNcsSbUb 114 4vrTiI4mGq1rZYhmJ1uRZRp2W6cHeDCH7FDpn+wvqhEAdS1SZ5hDELpOp6LthtjrMez1lWM7 115 rW7dFPWuAd//hKACV9/cvmF7wO31d1Z3oFzovbz31lc0dzgWEjDLMM3IPFKJy6yzFo