完整记录一则Oracle 11.2.0.4单实例打PSU补丁的过程
2014-12-04 23:14 AlfredZhao 阅读(50131) 评论(0) 编辑 收藏 举报本文记录了打PSU的全过程,意在体会数据库打PSU补丁的整个过程。
1.OPatch替换为最新版本
2.数据库软件应用19121551补丁程序
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.数据库软件应用19121551补丁程序
[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/cvmF7wO31d1Z3oFzovbz31lc0dzgWEjDLMM3IPFKJy6yzFooQsEEJ 116 jTcLp96ysnGWkD3L7KdKbkZAJRslXf2olZliX79Agen5B7JAYQzEQ6cWmqiKnyUcGcP1gsrF 117 uSLPm33GxhjBl/Mq2ITGK+lsmHn6DcvVf7QhY3lgDGIidcuzx1xhIDCLCdGPmxXsQjJ0+SX3 118 2BqMiGCAt8/Gj/N9yW++hvsKr5tU8j05RT014FJgafiRgE51SpLUM4WpJ/pul6RId68SJsT4 119 bmg3QmEEZYg0aN2R6a8+GqytCFtYVdLDaizKAXhb10LGLC7IUOxLm4ORwJEYybLCYrOKdn8V 120 dIlt0GJrlEHpbHp6IfRNfVM07MJKLKuAzCzwrraOhlRBDatRvUOsQF8IpMHG2Kkol6nedZvv 121 AsAW+VrCyWh9gkwNPqXa4BRaNlqSz2lTi66SUnpIrUzO+8Rz1ki+EMPDk2qSHh6jbcQRnZI1 122 eWXNu9KAd+ydSPSE6JI9dkTfqpIjRR6KUocx7wcOSbFOKroBRtrqKS6gXbSdEjKEGeQtQTsw 123 rS77bEMbscHJoVkAAeK9j1aA4eebSXGvL/uNibL/sSzonFEY+iefrye4i1EJKMMI7EPTQ5HW 124 8h4xfgWC3injSm8RWwMByxiFFznoLfHoEWN/op4ZgOsU2hY19P/rFOV/5sMjgVlYkIh/DO84 125 TvP/qglukS0U8OBCb9Sbw21s+m+Z62KXsbjXGbDizQyN/9cXE4YgCciZ0qUmY2jjprDJoJbN 126 gRfTCf2Yz325U9ws+h5GPGFOeimBI96ZCF4ezdlSg4OM8ePlHsg0kA9y6rsXH1Z7q3UZymer 127 OPsl7M1ujFgjyxZJMqMvF/jvxTne7Hr0xsiTFcvJoxzdoJPTe8J6PAuhRG1DlX6hvi25K14H 128 d0NtppjSEZd4FdGxlRHCQdGxXc1+EPlBKGsVbliqfYvYTp+QRt7+dGsTvX3AvZ93CR59XD3M 129 1ee+ZrwYCdGd5ey8pNQpoXr3qCN4CAqR1uB/+hzIqp54WjcxnkqJLuYipe1AAkSUHSYruMVh 130 oZNlD39SGOE6a/GpsFFNqexpXYCOq0Ft4+y4j5cEcR+MDOZS+hfsS4NHzhkJdLm7rqG3SLgO 131 j0btyQVgRTXIwiJW5FibnNvKQA5V62jfweYTsWsujWXP9WJddZpCGtswFJ2/+F/IFO0x20q/ 132 hDR0f9VvR2C7fnUxDn66/cLTkNeZkBZORLATkZnLMiuEm/vFhdex86v6XsiQafa+GikRsET8 133 3kgDelwxO89R9kKittZkxZVKjEeYX9JqT0EjduxZuy+3RjvoL7lxF47tyGkFUyI6tFLIZLaj 134 xOKkOTfkATOcJXztQjOc5nDv8mRlvFThbwPbj5lEut2GHwuFxdtjasSBeL8qhWLWvnFUDBWY 135 kMM6aUh/LX5/ycFpr09WxBjmDKyuzkWN5F8UBEbfXlo+Fw4jjxxY/Q+kUrl2WWDtqa1UnzFc 136 lv7AWozd1gW+0wk2inG2+kQzGd/6AqexWeU1bW5752HXwFmY5YLzl6pyPXzGvActu6gOd3dn 137 KBo5ns7ZqgEB6xkSrNNIdHNjom98mgq5DsTBrXcezcFPQ76DfEm49/hhmY4LQzSNiC2sXUJm 138 6/yfZ4pVa037KR+8OUynWx8ieF/jEo8MbPG1JaqgHl/piGuPYoUQHdOCYPu0greZhNeug8XN 139 odw7W+UrScvPqxeptKdcBmtWszng2+L3S4hN6y6Q/Jw444YmC8l3RFYI+F+9+7G4PYB0GvGk 140 LLVo+q6oaE6nY7LbHUUA0uGzWrSBFfrcNiejMa0af5XCk4vfzuc6u/2OZ5qvWnfqssl6yZLz 141 OQZkrTHjxGDepbNGB6/IuWZ+IUetTkm4Lfp5avznqrJ4fz26jLIDfEd40dihkzT1l+HiWJ13 142 yKBwsp+0UfYLsN4rPp2UswMJYLrW17pJ9XJAEneurciP7gY4OLL4QirnocrE4btFwtXuu5cS 143 Uo/NAiI2m3dpRcvw5ds5r0+kKlnqRmB5T3zTTLXf7W5eOyhHTAhDRIhyysbBipKspEIIUMIH 144 fbTZv/sMmb9BhJZKe88PS00khjH1la6D+eS3ICC8Trp8IePX0PzjTOuj3TNblyksIiIlrjMI 145 thwk+z188bD5VGycPeR9w04L3Cr0ne9b3LJb0ADWBoMAQ+EVM9iyD+aZF5iOAzAtO+NjQQcP 146 fB12+Hbu4OHdRAt9AyM16RzWH5xBWtG/AnTP7CQAAEvkPESCQuyeQOYkSu+Jm/K6hEYmZ1+J 147 DPXkxPP1xJIkYvs5iXoCjrRjkOO041PJZeDaXHeEv64IQtsWbbIXZYCmjKah/l/8L0SmQA+J 148 KN24QZv70hKPrSShm6ZA7gwkqXIkKESyp2pes7oFDneGxnrjkE4EZvx9aR882a9tFs8ppzjQ 149 Az/PxbGEag587a1eJ5RlZyTyCfWB70Oi75BVpLoHYrYdRIU6EOXog0DTdRIYCBHMLY/+WcHb 150 EtBwXfE5zl7ZNxyc6YqHlD1yfpoQVZbpptS+38l4M1lRygD/ojBmAQZhEI5pw5BJJ1Q1Msmm 151 qCw4k1wQY42eoGZDvWpHOI4qY/DyGiuiD1ksnU+3CzpkPHVB5JT0WSBgBlIBKie0i312XqBW 152 sgEQBW+Y9Qu7IJJXp7B8IPP5sUoaDhVHSxZ8yc4fL2e02qoj1D2KkM4dF5PDe+R8uvNajTBT 153 mq16fXYiinYi/HYiuXYiOLX5PUinQwrr+hWrp4hEkzntZLg0Fiyp7S/PfOhEs1vuyPQohec1 154 Tx0OIf56ppGLgTWFVEAGwEaN1BmoQOd6MC9/Xf+tE8BYKlAkszwUBsdJtUbF92HKKuyEkovx 155 91JuSktoF+ghwvl/80I2W8xiqEhlzWf0l3FpHCa35fdQgIc2EOPyISVKLKOrHL7GnYmySkbQ 156 wF6hr3DxXSmUYKwkuU4g2MCfz62IrK8D3ou56ZU4qxuM90eP1wxhk5tEyU3UJwL8Z5yXGcyW 157 dpm2SHPRVJR+d73nXpUwUnOL3irp11ifAT1KRUldmKt+Z6j+b9WXyK02jX54Qq0i+o8nC3Mt 158 dTFqc+PS39EhwJjpww13MXiQpC0cR28zpXVwaSgzuBPGky+TJkPp1hnJ9UDbrCt+R2vW6fuv 159 plQqb59Y6tWuXHEh+ASFdc/gkdr/LKe2X/JPYudiDaiNd/d6CpxHW1mRR1Fs/1NiPNYPx28a 160 QWk5eQMcdHktynFHYRpYFAmmMTy+vtUPzJM0Og+nzXgT2YxurDmrAcsbFsEghypBtHnIDHpb 161 g09H3DWwm0YKDut1YW3sLYxFjMlTZqCQyVPLzXlA7YPJgllJct4YvIMbBsBlJTiO4dsrE0cu 162 lkC6LmG0fsy5AFm3uiDCzxqOSB7vQ+UOnb4LM8AMO1g4bsyCcCG0o7YBtkk2M2LfVCJ5DunD 163 IHcDMvqQ2WhNw27qoDWrqAR6/WSD9RD4O7ZnPIbSE7ulurmK+MkzSD8QsgfTbcQvz6lVlWv8 164 l88NVJfr4zTSfXpTCJ7ib2LiKZoqWHNgbWRaA77E+DAgT9icj4xy4IhBluKxA7Xi7nXW4WLa 165 XfH5vhQSmNfJThEDb58sAOIlrH5nrlGBZCOOVbnA1Ci4oL9i0M1ooMKXv8aoWmTJM8nkSxIb 166 247kyPacKu/4wHKa2ZWsn31zwAjuVRLm6W0xOiM9fvjvL/3CMkok8DoH0Yk20SQOrGKGugcW 167 765WhmckKL5sZzH6g/1F321Xeh9WaWv1Eq87mC0OIOjZlGKlqdj/mnLi6AllBhD1r7II9KHu 168 5H+FFwYtdtCwfEZypwKQLew/3EqH1lVEiEm9Sr8V6t5Ncm3b6zyHEgcFmSg1mKXtAPmTvJyQ 169 gTX6caktvMVI4eNqH6buLBBn/M9E3V0f1lhSPkFl6Wqsj61IbbLzQS1wnwYbnefF8Q86FrMd 170 oTCtZcKshvUmvCceO0in3Bgz9VyX1nJ57TDiXbql73nZpGAebEGERVRNrac3A2sB9aNMnDPK 171 At0+wDGpC2U0kZZTmadGAPTUofKfn+e5mTyMopx3+UlFYuUn9v4UnqkXYDTIGslZtwkmbsTk 172 9zDQFkduogiH829Bewj/ynoS0QGwlQbCGysmeti/SvEiGsdY9PsDUidIY83Kz7GfdsBjbJrz 173 61Ysr4ZWLn4Mph6Q7uJWy0UoMaG/4oLlcJdwaoyKV4t+dXimqt7qQAaWTrDmgOSVGXVhHalg 174 vs2cPgluwM1UUrxhpMeXdYKxpw+6x0oxM2BRHhMo9psO4dD+GYUWFzotarvtlFXj41Ctuql/ 175 R2Cz1ztRErpDrHEu2FcrHfAd/UQnDDt4WXOZ/b7tbQKA5Czvb7nduJTtdDn19kMPBu1rVkxT 176 iE/2EEmGm1JMZ0RXXaN1V+7CoWdAVonPdKfh1cqMHKu61dBD1B6q/COygL02uwNHuE1P8vD3 177 SEOf6mO8wtccum5ggbNh4Su5XZ8SwfRHZC9odtQVHCegamdwjiQATri4EClb3KfbjU9AHkpH 178 OboERh2BuqpHUlbJz6ClkS4Pv2/oU55/soqEYaxhCMy6f1QIAXREi868ko9d7rpqEr3hzG0d 179 yuZaul3xamvZTVpEkS2XnPGv6nvOVPVwwmHQZ8szLoRvZAchX3sH7gyzfyyxG0EF5u0WoYw4 180 eHk1oDdX9CVpzXulRtCx63ktjmXpq/SbpkZSwwQwGQ6k/4WSN1gX7emoORj4Y4YDw4dbuWNm 181 Bfz4lUskesGt9btsrNf0D1BFt5m+Rmgkb3lw1uKhHOgm/gPoL5xZpY+3djzqE3HlaW1irCnO 182 URhuz/EitItzm77Qqm/MbxlGmWHgolS8sUE7nM7oQCyJifPqRJdRXSGI40Dn+v4yCbnye+wj 183 iFgtLX325GzbK2feGBUONQq6jf5xi2gXOdZ4hRZPZ3XKIG3BlFqvQ3yV0lAWmjfAFqi/DGbE 184 SRjTp4QP1VNm4KZXbeLEovMR9ifDQ4JCNlFg7+NqhYsJVwTZ/HFZzPozWhh36D5y/42AK0S6 185 MbDpk/91FFJ5Z7pvMojao4ySK2Cb/sKrw4vL2Htrof4dsc5La9y49o1wuqs3DQGqPbIiqlUO 186 plPPN3We6bNy6gGGCsLu753hSIeN5EdOO3GnOwHWOwgNBbo2Cvp0lxzOAfcBAOw0Eqw08EfK 187 kIK7o8kOzVNlHU5D2BaCuLTQVoKPyxgNApLMD8m45AGddFivbuR292vFf12223NviHqgiyxp 188 pJ7Y/8YQPz1PeCx4hQNpHgVGoh6zfTxEmUP5vL5wCI3KtfJCxOHMSKJ1MoXAmRVEkBXgx5ia 189 reh3T9ZcTNlrjGmpTY/dzHmzfspsMK6aQ5AalmBncAOTCEYAIHuQC06d/FA0RaAMYWy5P+DP 190 vG+3tRVE4MAX01JjHTNkJd1JSMm4ojfPgmo7RDfhobdUrXqZ2KOF/jRwtwePViWZYe+2w+vC 191 YSwcd40EN3btt/Z5L1UwdcKO7i+BYnYorKhzPCH+zxGKsBeRcgj0Yk5Tv6fMoW522udaxbNY 192 LNHGnsiM4beSambZFt/1azTnksxyX7zZ9B3gO5tN0GihnfeAb3uD2B8aPaKtBuxw7OgRz4hf 193 k0FYDixKXjpL2ug2BbKSm97/BmA3qROQGxjfsoGlGgM6AZj7HoRQHrKPlplmJEoPG2AaLAzo 194 XLR7y95Pgm8RbDdnOYsb9su1IehdvV4bNOFSUKq7J6iGyvJ9U2CMIunhhlLuMHbQuigzvyko 195 kJfJH+J0h2Tu/IaSc18PQws1kvr8yZ8iqtoHDBfVwO1UtxMxmycj16mcBMhMABp8xxyaLTHR 196 pV7R8ayKeamOnlMyX/pCZkgy6iXlXzRl1WRHRwoDTiOfC2QkPmGUwZsq2Ku9MXKqbnR4e4ZS 197 fD/X3TDK0KgB0eVuXMllRs9H9ZSnQYL1vP86GxNTD5UmISlC106ycZVg416bqRoITaHF/81h 198 y1bE9SL5OjtOdoD0g7YuiW+jIAhIIKwKQaHBp7VmsJqJBQwWDrluSHB+Re2+KYJD2VSq8a0s 199 qyIxvwReTFEoURuuE7JP8cgn/QBFPRWct/rI6WuquHapWjHRwKzlLdmxbEq6QUxIKdKbToyn 200 2HdEQ5+6ktRfGcH3QU8/Gs/51fjo9lslGBTMWBueND1twGHDv5OAHZVIdUOOXj+nC1ctePy2 201 ofntu82lB5c/hJHvycxdYz+6K8xqJlT/EWxy4ERx61LtHCh/TLR4i6gafRY6yxqVui8HrvVW 202 Uni1XaEUsR0QbcMJlZr3frpNNA1ojxPNstf+T2vSacYPUHiQGWcmZVdbxJa5uJjvKDyoWUqz 203 pelvX67aogKWCTX345Y2bZSaWJWoq9RWdUjUBi+t8xGgr2jCifjmQcSJrboHXsIGv2vOWmyI 204 SKTVSIATr/BL35VvcdWLNoTgh1PsaBqMTYmeQ2KM4lQ1NDvjVpuOQ6+H3KM1769RSXtvCENx 205 9eF5Q2Np9QYRWN1gUa6uqZay3l5IP1tQwA3v9/MPZv/myg1ZTmtd04GEU6+gd06nz2QV3vTF 206 kKL7QXY8JRr/XsAGwM9r+hYP4f+34sahRMon3vheL9UKnRuWQZhxsY8A/HnT9zgwCPgqopZd 207 NeRlVw99S4/ax4W2bLxtZ/BWqbhbCVeTXCkdnsyPwAiLz1ImnVCe0h9NTM9OdyoPpZwrIguC 208 EDd6RVJRmDFq1E7KCdPOwI2nf5BoAncIGyE7hxO3jN0DcfzS0SS6NZN/iWrdh+ZIyHuZ1+Nf 209 zVMMqpaPUslviiVfanuioBASwqYECmwyGENA9ZUVt5F/OY1CkR0eVk33wZuRZXNg4qih8r0c 210 CTNvrNFrC9ZWP/NKrpII2Yv3SfZiJItyakp8pCN2gJ6P16HKDRgrWOdGiZdeqFk3PYtRzPyu 211 zELFwP+4m5EoD9PSFSF924PNuOHA76WQmuuvLB27N5J/AVaiFiN/XWNZ/2RBm+SEHBcN4W+Q 212 LG+Wudf1KoIeyKQnH6QF+KwSa8fHJEqgudLy6dNcqGuIN+2Si0IEqUsMcZJlFYD4EZrADLgQ 213 U+c5L8Iqtoi0rSS1ub0TORxX1o9cbeX7Vpk+HkV0hPqXEmTyEutFi0yNp95aUmRKX+NgYNZZ 214 V4Icz64zSnpQyw43Gi7Ad4KIAL3GPsbWghVvfdVAm3eoemPerenlRHK2dRh0UVZzFxNLiZSh 215 gfKjwGik4JEhje3lh16HPDPyyesYFWo5Q2KIhXFk6OwzMjx7Ihy+oXmndpjNQk7b3wN5XiuH 216 Ca0CViw+yqQtgAomrP8YtwCnzVSRVul+Jiy/1rxdyFSLCECwVRY/V5XQ5/YggOlipxZoYrLG 217 DDvtf3vuARB0wvKUK8orJDqgx2nGJdMUs8j/uvEY0luhIQTM3mKXJVcMo89gGiwUlECpjgRW 218 TkrDlE4U6pMjb2wOMFfuNa1SuBZYVsnqgWrkHQumJNeKQs6rKf7mikA4u3eiRbrU265D4Iet 219 DsmmEuX2D//qHoqxMSwRJV2ps2WBnA/lw9dpdxhdftdkAlCnsy8Onygo4dvmglKrTgmMrsdH 220 9IdVL0njOXnhsBKfFCrWHDPAOvdAajpkOGB7fUwHRoYIyq15H9nQTbNPQULmpYtHyflfcVZ1 221 rn0jYaMKbogKOoE6X2hWH3gDQyMiuirVl/pps8D5uQAMcTUru5xOHg8TzeByKwGhjXfeWAlt 222 dbCBxlQ7yC5H33Kou3Bzl9gaylX0Bq2GuC+iR+lYTvty2Ji4TTxbyx7lISJaGEnC5YnSKfqG 223 B5iYgE0RlS5J0GAlOj2KwD8qDwOOHiMUpxDXF2lJad+6JfAn/2UDhZvlnY0ecKJYO1QYL5OZ 224 5jjaqtYNL11g4uKdJ6x4bWzZQRWcl5vWhdpON9pw6/mr9bvIEKg9+Cap/aCRP2ClLnJgTKN3 225 yhVukBiddtuW5rQErpI1wIt+wMx6y6p/j76dzwYSp/DUQZ89l8JB2Q1TmCa0tnGulrXOJN18 226 fG8t9HwdZLd0yr0Rmk3kSE6D1xRodjend6BHp6EN0der/ffpibA47CYStn669PmkUQDp7jTW 227 wWN3kfbr3AU0twoSiTASRsStgyxR2pE7JAMH8J4Q03PE2rSv2crExO8gIDGrqda897lJuvuk 228 oQakoh6N895Wf3hSSmLHId8hf+OEacW7oPH6UvFKecWaHsjWVWGcZjvhQMydI3+CUSxixP4a 229 J8d9fA4jEv+TYDXMutjb/U5vfxduCGgAi35v0lK4F26m5hR25WbMXfSJUTmEIIj2Spr5wkNS 230 x5kGb1CfgVW0nQB06J0VPHxj/Wo6rM0vIJawCv7a2hkABGw/KltqX8Xk1cVAQaNnp61SZ75b 231 FOI1uMNuJKTGtlfXkkR4ig1lzGKU0eUB2KLmoA8d5K6pf73jqot/Drepm+gDHGwG+Q6EQHPL 232 iLNYHM3rtVvStYS1Kt84EOay/Pf1hdFzv6Vk7YCP7HpXeZtbpWR1IOs+QFkGYtQJBaTSkC13 233 n4ianKXjzUUNadR0MSezjhSwXEuq5qNEijO6zxbSeQPNL+55F2TMQhmb6NeQfwRT7NhJPUnZ 234 4D9DuHXBQ1LoYK1cjzrvi+5w7miO3EdzdZAsu7uKRv4oBdB4lZ8AkRK46vvrmM0GspdtVbcR 235 tIzg9RWu711NviE1weziBEE5fLt2qQYHrtSpmyvUbJTrFyZ2r7dkfaKsLCJQh5FgWxyf4wjm 236 pMxdMuZZ8Rl+g2OE6pui3RAcLo52B2qlFAnvxWhwNtM42GwTUafzaV5R+BHdJ2b9QdZcu3Cs 237 4iAvfGfFFjLFkNX0ahR/BeDJ1RxJCN42nnywCMYl66t8EzJdIDIvDbrekndNCixCKY15R0T8 238 vLNlI+IU+wg9ibFQXT5nCIESkaNhy7eifEC5fKT+JnHXy4mr4i95UD6uoqFjTLXHg+xJFEQT 239 D96+b2tvrOeYusjhx/GlcGMUQSDg3d8aF5Egse/CmR8C5H5FlNsZ2gXFwP5t10NoVapcaNEU 240 W8Y551lA6fF9xoDjtGfVhpW0Nb/2UZEfvfyLF18O+KANzXky9tWG2kLZlFgJr5meeg4GLTgw 241 jdAxJ3mJCuut9K+wsfbAKnMy1HcppPFLtMosyluBT6rxKUNDBnasRmcMAvPmRwsNq1vHPSty 242 b6ARVMUqcba0KIeT9ThDOwoGKg2Y6oSQ4sTiuREBefYCeTJjQqdoSAVSpcVMJzMIXziAn8vD 243 P1HaQ2pJ0D/PNB5oujEVZbouqhMPnbr32TEn6Ty7sLGgDQrJ2po3Tt8K2Pz/c71WKgn2O774 244 RQo58ZuUwXgi3iJo4oe9e1x/6h4AODKRC4fExMS9/J1lmJ5H/8iWSNmBdE5K3te7ktg6eQxH 245 FiShZAvdJA9xVVY+KG6W4mKCP0omGkU1nUFcneLetWTCu5rmwUI0a3m1K4otOW3YSDGaGEK1 246 P7QqLD/8K5GaGqNtzm18/izPb7YyKGK1+Cyxm7sOLWFznREX+Kyu4SKchqbuIyHD4rqTZLGx 247 /4BHguGHAaF7WjE1prV9yIUQey4wcT/MBPAx1DcyRUuUkwMMRAzT9e7he1gPqZmo/CO+gsW/ 248 Wkyu6p1lScOIOuDW1P51gnn5IeomC089OFE7xQwmI2CEYZ9ahq1TTULJXh5dQOkmIGiDmZqG 249 9XJmJP1yHIrNIiIwiqILamudWAN5h7OAQdiZsm20LnPVHMG6nyKokGMVHE+q3y0QzQEMRdmk 250 3tH+4J50hGEKQONEwwUOVflXZXIAxM13LbtXcdvtz140ApL+LEKhWg8og48Z0IwJUEiRZnUi 251 vCRLa6qg07QxVfXMlu8Ud8uYqf/PC7q8k+73S3A3u1Dms/r2Lf8yfSZWACLeKuVNwIcXHqu/ 252 53Fyv08kDTsuztJhrstsh2wzKxYtSNCDWgihhM+kkcUTatEIhylkENvCMSs0CNxpRwhfaqmr 253 ut0zvwY7ky8efttccqP58Yi0cOFfEFPiqp9zt6dkEsBrN1G5YW6MiZSqVVmGQ/h/862HfSsA 254 mIfPMP5B2B9dzcDf7wO15gZ15ISn8WJj7vVOHn9HsQsEDHk/xSqRD8Cv0PZZ4vZaGTKkMwqr 255 X3hLq5hXF8l0lt8sVYB+Iiahi7qCRZyTGQCtmLscA78Gwr4SuNUr4A6C6iG4yMExYrwcFxbe 256 7oxBF8+ghl/mQbW/1i6tpDeML2siq1uoj1IZ7jwJ3lgBn81WIq0IUEyHKlHhxEGXgEg6/XUf 257 JlDzg8BXXd/JrpxQumgoIHn9LJvIJ7B6eqaTvYobgDWtSTVb0PChFsRco4IgC3IiduXEF99h 258 46Xa3TjR0zWOiNenIB/Z1WVBYqe77AHXHzg+wZG1/64EJBvUVsIKLjJszgoDKRAzW0gw0l2F 259 C0Kn7a9E/IuXAk+uHuYr7tuxOoWVloOwPy+yMNt2+LP+2/Mlhb+Rv8H0HmZIPLsyUrUpSbWQ 260 LRdyWVdnCYkj5gGUrpwY63PrA25f/7IX3E7CHGqgbxutYFxDGto8viPu2DQs6Djr8A72iyrJ 261 b4eDRPlGEHyCGiWAhDpIVOzzV8ZOPBqreBTHNWfJmnZXPq+j+pZzSGgLEo/5GWqqLRKEkrMZ 262 au1JPIyqAHq4Ubj9ZP474Vv4ElvcDZgCjVDJvztmrjOfkKN9Qe0Pw9ev0Pgcsd0GWag9Soj8 263 dlSJI1Vc/1bgB7QzfiUrIvMoAH/gm9HA44JgnMT+ZbDLr5rms/waata2SE6IGN4XngPFbTa1 264 g82CbWOIPA9Q2rukl1Fm2r/4/yHYSg4yPKVDaffoR7h6/0C3N3sHft3599zUhCuJOB8/c3K1 265 HQsxnVE= 266 267 / Type body created. SQL> show errors; No errors. SQL> @?/rdbms/admin/prvtadv.plb SQL> CREATE OR REPLACE LIBRARY dbms_kea_lib 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 16 20 28 5d 21 STD/JvwoZ3e3Eorl0OnEi+cFPOswg04I9Z7AdBjDWqGXYkpy3C5fcvpZCee9nrLLUjLMpXQr 22 58tSdAj1Ycmmpr3DdFY= 23 24 / Library created. SQL> CREATE OR REPLACE PACKAGE BODY prvt_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 222a1 7800 21 oe0YlJO3H7vDh0qWarrkwuuoxVgwg80Q3sd2xi2PP7kPzMLYdd4KvYZRfsc2oiHJq3Btx97L 22 HE8bEfMzhgNiJ6GFh4A0tJq8jTLJPD09sshR7UCicOiY/9jYR9jYejyB0pMQ60sKPYqU+Clz 23 mrvLZJrkc80Hv7ttn7p9T4HJKnnJ+C5qQbFOnyu77GrYVSHrTPg0OIatz62gguiq4oMB7UIy 24 EZyYi+gxiUQLNGLUiwcpwME0bo7q1y6YXSDE1254hegKc8B4+S76MDeN2AlnE7ETPax5D3nQ 25 h36DDyz8McfarGrYvhkY5pZB389fzxQfWSgnCWf+seVOmZ9Hn64TYxYAmKN+KDT6hAMx2N+A 26 E0VV36UQsVZdjFKYolXD6NfAFTAd18DU/UGOpbFbmbv+I51dLOoM3w87Qc2xwpvAmAqcXlsn 27 jhtcr/EkTmrChyGbTk4jghCjINyYHor8zYIxkJ16E8nEmlaQHykB1sF8iBHxvAuuV4kskUwq 28 S6UGxQ4xRG+7J7w54RYfnnuLJkEzAkT76fQMX9MnSyPgJ9j8CuFS+ePrC0rwe39IbfWfs9TJ 29 z2PblaZhLqVvP0KPHcFNRbqk4gWtxtsKc4EqD9/O3px+ew9MbC30eNgkyTiaDdA7qccq3U1C 30 vvbf2SP/JBgJnZLZzR5PDzSqEr8SczNkxJ3hVvZk33a+XckQPHdb+aYcsdkTAFA7PrWbUVUA 31 Q+fUs7tsyj1FGaVhMGpQalQAH4TDgkwuuiL6OiejuyvAxK9uzuvNSOvRINu2rSdOXyQGj7Iv 32 oqEq2541sqFXtFMZaG7StEHkB3i+y37cLUQ6Uy5ehgPrmhBOmCVIfEr6UbkC24jOzzAtg3oT 33 ZPxYlX4RrCBHHj3JzLvLbcmYQ1D9T8N0EWht8HYQlfwxvxJKWcAl4G+U2trRXoYPucFOl/hM 34 3GXeVppnzZ8N95rFBLBNg0fELiKNOZv2H2vgVY+n/WJ6BcAGyP6PZrr1fEa8QjFZ/qUpUDRd 35 4wOkBVvhkHR7hWOjuR92K23VVBcurOoKQl6WOsJqdjazXefVmVLi7zx2GVohwdasn5BIxUbn 36 pb20jdjTGpVFtk/iWMn7W2w+A5H6R6bMf3vLj/HTJMZFKP+I8je3wALblipOHuxkV+F6NKeM 37 K0SfEwAvZTDNFYgbdchcfghVCjILfMs5mtESZQ/ONzOiXvHg4OU88pea48Sf2RyZifHaPP9x 38 YgemQVSezGLUbxMe1ikEx6IApC3FMEgRODMeMgOIE/xDNvBRQq15POEQYuujwkP83TjqLOI6 39 l6Fl4MVdzfJ9dJJ7VuraMRi5XIFLBvBIYafma4vpx7a+kqI0UdX058LEzpMKZEKHqohZ9ygx 40 joqgyQMSMtDoR0glJGoTZQrYlaIZdyedhNuwD9XySwcbBsLtyWAnsjhy2oaPjvALrF2yMLM9 41 LKAfxciPPUDKecORw1JSR5o+/rTVURfwRW7Vr3fio9Er19S5kh34z9EpueAkmg3gjmz4M/EJ 42 ANSsXg8sUolVahTQoH1Y2hCCMtWSSzKVCXA4svtHklrXP9ttPc+l/2GIreY+6Pk2kHdWqYiF 43 G8YPnFHRQDNEh+eHZ2UWNvHn+bhoOHFFxVGF/8adD7nE135diRN42RNVXr9cbCQJlaXhsrD1 44 BTKCeWQFyeg2ytlynpvp83jyEpg+IP/URXiNK4Y807SE5msWBtKd3aCdLEN407QuA9pHHmLm 45 mi3moy5MEEpP6AegC0e7NUFvabEVEz84XaYtCaKbjFGpgJZSgLpPK8XyOBsWBTxN+44d/ohs 46 yKbz8h/NQaep7BEnsVPDJ8yd9dvX8QD27Cr9cuxsxvQu7c8bOXXV1k7we4bx7j3VNt4/J1WK 47 l4U0paCmfx7WreYEQj1rSNHuCbSPJdHcwm7pU6XJLRl6minL0M9+2puliUi6WZeFJRiU/BkB 48 4M4ILgq/WMSGSxp5OeB3VPl6z7OeeWWqXp8gwkcA6JHuR9ZOEDMb8QaYXfVF2kxIRlSZGY4f 49 3uhk+U2zY/orQ1mgd0c2FiHgdN05e0oOlBmmAUIk6BcIZMCnfFkzANGLyJjIMBHn0MR4mdXF 50 uuE4y2k6FBUv9IsW8ht6ZamAjBTQZg4lNaAVmiHctjlay5xbOsyXGpgumLiPK6fLoMA9g+xA 51 ymtlunlmqgkL7HWn49KGjx0jHxQJw40vJHTcUbBnXp8ygaRPu7RNuH36AOkBfBvSZvbCDELP 52 m8VmTPuWWwIaSlt9pyYEjOnlYMOljHa6LBvDO03DyphjwDXPhOMHwvr61lphVREKj6zjSjeJ 53 K01rjIOmiF7fH3AQb2sz9gcIlF2KHKIv2c5Mbrrflmc8Mc3EPy7Xr8Wt8qluFaOBobUE3MGk 54 lUNwtnsA3fP6ZcttTNVNBJZ0jVbgCggI3EFyxp/djSM3w2pRpKZNVgpbTFgfAfOV2KlmzPPp 55 vmDRaEkIbKxOvxAdY2Orwyz0kGOeZI0WzWJvNPuPKdrc+WAeec3fQXLLm30eLJjNLXFBSp3x 56 wmu0B81AAxD7z2P4AkSNRdwwKOrD8nMMPG/MR/bRRn7sPl8nfnVsIvsOmARRYudlhJeOAEEE 57 C+OSZWfjysowdS1uXUuUqnCinPezrDwLtAiDLUk5dlPjrcL9PBF/I2EOxbp+xWy5cuoG8ca2 58 HTflulnnmWej9g+v81kO9yuPlr+NlbxmdAk2LoC5obui2kQKGjhWCDVN+ENcmEnsTViFN/Lo 59 XdDa6CWZ12dyr/1Wk9V1/7Rcc69bvFKFhobAFXH6Y2cvDRKU4iXbAkQL3qGcT/R42q3q0MuM 60 Pt5SncIaZAmXab53Arw1Qw/OGSUMXK//JPFEzYrVmbHT+qOpEMCU7rpf3EBKP6hlmAZLLw/E 61 urOsiF4glG2oO0Din3b43/IQmk51rUSbRQ+wlS2+i4VWcE6mZE/ih1AFflJ+Ifa8uqToCpVR 62 VS0OTEY+GhL0H+HJ2bCegrLjOd04bHbFn9g2SBTeUK+Uw/HD+GnL7tkYCD6k6BNAhuGAZyPL 63 XAmwIUZQ2A+ma8DDZcmxBk6nXCqV4/A4OPGVruPY2mB8U/XnniOV7n8/9RU/1kGNf2xafZxM 64 y2xZLm5jiRti3Dve7Xlp0M5IHrRrzxpjthJ78ckWYNvTfDcgCSVS+kmkScVHBYdyOhmQa6eQ 65 1pwEPEG27zeiE9c/7cfLtQg11EUqYjFK6Xg0es1d79IIUUi/LJ0f+0s+dVBHc9EVDKiechDj 66 aGSUUV/QK16fvSM6+zVJX62wgJl2y/3CjF0LCvg9e+U9zz9crk+BMcxrD4fBDvjpxylTqNJK 67 h6dbZkHe7ArSzOj1QsInhZtWDoCcR99bEqNOnvnmEHQZCaGfpZVE/T34VSeinHj1+YPWVbLz 68 9EsiJJ/nt5/fmcxabpVHwWQx9EmyRKKQoCL/H2DzUnMVnF1TRy2DRxRFYmF47o0w9Zv90HbG 69 OWd8coR8jAx9fCy4fI1U0+f0xpST07BaBPNooopkjtQqCzLncUwQB9Ep7qNoVkgQDVV5/D6c 70 8woVmOsontVRdGgcsawxOTa23r0a6UEOJgE4VJhlxFKjXCHm1x07AWtjliKw73pcoA7CCz6P 71 FhN2MpkcuQHrfv5tkUnCoksoJ+7nwQhNiZNY32JFE+gaWo6xojqFjPnSzSD4c89F7FJ+JAiF 72 X6IAG2Knz/UV3wzSIwGSoFgiHc9FhzQwn7RVimfX38EX/H+1ViJXyYDyAZ6nEzwRvzxHuvAj 73 aUhH3gCAnMwq8dSYBkrX8W9QAKtIrSRWsUalfcTGm81IgVn8uUuOzz/Pz3Hg+yfcdKPY04ZD 74 4OIXFEabPZTiKlUgppd2znii1Csr0PlVJotiOVd35916POrfdeAWhWvzlRHIaa6bCYAJ3Bkq 75 bYGedF7GTUhs0t8BS+xLvjux9hllO1Hi0GCavPiGqpr5uP7uwMMrdKqCklk42AofuQWZTF6u 76 S1aV+2R8YAb2ptV1piBZWPLvYGN/3S/J0X5te5wcDbEe17qGzh7fSaMmoqrQaN9iQQDzG/8e 77 ZK6s4S6HKP/1Me/rkrHg+AKS9fwO+dbP5ymxdWBwLy0rW/S8CyoJdxNG/W4jjHhUjiZCEsAQ 78 loCKqvmAMhUkX7xzOzBXUrvAwFBbMt2zW6pO4uCeGktjzz3IgGutaehHuYgUTj+9FI5rCY+F 79 R+od0Vc9RGpNblNzAjCt7hknzn2nun1lnth3uy09Pwz+gyDt128UdBit6frHl3azaH/j8uF8 80 o20LINf4D262zb1hpIoF5zM+f/BdumRylZVKXqT9pKNEbQaep6RLHkIQA7InuujCk5fg2/0q 81 DyZ/yJ5G6e3voyivzW9tgAMxjOrkBwAQIyP5kbMiMUhDb9YBhh7VWNbZAi+oadYvozqff6ex 82 QcAVi1GCM/3ccM6Y3TO+LcAE0MkqmlpuNCGWsc3oiK/J7oCmIhvRy2p4za9/GCZQYKw8pGHZ 83 I+0QRdMyjwZEENB3Ax/Y/wSgNXYx8DUAZKxfj8Tg2xhDBsHxKNraurniNgFR9Vfm9JWeDvI4 84 rKeEJTkvDa0Nx4XKycutXjbwfddDIZ1Ey3TcFMcLdxFQZ33CMi23N7+1iyKmw9s3JlBDpX/+ 85 Fe8pkXYwCwhsbW0DXkVGr0pvcUUcRLuEyD0NadyjlHHSy2tMYTP86wOq60kB0qfKrREx37Is 86 +mEQGV/kRIsCjThLDhGFq3V3ViYf4KpWiqO8j0pmEh/3flTKCL2xnFt62scDvhJHkz30cjOC 87 7NjH+Dpp79m0gPEjHdcfieu8pmbRLLa0vkb3Zn0/A96nmHqril7uysoXGPyeLqeDLY3gxHWR 88 dNNsAxC4NcDxRsSc9PEBmiMQ4YQoyM1mt35bnNKYPRxxqwVDsgK+TMWvOtA6oeRGtdpDtf/O 89 ncf5u3+1/rK1/tr5u/7kmixg0QJ4X2mGUu6H4v+raVpaKwmk6iM6Crcn9df2R4A93irTDqRc 90 Fz196e2TFWmMqQBkV/73Z4bZ2uUct7vP0prIWxcIpz+Anps6+UF6MHZkOlsJpRP3CGY5BFOi 91 qmFkwW/RRom93fapEbgRcPXWrMxaV7iFRuHHqchcuQiF1qkDWFGOSvHEW6h5qEVvaJ5/D9PA 92 CBRELL4iM+diRKRCcF5RGR8fxvLkN2QPcX2N9Tj3peTTe9rvrUV4ATAbFTNVgQy2sB1M/xlL 93 jgANdzgegvVlWYevB9yNvGO2T1bpsKDiowPNSLWCfub0DAZq4Lx4E7400x+5iGzqE8kbgOXy 94 o9b79C0FKSdV9aACOzTmsFy6OaT2jAF3OiruFLBZmU1iH4qTkyp+Fw7froJqQDiXDCs6+4BI 95 MVDSZtqeiBstDJ9gNqBZ0y2+7oAu1sDvkfs3Fsur9MKTyMYXdyQgRGB4l1NLKIjmPYDhQIWO 96 8jUqJ8EYiuMn/HYwji3cUN+iDSCxjVNbRGGGQHaI3wd0bU2Df/yedA24slFKaBLm0g4OHHtH 97 Ps9+clXu3osO96vsf8HNqIOoXrAcDUvwuGh27eMZTO+jgQILIt1yjTKlPKtVJkp/N0W4zX5w 98 LnfM8js/lT9kaFor/SEMsFgeAJwG/X7ZKYPFoyBcNVfvh+VLqffsuTDj2ZHQRJrf2mwrR4N5 99 AE9kh6nt81FEECAmCBgwPIJDAEDEB6kvUFq4MMuDhQVQdwZAL4wSetmNUy4HHiU6SP18UtDK 100 Vptp39W/m/DShG8MbpI+bg2/MdHL0aiA1eZZzrncc/6qKB26kSl9SPxKTF+0RVexGArMfyvN 101 TYy9kAadbK3TxZtMLKj9K3eRIpCnkXsuRtZGxHBCVvQYL9TodoxW8zlGWUcC+0LwBSBsO2fK 102 3eZGN4pDpUz8pd12+az8AC17Sr3skGJS93GLq+IeME9N5H0KzFGWh6glzB9gPnNZWBFxCrhA 103 MnB3pQHTK6OQeKC2qTJY7atMcT2H5Q6B0SmTTObtwqUmpXohhBhKFiWA/qaEB4In8+bYNXxM 104 5qQyiNk1gnCI4EpoUa53ct2fjJ2lvum6MnBM4jj9wUsI/xDd7OXOHrGKdguJxqzyOE6cBTyh 105 cDLxlM84ASWd08G35ZYiHVetOGbs2tJee/XAl79+zZPUPixd0wqXaVpUdaWCk4DPLaVXh/oA 106 KDpWtYlyI6ROpMSDDiOvREDRhPo9i2B1zxYde89dcv5yZdrAmtJNPf+HRcmuVhqvS0WmGubn 107 AlAh1L8zaA9Th3erjv83mmK4FNxBhU3rKijL22H0TwSXPxjWYrCvCvCnwpWbzv+MEVZtPX52 108 QWeV3Axl9CJR8tz+rwxgv0SZmnKXMjDKgzbNWRRJhS2iBGh/hquLtGZmiRDA7jtddXhwShQE 109 zO8B9I3DWcdNp+3g9XNtR9YyAthNs0Fy9qZPZXuXEgcZL9DD7olF7NPlH6RISKkep80OT7ac 110 Xtf0To+Y9WuhiHgqF9vTjHVxil7H7D8xuRrfow6vQ+lGFttMleY/VTx1n2EPakvLNL6frfaH 111 y3uKOf4BogLilH18oC/HWbhcJ4ZiWa1zFk2t92np0mlQBV26DDUkw8F243YW5tvJE+0j0vJA 112 UUxSPC3iv67XKpOYa7mTRVQegOVcPTJxoyouD3eOne8tkVxNXZdZvqA8x2+L9LrL9plizehc 113 YpHIeY8EadlJ4LHfBSnoTB4C2QqRzzGR28aFsvIJuq/QVtRglsZqzFzubajlQ8M3gemfqa1c 114 yAUPIiGFYsxmdaB2qel+fh7jljWJOmY/FCv6uTfrxpoWI6Y1fkzGDJUM77nsDuzczlKSYs08 115 a0RgSfSJds49yYEVRTNtwbAt2Vu6YWlvFbqMAo8PonEXsqcJHfPN0prSvo5LseFaE3eXj7MD 116 lxFOPcrK9fX/L/zvhzryIywPpJWOcBRZ2goLtD2UzBNMYxcdOYv/7QLDyPS/zzDNG9L5nkyS 117 NnF6bGfbGeYM6xI4e2+Vy6+0T+5Bx7GEriWTt2ZvyagolwTmx/bKeCRaICWTkRKvBd357G1B 118 1n8IdfTQHJjzQ5a3KpX1DT674/AbPmG+tvnzdVO2rF00hE3fPhWzErN3ZdgoC0AH/5aZi0kV 119 lqUOBljQgKU0kyJbXLRhMUg15DeAzUdULVtgFivpX8sic6Pw4SKqPqfqMqc0qmxOg9+amWHP 120 oF3WBgnKexah4A9GLses1eBX2k8KrWuptqgB5BTjk2xXCYhcfOCnLLj78TQ5UAFdrbzsqKDK 121 sMVjISdk0w09yFac5vBRFfsybyykya83s6HRbI5qbVgkZ06jQtcvJD+I2Xp3eYpw1obmwKvq 122 O4dWrYeFJMCnBh9ApiU/7KZkziufnt9fjefRw4itTWYGLgHLMT3H3MprPeGAjvG5JHtAaWPc 123 iZtyOC3t87LAGztujwK+rm1A3bqdManaLEndE5+j+iQHAJrwBeU5krG5h6TDRpue1BQqdAZx 124 4aTP3uyD4jMT3l6ofAp4Ae6QHlqmJAMtd7CXBsKp6Ck1MRaTCQneD3BzseYIU/EHx3zbQUyk 125 cY/0j8xlyp2qXNfVaqqM93PKyKFyScIMW/wTrVH2CNLxGYZXqncPSssMBylKXB08paY+WVdC 126 3p/rsNFPYcTHsLQJXE9A3ilkpwqQUwduXUC+zOxlMTch7k3PAr6NNtBfI8kh8s4iFCKKPLMS 127 4YR0AepaAQ6SYoLBlO/LFApAsAjITUcxZOcUFiqW02bjo7SYDIAdBoqnjxRZhpErouwU1Tj8 128 a/ktEPufyh1YOAVX5/ffJOc6M5mS9DZ6pc2cFNbvlbTn3vO9NTy8xfEIO+IaVwp4hIAvmkcu 129 6F3Z5GLoRAkKh8iiDJkRjZTGUf2uDfODn9NbLTAn62zuhxYCPQDJO8L8VYZNryThCafToauQ 130 RgnjOQLK9xoivpiku7aqZKoi/exf6zH/LVVZ38dP7Wi+8AiD/LLILcL+onOHVLWpWiCl7U6X 131 ujiQiSB9xXvSNcEBCBbcaHZ7Y8X/s9NtvPytLAWKjZ64cURHkmUuZBBDBhTznqICN/ND2P9B 132 Mum26zeR5oCjPzZsutPVbuEtD82WC2Dlq7GhPV2xZjCDxiUQzsDlS8x5Wc79sdi3V7JjCFq0 133 1Wros7/CORHzCGWXXpnZrh3xInTTXsuAj78PCzosbo7jmUASHLjVE4b7NBZFcIgxo9NhOBHS 134 stz1Wb+G2zV5RgO3kVPz7uTVw3PhNIafJteNFF/wwlUoWY7OvuWoDysMAJcD9l4HkY1B1QSb 135 oj5YDRetOxH1l2BENvypcAV3AjFmNPxgq4WO1KBss+PB9sHwGLsYgjHKrfr4Y9hkx0skoc2l 136 b1bSuTKDJUBPAnsx2gz4hdEfBKYjPQjXE0bG9NrP4UmCFP1ir6/ioRwbSnk8l4eoskBjtriv 137 UUsqyOwuZhOVUrYC3USQ1HSMZM/PftP+KURebW+hfKmyVvU5yyp7NQjXyhghlUlYzCppkFx3 138 LdZ5V31u3G6pJYdugAWQt0jvboLRRuu+yptq2WBvGlo5hdd1W4IcSCGf5gRRvh38qwm5DlFr 139 pHp9/IXMrVYOFXXIONikWOWghE829GoaTpf56Dkm3H3CU6Wx3AKobst0KCaIZAU6udvXNmVl 140 ynPyuBLEFd4WMlpNj5PYyixQNO7gzeSUyxVR5GGggQ3ANtZ9ek007TqJtQoTLHVR5wbvSD+P 141 1gSVI8dz8Ueuoq/Eu9wpmLTF93sXoMurE7L14jajO5W0PerHjaqer1rbku6WYJKo1xfnp1vk 142 AKMAkRZsoEcjMI+ItSfawFrUBIGXi80DQK1wqD9lVkySoOopAyWkmYdSyPHe9ptiWfVtdAUL 143 bM71DyoF93TT/0ReuFvscn80ld4+NiAIFdbE+7+ZLXDnU8drAGBMnx3aTM6gru6Co1Ox7P6j 144 mz/VQXG4NHWvgRtER8ATUPCQUl55wSHg1WxsV4M7elmEB4CxTnMzJmm255LXKDlitPlWIMuP 145 Xrkp3eRg0Aunm2aBqZcAqb08tO/6ja71mDDjgM/VFxEUj6TwX6jggmqFSnHyRiE27FTp5m69 146 tD5A71Lpeqtt1wn3PGMzr73aZvhp/SGMKL5ie5JaRNH3nrcj7UHEJScM3i4ckBxOT1m15bMF 147 LLX5kmQgmku/quS7mKr59dn50vlVmrRPD5pzsc0SM+65gVVbM52qvBC1csxBwWMY4+Mg2kbr 148 z79dyFR2YxKq8/ih1M1dugizhse4tTUo/9CurtlpS9P9iHoc2tTwb6z+8PAsrO2MGiZjePJl 149 z6hiQsLQltF/VsUqmB3lwpQTEHSo2MN3G81kQQvF6H3hJVvj5WWdDBcuYhqjBbVNFV9E7z3r 150 Xz0Ry/uZfgCYlG/RyLIML9GS7WH7SccQ4GZlHdt5l3pkjaHENYbYWGEDQMOkZHg7WV8YK9Rn 151 xfYyfgSou2kTxFr1Am45I0S2Ifs3De0UDFaYx6DfVMoVpQmptORUp/2+gt+9NuZxKjQsaEHF 152 6+ItZT5D5W1pT/+K0XV+nhyEcD3JsUbPEGP+xMSX0DRCrPnpYVMSRd5hrqjwB0KUUGpRojXc 153 m4BQXmyAHoDWy/jYmNWvW83cFH8n7EC/fjyK8+Yxm3iwwZ06i1dQhVFMSPSc8sZHHcT9IZg0 154 gzQ3LlcpwpScnly+1KIA2nzBAeYMAiinoQvJf6c9o0VzW4LjCGVpj0txYgL4+8LGLmgAFh3+ 155 F+BCqVDastWcV83gypBVjaGfFAV1U+SEQmTkValiqfMAgpcqb3Sn4J94owwuruY6Tlqt/WkC 156 WgWXS9YVxGVLifxfWNIkZuWHdGWJZZFQKvTys1ig24wZodMiVegHzrzgzQUqe51BwGm4sx+L 157 YCAdlR9/Q5yUWCOwD8WwWaTKh5dWy7okVukUg8qHK25STLfw5wi/90vmdYBeY3tJDu5NBtSJ 158 CT/oQbna8bVcHPgyJ5nq8tdU2LKthFAEqa/Sry3v3sQVow8woX1fHY+gBoI+g5A5eIKP1n7R 159 S0ndjzq4AJg4KtXT86ms9FG2vqntGksNLhuwxEQct4hyUTHm4Mhq18kNDyAknMzeJeRYdFvR 160 Dx4mnsBODoTF5w/oKZlt4wOyn0SsRhZtRMbbo0rREZVjJXQPpAHJ77B45SWlCiIJIjVMY6HL 161 hEV5JXxvgk3B18HCfSwXr8dAt6FdrIzLvit3Ka9bTZNL3pQP0uvhGpZDKEp2Eq96dFZoEP5Y 162 j1acxMnNm4sDiCjLyzMtgIkqBBieT6tgCC15nU+7yx5C7cNbNlZ8wRoNMjqsebve7RCXPK6E 163 jY4PVCQA02yVaMSLx/FQTnsddaEb79L4q5fDdAT1xZoPplEeqlvj1I8vckv0CWHBIA6F41C+ 164 sBNbNvM1k4UT10E1/l4AQCXNEdVYkkNUi0jRMQPok4I/YLpI/dGaVk+9AkRPHtgxSwrqhdlN 165 IWsszlKrHioYfGU50xHVd/bgz2LvW2sizTZ8xvSI+va0f6eIwWH4LNsHQWrXjnFEWejmbq4N 166 v32/9i/8HE74KpRQ4g9x4C41nYvhRZ8XKfgNH1BTmlujvGATZm8z4dl3eKK40GaZ5raal8Yk 167 HhcHBbkmtqiI7xA7IJfmz+tnIdPsmdp5HLy6sHOPTGNWoZhmgh/pm7v3E66WburKQjLKdBb6 168 yJE0veFC8UC0qkl0GkR2zDgrdN8fxKCQOnsyzV6rMJSexQpMSW2mADx2gmhKwF6BdD0k77qf 169 4R+GOuwBQxxcwswQLnqFMxqMiBrxBGiFHV8dkPw5xDfSStYFS56p7sqB/9fWE8AqnEQMbotp 170 ojK2boYJD31gmMrGsa8dgXKQJugVW5VQ9zn6GZJG+/dc0pTwI8PbjDMUApK07tQsx7vrzZ0G 171 3esHkMjB8N9UXBkH5HbjRy2hWr2cDW8+bX5h4mgL18sdju899799cVu43IrjgcwUauzsHzj6 172 +l0n+c+XwxESruK4HaE5GM84AIdFjaq0cEkNqTfW3zbtk818wN+WAlQUK8BWqmSot9uYJPl4 173 LJ7dDpBjL+p1TjXAUHlOc7yT3BMtJ/NB9JF/BFABrjfPGpv0+St0sFYxe/VcQ6T7LXAau0N7 174 5D6cZn/qYh1NqvHkmdGHyaP7n0URQEyCO6IAoRMXFsGTI1Vihmwtz5l4kEQNrgZeiChinVtC 175 YJlaznf29b6ZMF9g8ALWycDClMGHFQysWnrWX/Op9eGBTiNwIJuRyenjLIzgD+yl0XSL3NZw 176 5eeRG9oFcUR2jbjmsdvcaAKimhUMw/1gcX1vLVXEoALsCxNwKJ5MeNkxL5rW9aJOR1M12UDd 177 dnjZa/CMyAWE9CELppVbz1WX0IJXcDUEGXlWHCZx06S4QE+yVMpKyM4EgzJMp8ODcqTG5QvJ 178 Cssx4jqvmY0P8bO3Xf4UAkC8ADFT/zoANcgde7BZEnzMuuLaR3I7VW280qgWvE+jNnItt4N6 179 jSLeL72eRKDK+OYJBP0w5pVbK8VZ07HZZ3/t6VY97PobwXt9S70WlrEDFdWG/Z0246MR32cx 180 uFcDmVV7r5n0xx/J511jooaZglAVDVp6BPwRvGMfjZGFwG+cg46oGDUbV/rvb9zfnebG0yGo 181 8wLUaFDzmO50WN3asYou9urYxHUxrLOkjl1qqFmHIXFUng7lN2IfP3cNsT+ZQRWj3SpehqrF 182 rT5tuJ63bVeVqIVJuMkuGBMRz3FIJFyXItFMu9wRotdVPs+cBrX0IliK3D0NGLKzNE2/5Mpl 183 72u0DZ9KhlZkDLOfSWplNWVrt+/wZNqUvr0NmQmqTXn0lDfXsk+FYCv0PXZYhP8KJV7zLA7F 184 q5yrWSmbeyy2aqs4fDp1t1SoVfdP7d2chYNMPtND+bKV0y2jWuWDLlEecUSnFO6PxodRJkuK 185 Xiz6NRCTCND/14l0eEbUX+BRBccNy4B54XlRpqO8wNRp/aV7t30BbEnhT5Y0kXBzm47dWFrX 186 AULrlpWJDJctuZ69Taufw2pWLcniFZ6S/xmJAqupYCsm7ZM8xzcUE9c/7V56DGHEaHnLXrYz 187 nCxhg1UaIKvrPc8/XK5PWNouEqxOUfe0VXy98UJy2CI0uuDhyLa3e36eIE6n9F8Bh5Enmmoa 188 1ds7fd/S5UqdRSf7DehOcyurnnvpNFBq4LhlfaXxSLsYJOf1tjfzllYQP5CYTWcEOHbx6/Ck 189 bl+/wRRPjiINxaQyCmKcx3dEkDpFxd+SJ4mxp/xTdDZAp+4uqH3CrPAsdqND5q1lgFRETgk8 190 rND/YgQaJdMx3jvpAs65RZ6FY05QZS8GXB93kGMp0Mwpry5qOcZHQ8rV6c4ufongeAXpeLTM 191 7GKK7xrhhqPFPgmXpzeFulteOcZOFUm1VJ6FNzjI8DvhGcc2fS/yWVOtqvDqUZPYwaftTRZS 192 I9WSjOKKzvGvhkfJ1DXxCpJwnKdgbetD1u4GX0432A+zk6c/fdGnuODFjPuh7/tD0lDPhD/p 193 LoYJRKP2VRpQ4JYrAzOSXMpHA4hxwOT5PDDKvGDPIz4Lmf05zl8uygfKnAsIs4thnuesPCIU 194 22cUwAPdupx5fmNJvPQZfvjCoppGTshM1GNlwOeJbl2sMWEmM6mRsMwd1M6m0A6nRGChA/oT 195 cxvBqW1CEtlIOzvExH7UK8KwYf/owHHAaJ1VvKo8P0n6jXbQAIfZAwPm94Fd4sczaDxGUvUv 196 q7VKBmHfBWdT9syCkDIZrpdRelpsZxgOjfSWvPTm1OA+0UspLC7YXBeU7zqaS21/nw4aJH1+ 197 u2Oc/Qk9J30j6lyTg1lXNGfUe7o9zoAeHKU48xfr637RBDglnQfwkx9Ck31UfPOkZT7m+rU0 198 wnQFvSZOJoY44hRIH5G5N9+RDRSbZrPDF6zLJtllxv40A+JXhYxFD+hrL1I4AX9JK8aEVaYv 199 Fx31J7baoQB0sWQqmjsNperi/r6qZ1pyrn1NJ9OsuvxREVuRUIttqRQjsX5ciana7iWLVLk7 200 f2kxshOTQOxn8nqj/3Zb032NJhjzzD6H8F27yKP9O+ucD9qJZaETbUsJG2FgTkpfzVaUGBP5 201 CFnaEMZdhmWkxgCBW9gaQWriJ5x4ZZJyergPruV1+gBrAx0UWFOIOZhAnVIao6c5fjbE1j7a 202 gS+ibhSsHWA/3SM+3hq0R2gd6f7UfVo4LPwuw/USnoq5IJb6M9RYuO1UeyYQmnbi9lSD8Kwo 203 vMXLgHny3DADzCM0oqknqszWcLH83ftwrtBmg2Ozb5KQ6B/WGN5DL4W9Y5FvRxha5Gx5OnFG 204 rC5seMxJbDdXp7qFewUuDyxXF37SwD7c4TT15VrEqDXRww6HuAKuLEyob6Oox7yhFDYYL8nf 205 l/ET3KxB46Gs1RFpSVNR0eby5WP5NWXXXMsH86if2A79rhlWxJUEQ40qj9Xew4SwrVWOoG3+ 206 hi4DNk0qcNr5c4dANXfJqZueztNE8aQBRDrTjbH90ZXtIT0Sd/VmkMErHdD7k1xiYGDQL6JM 207 JwCWza2MVg2nU7CokBGv1/KPI674NprXZYtxuLb3sXU+DnGvJV1nHOryZDFuVtT84MXI3QQx 208 DI8edxXElGfU09+BLUcxAuahhuV7SSEu7gHty9t42oE02PpIgwF3kEfwYNC7ZgCrGn7vxxUv 209 6Tlpi4Q1sqs7XcXwGsUjWQhGamni4LxHyXltdpnyX+GQlE2G8sXbyiK46kEVZhiHaxpa9F1E 210 k9Hwr1wUuurr0gyfdmLWwBRuRhH013U56RHLKiFMY4SfsGTDcGcSjsTzmSnjy6Or7H18Shsh 211 upJNg/OJYsCs0+CCUJIOR99n4RuRULWlaQkRRtGjIjOiOXkaddMk1j5W0gzT4e5BAO87kUkG 212 VzWxiDhuvfn6hBQCbw4wl5j7z+ctuEvDhbkpitlrQg+cVambzSLRmPtPVYdR8pxquZUBFiEL 213 YM5T2MdtnyDw5de5Q+P24FY5zczCZFXkKItm/xQ3DruylEQB6B/LprO8M4Pb+EQs00JeCihF 214 lGgSjCCW/J8XnZw3t37RR5PFK8ewuYBBKraADy4qtqaOsafYZ8uUzv9gU8BbljCfsrCgCesR 215 yjhGahk30Vh+IGku+sMU9pl7CR7nwl0CvEnuSd9TEUaCE3AUnZLZzR5Puz8w+IZV+IFujNtk 216 3YMD7YOl5fETAPb8HardLJ0Rv65YZWWpCYGbyQ+aIX6jTUf1gyG/2J70JhEvzWT/Q78qUnOk 217 rsZ6toIWkSU944jYEVtkpP3gG0PYYNKbO4wiQTYewLix+IIntOdl5sJnFw4JYrIARlyRm6xG 218 EF/98a4QtmeW+8VvZWh3ytd4g3a4JMqK+NYryKh5x64ux7NtLcZ+2oyEX02h+ClXJJsEQzkN 219 RWvnS9Z7i7n021tPa6Zytg+Ggsd0I4Q3ymigw5e5355NVp13dUPNgERU4vpSI5Kz+tYzFfD0 220 ax3JFpWAf3ZlrX97fuL6tzDY9BxAchD1OkFYdU4Mx0lT/5nn6VMQ+lzVRxy9vWAuYk9yxvwK 221 gTuGfUptOq0CihMIjLYz/WBDtMKMIafA3suIKhCAWQ3JuCjQqpcWVNbKNefQChqtjcgpxhiT 222 lFiJIV/OiFx0C5cmSVuN9aTEChbEquV+45G/YbJv7SywAcF0jbF6BuythLVa15iJnV9GNkUk 223 COsFoyCVDMZmH4qZ34KtGJUzG9iwCY2EboLpU8KUHT9T+8GFHNotEp/CJiR/Bwnp03vN3Nod 224 P1ebFWP9SAAPWX2OlM9dGODXEKKeUbzX5pSRHgblmWavGwQB+5XKQzb0dYuQw9rheKng6tv0 225 g83fzZRkoIHQYQByxOFUmbE8UBpliuVi7+mtPU72HkJ02hOCHhdKlED4TJ8dhRna53qaUHoQ 226 5Eo6GMF2R0NUrPlePk+iXmIRgkhJVNw03ho0y0rVd5+P9c/Qz3Z7Eta8Kreg74+XL96Ex55b 227 EtJEP3L4fZ/6HwvHXi3zeSCO4GatOgDT7xt4QW5KkPLBxQMHdpaJMHE3ZrkXYAaFlOJkWJ7j 228 qjhhEO57I2PmX7o3/u90st/WdAVk7u7wzT+M/o77NzC9k87hEjkb64Q+azSV0lPZ8iR/t2Is 229 WpXzStP0rVv9v+n/MlSEATlYxe0PZP0iLML0l8NENe3WSA0QZmPoGi0cPwwQRfVTU3KNSa1K 230 qHjFVLeefIZlm3rffbDw2U0hIEF4TryNYdd3Uub6TV2lsTTy/peBY+bi3jfb42b7gPPncoOA 231 OhwXuaGLkGr4ZDOxsTSWBMxxlE8zBucb5PI5kPBN80TyvtQywMdtqVZm8aRxBl8jttyVEWtY 232 zDnN4WZiaSp6qwjiIbO5YOqBYZBKxRG8kDzH+SZBcpBwEgBgPuxyiMmWiFaxChq64dlT5r7E 233 XqEsxPE0t9JzkRW44AoO0dP92zbYOWyQBP5hjgy0N4gltm20fjOtLCXj8Bv+M2nOK0JNulEf 234 7TFJwKYGeHyazkY1/hhhP2PfPxg7BcXAqpdz0d+RhyqVEQ5RtJ308qsO9Gbe+FcHFzbmfXO6 235 ajtukSNH9WYB7Wixx6lQubjtmhnKwYiygP+loE3vhgjwTPhyuesrozk2uiSCZHpSS4VhfD6E 236 HLmjkoTgaBp9bPihxzjfWc79G3MtsoFi1yU8d+tMu3tS7pZJYJpzZbyL4zc5IJKZrJ5GOJNp 237 r8XkZdHmI2WP7cNgdqm+mwtmD34JP+SJwHLB7+rP9WtRvfS2vezYuPOVUH8n8VS4q6txgJSA 238 K2BXUUoQ1SQCjT4NlCR3yl97SSAv5TCRLzM75I7rfU2vxS2Fd8eWV0Xhn+gVtcExIk0Ekd+1 239 Gpj5Biv9THEmcGcf/OsaZ7Eh+wBcucxgy7zQ1zsrWSmvnKj+5kmK8ARjmfbUwlwCOpfmD7pN 240 2krVmYFZRYkCXT9W+zrQ6Gx01qpwMr2NvD0dShrSwFZ1gTAOZq9uaP7ZMRgssbpLBI/aeUmf 241 g6W3EuI/qMamCIakTySGtlGJ8saIR9kkfVNtMJ2GExk5+mbTPV4H3ahJ3aq2SzZyMACuK52K 242 r/KsENMioWwVkb4fvvKDnFv7dqRagNkD8wERX+ZoGpS4wxQk/UjZ2k4ZSS8sMzdpIeeedWcU 243 RTg1Ro/ZZJQ7zBvTyVRSH47r5/DI6eaegGXJXcwLERx9Jb/4Ypp6mC6YNC2P5cqKa+x+FJ1E 244 XnWPOwgUb6a6IML4WHPaW10069E2Ltqp6+NlgVuEqog3TZwCqv5rlj+sdEHy+r5cop9tNCgs 245 0pJgNavAaZjQAj/5+5ZSltBKaaMr9G7I0oiFnrz1VdZg5565n6igD9U7/SbHrPwhN/6w82vk 246 tizAfTiPTgDCGkYVqEg+r2pJK8/yOq/IG6DVVh+cCoiUIuSXKA7REKlpTwB12jjNidyu4DF0 247 iQInFxr2onDa752wHcaAeg4Jy2m19J61k+kCgJ/XvQQWRN0dlUAgJJN+MEVJG3/as+ntQovI 248 0vjOZxgawGqKhI1/6qdSAQf/Vez6bJ6Bd5gFTDvEUlZwBoBvN7nv+zXDewHPbCCmfxXw/D4O 249 7oWN0VYhY+M1/H6rV8uwHm57Ms4bk3ns9ZCCxEqLHddWTAh22WfYZDLB8bbvor+iiQNNqqph 250 /3uRqCy2jBSvrFJ3G4j3IIsExIN44K+wp80ch+KCJaNBJzrrNTHMKLAlBZXCzBmxcl1O91Dh 251 dhQjA3k6//74b2gD/tnUG7Zt/bHGMIBXIZ/cLkvder24lkKVE+Uyq9iN65qTS8ns2idbM/kA 252 qxgpPcOXQFTp81hWraFHSrfy48tt5kI/ZXoJLGt8IqJXMUUZfi64AJf5fsXsGlgD6WdorGeZ 253 OsHD+a0KR6vDb+gIbp3TI/NzZ0oF0S4pbLyVgpXMePu7m2kXyn8F29Vr0TlZZqfHUC5BruYi 254 2LyHabemmdlwJdETeW9Ep6FGxOPJpgk3d3MfP9jvCg7p8231ibjTIvo2tSvTh6g8ZRzOBeRk 255 Vx6KFvWGXtu2+IrlfVwvHRmMU//3ct4X/Ii8pPEjAlk1JeRkFTwWHwhwwpHBtdtiCXtfKXPW 256 dWZHXrUFiFRowLQKOOIofChJketJmb6BcK9hHBZHK+qpYliSZkvJWMLp93QTlL3sAiPmwi+N 257 RmbAacT2gMP88dMv0qTZY6RRqh3cPJCttCNB8IyId+CH+3/APlsfsJg1l/iIAdKXwnyMiI2S 258 6EZ9Bi9qQtsv0fdkUjBajYRbjIgnYOShhBfGwZQBJCnrVY8xJvpzZu4sLHzShtYCEIqv9+Ye 259 WC67LN8ahpYwo9BSCsqGJel53N4kLI1qr378Ot0MSy/jQTg+jJnoq5TM9mHrlGUBKKeYGccW 260 7/YFO9fIY9fI1oEckNKBBru81h/Hy1QrasdMG8kQ8AlCmaSsZig4cjXXpO+jeecK/eAIMGWS 261 SBTT0nIMOxp1AFXxIxnXMu1PhMp4bH/Khz7E6X25WYRZislWDIWJBZJxfuVza3YbXFQRMplv 262 Gn7QfmtSDYDJcETrUun3xDQP4zfcSEF0+nxWyIRQ3yWPx/MDiu3Qt6j8K1RpLCm0bZLfS5F9 263 YD1fWeDzl3xm1UPo/TgylDRKfgS+C462EdJchs4eCUyC00Pc1rzlZlROfiA3MugxYHFegzzk 264 fTmoyvPkhBocBgEebOVUBKHFnmNm7wYfnrdiWkJj53BjYT+A1ePxjbfYNtE8V67CSqaqfed0 265 ZLYVq3CishGQS9Rp6Ly9r2/WaXIkXUOLVcA2tQT9+y7a+2N/r6Bh/JuSxqeMRirz8da76do3 266 acPLAkbH9p9wZFrUyye3JvGBOaovo28CD6MhExNg/69fmfChwdFVhMl/vGgUvQrKxBvzB+BF 267 BAh1ZZAWFREXtNNAkEPlCUbQPenKy6wFFXbxaInYPb3xQxDOMPDY06NOiMqYPLgg0LjmSKgM 268 0SfcY1VfXqNbVbjAzxRiVw7Cbs8R5B7vrYQWbCK+AhThfdTO32k77mup33pXdlhalcla99VR 269 pxWso5DIL6V+/FJYr5F+jwk+VMPJo+TWeZekvOyNFkbsT448arHZa1CNJDdlatjYMKhob9sQ 270 BKzZqGadqKwIvXYXMM18ycLKSBvMtoKwbxBO7W4cjvBbqBzhlBWvIadre8uXvj45Yu+eFN3j 271 5bI/N33fOpBASpz59FKboSiJM2WBTnvcox5rpufIEZS2EFnuMPMvwA2vNt1EcaEz2XNhWGNx 272 WkZ6thI+QwNmbHJrgqHhHdOSRDLc9fwwYPsQWVBxdYF44JlbsnSaqdaQbccJRNhZhdzx5s9s 273 wO8Lsmflno5nKsDiVbu/astb3h1nsSquraB14WyYkRfGhJClWYKMJRsVG+wQ10g7A4nN7Him 274 hqtETqQ5O0/YJN6ciRNCCIdwzJzjrzyRn2k2rX/xHQSFnp3sHOLuTtEk33JnAlGiQOuLVDg3 275 Xb92Hf/Q0JAhUxBLZyGG4KnXtdXfjdtDEHxOTXx7tmPPctU6UdK7p/UK7AncacV/gTMVdWuV 276 WXPyKTXi8tC8q+mSqVTVc9p1uXj9S1f0IeWHKBEwnW7EcXcRyQGOG+XdTcTU2WluHpVtF3ts 277 moy2wV8eHHPZ2GGN+9Bo/UXvszAX9rNT/K95KMJjp1YBt0YcRnKY5k7TY46oqLu8rLqidJmC 278 PPqd37WNX99mKwKw5sklLi+CFDvI22z0ytO+l9gNFkWWOOgTOd/x/XzbmYleMr5WCv3CNHt3 279 IsLqWqQnFDGY/DGl5cHipLDOblyBCEuHoaXK50lVQx6mEBDW+IN3llT5fKrBIEBo5Z0sh4Eo 280 agpBdknlpwKJa8fig1ca1/BS2F/ypxNWHbVXcmiXWlvgXqVBOrYbdqWvOrTyOqPUscAUg6Fa 281 ircj2l2TAhiIAVhdiDDVh3xVay0AdiPqw8mr96oYmWaQl+ld1M3qjU/fnP/lX/PbiVTFuUFo 282 lbd438BM2FAumRCVRN5yJKR922FS8tybtt8ppWJFNyJ/qCad2uzelbytltYmPqzWshitfbn2 283 zJ2JIo7G/DYUeF7SLxpiYE00trJYzTNkYcWA6oEp9obfXVWX2yURCqhN+18CH5CmX7O8RC4N 284 RB/IqhzZJJqFJJ0DHmbja8+SWz1HUpNUlE+5Xsu84BtEeDHmMVWGSKrqAhJPz3E9DkMJyS5x 285 MbeFkDhr61yUMxjWO6SUAuqUpxEbtfOfIiZLtvdU8i97rcTrXxbCL/v8YIUr8zZ5XTreXTqT 286 XTpCj751fvVpecoLzAR6CVNFU1k0+RCSgSzS9lggIeN93qEPebX4753TN9jbjd0at+PQrjnT 287 QctkI980/ELdD9WMg4ZKHAMBsw8rw/h+kSqC7VoUDAD54rSJ4pkkAeQVLl5pFybkO5TZAKiz 288 /BTzK2yOeCKB8m4p0xjMT0Js/zK9lWpy7dPQMr2VGSycJnrJnohNVcu3PAw50Sz3/rXAVkHI 289 wqE5sxJ9cVw3tFkAavNoeAuUmKolxW/6ujLQoF65eVyc+wr6OmNXvb25e+OOOcIAqhVdaZ2F 290 91P+YsMWUd56OsxWQ/eAMAZJU/hxCVV418xyX2BPFv0JKzxLW/+Ib7x9uBaRSPIbLqbrAcKb 291 KrKFtBQNhpeS8mRYyAOX0BCDc0PrekRCgxSukh87sFc4chKOS2nbz6AXMn47Vw57JKbXywpD 292 5D1LGQXNNzZnfZNzKfyVNUGvyYTl/p/titJvk9hMeNDcxFlUnUa6W6a0YTq0I8ymaKyWZj8f 293 6s3cIRtv1Xcfjnxt9xjQoqNmuZSS3g41/EBrQRt2eIJoSUvBiwC0P2iqNTuj2weC8ceQS3ED 294 U67Rw/a2jt4JIKTGkuilMzzEnEx4c7hJoaQUQiiX2EwoURWZW2HTkai9LduG308s957zTjIC 295 LTRBkT7J02zwHBTyNTNL1xnwjpSK5B64wZd25qDUayHTy1qM7vQk17iAOPjky/Th6wOF5QZm 296 KFPiRS7t4ujQaDINEmXC4qyPdTLp67grK4ke7cKH/icB6fYtjc0NoBHbam/q9x0iBIIzblCW 297 hbfm1MUhotThr04NhYW6/ChpNrPBS1TYv2TUo9FNqdVs5A96/XqEIGtENcd5Xgn9bb0gGr40 298 A47RE7Aal9YDQPW0rBcEX6HkLGx86WFX0WWRbROUEfvQjfT9J8NFoRbKkCL51GfASb8Wxau6 299 Y3LgWF1mszBaz54ooGlUV19WjtFlkWuONDqoSNlyeU0N/Bp72tG1RKnQqHwEzrXfHCgIjEHH 300 JxPSfIrxey24dDRuHQxXOYefLrSHc/Y5jCVDd/Wu9ToqVetUXVlvO7scOV7ldzqvYE0OYXNv 301 g/uqEE7TY4SZPtPNFdrU9Oianr9cMY2bFwes65NQ8hxx7q0M5OnE8foEL1LDpEomP1DQeoy+ 302 FqyEPdjcB4/OcI4sX+7+oqXc5Eozutb7vphlM5tUD8iXznHA1qKsSWrMzsg/sIgXVnMy0hvm 303 d66UdbDSFBzTRGGWR/GJH/8u1H7d7x1X9gFRvnIWi1wG5xhFwWPkhHFdhd+/0h/kU28lho+E 304 ug7NB1fsSXIgVeUzEs6h8M3LwKRjiv2We6aymFD/ftXLCP5LYuK/xunZItz9kuX7Cbm4+iCd 305 Mwm51Isc6xe0f+zTD3Fd9FAaYXsZVHE65l3c8YxhUHeJxurnq6daC76TrAZMAOVh4xnmlNT3 306 vby4amQzYEzROuIepNL21kdAzLFIQiGzhiLVdPZjHiM3xUum2J447r/9FWzX/zpn9ch4FGxU 307 5NdpoEnbE2fuMjwNxk6tGWnGAadMuVLc66tnc9HKwBhedO1yGES/qoUe47JKjVh2hzymhHvf 308 wFOXp8MLsMUC+x0JyVvwgGVfJECevv63wKr3jHHoNKu4PJfZvQNDrBUnC0rRSFAp58BUWWd/ 309 Ffo3LhxK0+pCbTKlRrAAXiZ6sM63WR7BvjXZJlgNPQNq/l4Zb8jm7CUlJ7I7l/20MaDRgz3k 310 A4s9bT3JPJ3WbtQPoE4xoBwlI7Gl/T5eeTL8C0mV70YLWEykQceDbPpYlw9asaOWMk7AW6Hh 311 wQKeifkKnWi8+TqLM0gzxsHEuyQ0EP6GI7xzP/nV41oZh3kwHdNSTyqBNySpWlXNuT5e9Ktr 312 w+00MbF4bjnuU5RQ61SU0xKh8N6qMv+djfsVyejrR4OkhsAVPfnsvsFvILrlj31WXWYCwKP8 313 kj7KzxEZNO34V7ect5MuuinSrEEN2ZPaO7/kWqDt8QO3gga4FXBObSl2jeDve5UdL2E25jlb 314 AFbszW85SuDr/rPVCE+VM9RQ5FaSSXvLcXYKa3ZI3wpzo1XKvxuofz5aXXwhEBoDExSCUayR 315 pupA/JbmA8L2tjdUfwz9Nk3Zx7zAlo0p/XcvA6o69kpp65V+oUjZPXz1XcqBjegUAt+S5T9O 316 eTHDnBBuvnYg0eus0l3ATreDrTK9IXDXxFikvLrNOBPCLY18m/OJ6iscfzoy22ZjoctB5IuL 317 Rqe5YfofDdxbPXv9wx7PaTvG7qMB8fB+SKow/vnXv7s/P7WGHp0/dgnl8zVeegOFkjdUNfIn 318 le9PRhg9jGyVjHD6Xp1d3lNdWA+bVnGbaJZCHNE6tJY6dadfuFzykuLqE0QkI/2DciiGB7Au 319 ALaSvIou4P5aGd8tmBosq4MQJZgZMd0jwR0eAEo8Hj5G5M9zuXOah5piIuQ6C6FmyZX+6km1 320 JCB1B45kZv1Z8iELCNoEljsMAOHC8MpI7lpI1lIei3OYT6qSV+fJGwo4yYulDmY7ST7noUD+ 321 jZcNidyu4mohyYPZm8uNtHYfP7ZZwkK1+VUSvI4sBzUV3SGmzUd3P8rHMh+vWdU/Ce+PgKuW 322 VmMBA7ZrH7qhhJxHxci/+9KE7rYPdqW1Mv70kdN6SXNZKHvhK45Bhfro2ufl/GlhBUY1E0Be 323 +IZVzfj+JLX1xBJz7pZPOeAwTaHbbZgodXXsKyiIFKZwxLAVc1vZcEAoAVzTnP/CKx23SHi4 324 ZbnyyElH8W9mW/pEiawlkSkuURdTpku22HeZ/FYaSZEMCkmNP+nZHpP6m5/sjT9ebzi3u6kN 325 UBSukABwk+1dj0bjtdrRRR/nT6yPmuE1X3AC0gp+WZZ0RXWB2FXiwYHVMteplm9L7IDoHqWc 326 vVbjLSx2F417nZFhOBq8cfMA8JWNqqLwWdL8ShCi3HOfvd+c5px6kic27j4muu85RA7oaUnr 327 i69oqCUj/9vpkYWinM9UPOhLjAyq1AYN6QKhbkZGRwIxtHtv/psY00UjNakjXLp3lmvBy0nF 328 Ix7A5W6n5zmXOFtxf81DaXSc4n4aCQB2ww9kngDEX9DVKgvHlk9rokbQmD0YbazKC5f4dD0B 329 MVhZKqBxvaMO0cB0PkvEcTaam9+YM3hJoflNsaNwLkB+OTEoVFd5M8mGQtoUPI70n3vI51UL 330 NjdwLa3W5+nA7cYW5vcPx0BrrMwid3zDxx2nFI4/M4cKBkYKDWCC6FzxqcVnDzKKP4QPPTPs 331 ol+yFcn+Rt+rWGLpOosINLoZABjFJnEvQ3h2ocrrsvP3gFU6Hx/fkK6MsOniaUX0TzYVJ7AK 332 6sxkEjLw0DV1NgMevbMsl/P4aSgVd9cDBfqCRHGJcJibADgMb5vQzR/g3c4UizejrH+93nm2 333 ZTM7VbU9pvDN6nOwc6YQle50KigULCvhd4XQvut+Ju91oSC7MopsVboF8vUBAB31MdmpOs+B 334 5qzcX92hHRGzY7fOiMdXGuIFxYzS0cbp5iGdGsPrZv1KGfy311p3jgf6dLlQG2+o7dSMoX9t 335 SXtOEzlZRxTD2x6xjM4z0+tCS+ZEXvurlhsJtBaGbgZwLekrcUbbKN+oGZzY9Vn/2m94cidZ 336 oC3eYXHKMZISiVbqtTko5H6mmhKTRMqESIKv0U71J1BwqiZGYGaOc69tkQUApK2mEy4VpGlH 337 0l5EMxUa12PDt3376QTCWIa97jHtrhZSATbzCXZSs9olKRP78woINXLkN8dgozBsgPTYOBqO 338 71iCHwzxADLq/nACC7PcUMLjBHfGeStQe4BRyKgDR0eJeBj5h6QmHubjme1KYINlodqMKTxk 339 aM66V75qPfe3cwJ723svaDvXs6ymFnluAQ59MBlE3wxJL++8kwA4mbfYJzZw+TLE3MEggQZ1 340 Js1GSQEVrzjKxyFK4WXGuO0TVuyodIUDhPC8TXjBMS3X4e7iybj6bN4CjlUTwdd0WDsHKAA+ 341 ANzaEvRxPIqeh9Z8G4qlFErs/w4IzbMymDG5tLPMpWwRPTHPARXM5/4snWh1xCDbeXK5sXSI 342 LKVMIueQUGx4W7/ZrM9XLlGLIj9QGKV/wn1dXfx7TJNOSfOVq4VbcvLzEkSIjH+KlXWXu1Up 343 t9ienixk56Sm2mhnqcUUArWsSF+ffa7bKlA1TIxKgKU0kyIsXH6gQ9jLGtMwd/9gY+8dty8W 344 WiGGtrBr/Z6G/QoQ5+OAh3zbvfKUesaTtz0xh+AKQwXc00cECdBDg6e50Z6DcnJV8znWgVC3 345 GB+nZf8bmW8a7kiXD/rnAh8GnAYNo1ej5hdc3/sgR0tYtrLZ2+j10VJWG+COEi2DehNkJ8Ys 346 rmbElraQZ7xIyBcFYnaIi8Nnu8Zn23j0WWH7wF2FPA49x2keNBjQmbdZeNzz8m5v2d6QvQ18 347 R1N2vZUNwCHPRRgrlBAjXD5A5Tt7vN5Xy/tVGZYFu/7JSUjds4QbzL6R7xG4icYDXD2BQJkb 348 lmvC9WAr86POyNXU8wbSNFYSDVtlmmM4L+3l8izHhwWK8UGCNzI0WcEIdNTWjkzFl1GGPQ53 349 EFaB7rxabuPiY4aaEcwosaisiYtdt4lYIBRXcEHt0TK4bV3QsgcMXF/FK06zoaDFlJu236AJ 350 4a/q5/fL9KUvEvBxX2lQWv0qJUcWaN+l43BwoUnnl5akpqhHcn940Drc9qbjoLxGWsuJDHGs 351 oezMLJhJGhD2yaOzhSQyLSAHEv1njgC+x7OVu4bMHeenjIX7NsJ77TrzYmLB3nzR3wWkjCUY 352 VJi+pI089OxAvO0aoWk+SYnyBbw/CnNRaVTswUZxfFtMYF4TmOzdfA0/fKi9pMgQPfyWG8Uy 353 X5f3VlH/OMPCMzoudbE2R371eignCsbQqRDROBYKl5v7eD1ZtOz7PXDdV9UvCUXstTLJfzXa 354 UlTTofueG/4WsxAFHMWDumugwEedxCuxykrmstUQUQUOhcYsUytSfFqT+DbM6TgHB6vAuMyY 355 5MEvVGNMGUeo7g8AsLOlaI/hQvywI5JzvFUW1k6PRBPIdLhWgslefPxPSds5zJRKGcbuujVg 356 WAB0o3USClLXNPspaK3TbTb9Z15n0m/GSmeos2nYyeN9a5EoJWPfdjhEMc4CEmLqOivCrAoO 357 MYwe96xjIJ5VuuaCi+bFaBpcsAT0Xa0EhduL4UWiqYXOY1Zg11l83Uc2xbX5eeaoFNQCNTEX 358 rd8tDcqj2j239OYGeZG/CmPUdwvDJlICjNDjVaRVDbfRIEzM2Y6ab5Knuu9aZ0ZBLKy6gEPf 359 v7Um5GPgQrB2dKyeeQEcWexLdwao7bXjVb/VwzycsR+45yO8gsRcy+hRkVSLT4U9nkJ6HYy3 360 Xg2ekVj6gleyoKQNBHR3sFWhw713fzEAMt4S0mmbMp6yTefILjfx1wyyv006V4B8kI3u7M2B 361 tM2hn13UmikNNc9/+oEmrqHckantQLS/yFqJ1ChVcX0Y6ykRP1GnzhG7b3X/Y6uiXvplwuKc 362 R5PgdhWhvPbOh7gbHLt1Ag04WovnUJyhZmHpTsCymVAHLwA7xEXsDR1KacoZbX5f/wto0Q0y 363 /DVTeUdGRKcME0rCJrYFXCt6oLzDfi76PMtDeKMTcoVZAb8aPgXEnKGXYNUxWZkfG9yoxUs8 364 SSmz2Isli0hjj3ib03yzIg1sRJa6mV6eS9tSOLHZtKIoVOd4FVBkec5Ioyw+2f6Zt+MfYnCm 365 89pvULo10Sd2zBMarAFiJ2iOGEKCrmZnHznIeC7neLnWZr51BqhfRKNJ/HSvkBlNhDz34My1 366 YRaDOlGsRUqLFLJKln+jUXa88lZXV9hMlSzDIa6lzBlN6dxYp6Z7VDu/QFMQVRIXKW/O9Lal 367 cG2Tt2/2Wy1y+3TYHfFrLnOmyEaW9YwkNnEkCxaMWvJGnGCKsOmKwyb5fqdyBdcnvo8Tsyi7 368 HPqPdd5AhsmCBG/t3ySl1aaoegNTTmHhg1/WfkX2T3gHp/CznJOdjzw87o2M28CD22p5Mg2P 369 RBF0g8l3f5yleAMFnRkZVf8ZvJ1z7rnNmiCYbhX0H1OGqBy/nkmpwkHun7nUnBkj0NWuCM6e 370 zqW7vXqCqbw5KfSOn9ySAXqAD3uy2Tsbjrnkyu/UvpSB1N5ks1pouJV7/0sqo+ELHT57dfIv 371 sJIElU1gf7jaJQC/FE5QlYlwbMFry68GDHeps+Ip2L7LMPiPKv5ubMOGPfSPs3Vwn2yOvSMA 372 Te9t++k2gV2RCAmEzqU9/IhJfDRoNZ1rDcUYqvUUl+7qxIDitk6s407iDkSwnCU9FJKRYt+F 373 n4vY4otM42N15b70BKvLune+yGSsiTLIcgeuhwcqhluvpHdHkhQvcW8l7RdcIu2AQz0/v901 374 eC7KGUMnRaOd080U7wc03vn5kmRPqLcvmrFm9ZRPFc9sZhl9Bz/nboHeTZEWMI1AdQ9xnb2V 375 EQP33L2Hmh9PTGCN2eXkBEdCgUDKJ44k9/Rbz5RUGxXLu2RkrQPWF7e1uJe1uJdykF7Fz0TQ 376 HxsdTF18ZHwdO85vhrXc1T3FAU2fal/X9gTnzSDxkdg0sckDHlfiaIY0JbfTAI79kDvoElLh 377 ssxYV/4nquS4+Pm5H0MPJUlH9Lbwmjp6hUPHyZsiXmVk5nE+SpRPQ/PFTLOVpr9zwQdLmDWK 378 p92lyCEdl498/8BFSs86r+zz16Q1/e/+wNrX1cJX6RiudI+n3sneOCRuTCMf9P4GAVMND+wT 379 rYLHBIMBJEDodVh/zNxOISxAsEooyVCw5ootdL6iv9wCtvurHwjjzQHdm5EJj9vb+5r0z1BW 380 /JxjRVh00RIfHl+WcAFNt6rmn7qQXUb6+B9335/QryT0n4Klc64gh6qno/JcG8Arw5YlWTFM 381 9iBju8a3B8Jda3YxTHI3gMQhhPlyr7kkW5gHe7Qys4O089HcHlVvmGZi1RkOPBwrpNTKLjoq 382 Lc0KSG5bA9aLdxM7bzKYdmmuG9+7TK4bmwR7DG4bTYAWkRIUblX5KYZLtgM/GzD1fS9X0JD5 383 R+ZTQz2GcLINNoeUgXrDB6K4saV0VZ0+2DNLjm0dc7EgFjx0TL/voc/bMkn2IpEuBm2Ptxj4 384 8xg4keAE9wRhtP6oL5MR07EEou2mwThsrycit9Yu49XJLcjZDkLfqfr6ka+BE52dc6W5AOvi 385 MNJfeCRTN0qNERpuzAf+9hTAM4YenVVA+G8vOqfZZuDoBgVsEmi7im/8CLlPJDoA5bVt/7f2 386 ZVMM7r4x+kTCt+GJKb0NZ1RvVbmE/2boHszaMxV+GRUcU4RSKEa2FEqyoqlnOYgit/3q/548 387 5AweUJNY8CWANvkEA6XNB87DR9H5MwmGCrvbiMBV0nmijFONFWR+eUCsyCuBkbom3lDeWzOe 388 16iOfNX/ztUM69UufmzR9nLGoBFtgHDGRqM2fbDjeinr/vo1GB8hrKHdLYeRg9vGSLHbYv5X 389 fv0Iav1stij/KPJ/i3aJY64TV9WxDLFjTJWV8+kRXT4i8ZHee9wVUXoXyZUhaCa+q0gq7YBJ 390 ODINCZsmLu9J9vQEYewrHka/X5sI1O+YpjCOyZzajIaCcQYKIVWMwXT3dOnjemZQiqz5ttsx 391 l+mwocoaduc/2f2UzWCKOBjHWOHTSEmp9sXIpzTHW6t5jBH7e0RmVr4w9aTRQPhcfYxYNXQ3 392 hWkLfbabLce+DjL6jV9pQmjgdhUQ+mn7l3NhIptLTVBX2w/xf5uTGIkGl2tpfxCxa39luJVe 393 nknmdd3Q3QbWIHG7LKKd4TcBnrYr6fRQzfGXVSHPdELZnnayYBLPBRqa/KQEBZeP+oWUH5V3 394 bMw4ZpVUNWqdSzDHG4NtwWAc3TA4aO+w1Hrzh4pEXeZWQXn+scIhI9Rr+q5AIohDHpT1+y95 395 sQU51rxLYWhlRSiyLu+YptnhAn0kNPg6xtpn9Te0LPk67n0su5r5kqWS15oov2Qk5EMdEs3r 396 NvQZZNBnL8FUkjaeHNsfSXwfOjqGBZixJLyInSKSKXOYT0iamnO3bbSKqvkH2Fu1e8U1q/H+ 397 z6UiJWh9gbOYquQw+Bx6YlKC4Do7HXDu1Lnz3AUElGvZHUivl2DTGNQRmvsBr7hWJKxRr8o0 398 xblU7Ydy7o7Lh6YJvBWCz/UjR6rFVNpoBpo/+bjG+TDZIuT1+GoFJO3tEGr529BwqrxDpjAQ 399 /jPGJAMFtcf41lcEEATzZkpmt5L/UtZL4SOSOrnNmCwkSwUEJ2ird6kl0yrOg07B4VwZvFJv 400 svSM2B4g0I2J3YwK+vqa3WII7qq1gWrNVe7XzU8Z+c4r4Y8sIFR0NrUwC3Cl7rnWpq8RUbCb 401 yrT0C41CqphS1+CDqjg0RRJz+XLEv5EyNukHN0t4u0gkSyyaVVL1EvjuSjbLA+MbFVnA5UZ6 402 SwLaRZcUjMGe6hSw0Agcr2nIOJV+3ohxii1FLpUw2KZEibqxnGdqkTP0UprH5E1Di4tmFeCz 403 R6Pj9pZQNZjo5Us/AkoulYgmKdTwvRFM2JROQVP7CZ6qDc1l2ff8e59o/OuxihQ8HGfqjUWR 404 SUvlK7vm7hCfdssWxUO9K0YGhn+L228Br4XaexsmjqEQva+tlxe1u8bvA9zDSBp1qOglXcXx 405 RrT/mdJkgCWCaSbwOdPL+OkLIrNK4WiV38Z/OTNW8LN/M3qGJDKlMHbUvX2ntlrHzJ12XsFT 406 0yA1YOEYddZ2lGotHVbXOVDKWzzKq5WQoy1eF1Ei+ZtScHRiUDDaU64fUFarbXZj2rhqIUK3 407 MI/NRUWSSmSBMH1DnfaIUdPBy8fIypixrvS3saxuaW7k0uimi9sMxhsf6nahlX/ppIhURqO0 408 OPORx1NAiHWY3As2D+x9pmMmq5hQxx2zLV9HZsM9fhtaXn/6MX6Tv6PzUpEvKGI2NB29kZyi 409 rxB2UWp6UAPdSDwdKlv1PMfvTggxkHGLYFFcaWr0nK20irFbRgU2f842qJl13VTPN25UHM96 410 xdvm+7hVBlJKOYaWTPoClPcwNzcZux8+SxK+lFoHNoXE2TWTJ4BXIqs6Ri1XWJzNrkVRm2ue 411 E5MDiLtab1UiN7E2DfGoypLxECJEk7MIph93jtX9VWfeTXIgli6CV5G+hPCeFJ/I2WRTU69y 412 Gy3qsERvotzIFMJeXfQk0vHTazXaZqHHqycGdyAVpkcgqZEOMYq0xPV0Bu7bGQm9ARR9kZf5 413 rcdhW7jgukwMdwhkz0fGBBjmDXDUWxAFUeF5ZZT3L4waUBAcYc1RkLFX9yue7quABFqN7eKw 414 zTSUrbRZUmG0GX1HOCsCiLKiU76tNQ30QWXMwfVnkAP7Mv9bd0J25bdNm6AmOtO6uGNqhE5P 415 lc+zsNLAGbDSYToZPkig7cUnoMpXS4V2sWl/6d5cuMpKx1uHYIYaYFrWfFJdBg28IUNEIwRH 416 05kgvJTu6dRjcvrExpITGGCRhixb4fTlTDJTMdgz9o7MiZ4v/CsuaBemXVd2ih09NhYRPUFL 417 u1fKj9SEN2oiqnsFUGDOo7e7zyr6v25FNH/BhJOJDCOm3Rjw+btNw/SVsfwK6oqJb9rwjtqM 418 lf9mlf/eLU5aLcagdZLySFq9vYJdH+Y840xn89fgdWuE0/QUm+OaF9MqFPLIqd+eJq3flkq4 419 pnk7My0HMCLRXFddrzjI44w2dNyPULPCQr6GNofAK1y6h8a59pRgYAn1k2ZK9KWC3+gt3Evc 420 GQEBfK6pjOEa5VdmXHZC2HgUVqTY2ZJS3gN4IFgryCcw01DDK//YeeNNAn22lNtCdIojjnVo 421 MZvHuqe3xVXocYL4Q46qrWoP/wicxgYLoR8M95atRDhNfPT9OQoF5hO/dC1eELdaQSKO1VyI 422 LX4XHiPv7XSCI6xOjqT2mFSx60zoz8WZLI4Je4IzLLCjo4dk4c3jmOowekzXfKJayH3KM9V1 423 DDQstoy4dlFvfup1RlRjDsyz3lhkcvZqFYETlScdHMPPfWZdH4h+k1cSauD7HG12xg12hQ3a 424 0w5I9SHGYxzINkmJZ1Bvu+limWk6X3Tcg9jofyNqazZNpSZ/q5Jj7Uwq2YtF1+nyXKsbbfZn 425 AyNkkV9RKxjKBalUNmyCFy6rVm5X65c5Ce0FedzjWnSu3Pq3SvwXuRw4Bk0LZJdk+sSyOiu3 426 IF7SLrugkF3AhZq7oyItzg4TQyhD5vynryfp5VrDhuQ3Ai+bm3BICUSowM31S2opNW54Ncjm 427 mrzJSVo8eyUHel1WfVBb5ydFVKWkabptJNl2CIfpXebmD35wLQ94gZtYNa6hyi8z+qdGsCgg 428 uLz2ym6ga57lgDETYzbCbfCez0nwHo+erg0Me00EcYTRgAHP7IEhIe2PiXfgdagTiE1r1XeU 429 VOVpXvmtmdyeA5KjoCidSvoi04x4C8qRwVqBtjAj7E1SKxuceuEo9CaN5mlZvpXD2yd3BsKp 430 yFluwKdeXRdbIsEKQoL9bZZSBeb2c1F4pyPvFXlIH3jk5yQkGN/8dGoufZCC03cqKYI95m44 431 haOm4EyhBXKWhKGkRkPwVmtqS5j0eTU1k3LJmdVmW2AbxVKJQ+M2IocGQzMRPDx42T2fsdyV 432 HfQos9xhmnK/+AGCDiyHshaihyyB9Zd/+Qv+wuJ5KDcBVXfa58D68ysnyF9RdiYw8IaQfKIv 433 /vk+ccexevTeyVXpJn1xRhqbCB8P9YScQBCJDbOkEHF66+16esvILiyENliGky42D8OLCgqy 434 yUaMKp93QUirzTluWlkJ644XcHsOR94Qtvb8oNgg9vyJONi7o7Y+Ski73vlJyY19DRkbR74O 435 wvq2GjSGi3fsfNSFNd+tibSFs8WHNglOHCdn3kBMV6AuvycdDpsRlZdK7jbjLuPvzOhZ6xRO 436 JNLo7Gr5fCCn44AtFb7HyemyP96DuINoX33lg4MJD+4IIt1UWu3UeDB7K4nykoW1vcxaeNLj 437 kI0Vzvx9fRGibk/Xi6K9xL+41lXnsIghanV5wlUmL7EfK/NlAqQzZvpvwJhrNCPtJiBvKgr+ 438 mD3ADVTNxFuHEr6NBrdVG/LgST8hUQFhsVL+lUTrOJ9je0BdgvjvwfOcGbMzb71rgVfpFjAm 439 iwUsQiCiIb/zcKs9Hx9BoEXFbMScaCoS7FxVW8sju0D5wnhBQPWfccXhGaViysuamofCgEma 440 qQ2Tzp7PsVZKQXkXlt/aWqzf07/mis3Qiq7EZLs/P6rZP/mlknLEinPNKLsZnfu2PL+q4GSN 441 IO4W6RStrGs+HUUAKdjdxkf4DzCnS4sVk8pRKHoyfwKGxq75sbUdOHpgCQ== 442 443 / Package body created. SQL> show errors No errors. SQL> / Package body created. SQL> @?/patch/scripts/bug17381384.sql SQL> Rem SQL> Rem $Header: rdbms/admin/bug17381384.sql sshringa_dbpsu_112043_extrafiles/1 2014/05/22 01:34:14 sshringa Exp $ SQL> Rem SQL> Rem bug17381384.sql SQL> Rem SQL> Rem Copyright (c) 2014, Oracle and/or its affiliates. All rights reserved. SQL> Rem SQL> Rem NAME SQL> Rem bug17381384.sql - OGG: IE ABENDING WITH ERROR ORA-01427 SQL> Rem SQL> Rem DESCRIPTION SQL> Rem This is a POST-INSTALL script, which must be run to patch SQL> Rem Bug 17381384, in order to redefine the logmnr_gtcs_support SQL> Rem view. SQL> Rem SQL> Rem NOTES SQL> Rem All Logminer clients (Logical Standby Apply, Logminer Ad-hoc, SQL> Rem Orace Goldengate) should be stopped prior to running this SQL> Rem script. SQL> Rem This script must be run as SYS. SQL> Rem SQL> Rem BEGIN SQL_FILE_METADATA SQL> Rem SQL_SOURCE_FILE: rdbms/admin/bug17381384.sql SQL> Rem SQL_SHIPPED_FILE: SQL> Rem SQL_PHASE: SQL> Rem SQL_STARTUP_MODE: NORMAL SQL> Rem SQL_IGNORABLE_ERRORS: NONE SQL> Rem SQL_CALLING_FILE: SQL> Rem END SQL_FILE_METADATA SQL> Rem SQL> Rem MODIFIED (MM/DD/YY) SQL> Rem tchorma 05/18/14 - Created SQL> Rem SQL> SQL> create or replace view LOGMNR_GTCS_SUPPORT 2 (logmnr_uid, 3 obj#, 4 objv#, 5 segcol#, 6 intcol#, 7 col#, 8 colname, 9 type#, 10 length, 11 precision, 12 scale, 13 interval_leading_precision, 14 interval_trailing_precision, 15 property, 16 charsetid, 17 charsetform, 18 logmnrcolflags, 19 XTypeSchemaName, 20 XTypeName, 21 XFQColName, 22 XTopIntCol, 23 XReffedTableObjn, 24 XReffedTableObjv, 25 XColTypeFlags, 26 XOpqTypeType, 27 XOpqTypeFlags, 28 XOpqLobIntcol, 29 XOpqObjIntcol, 30 XXMLIntCol, 31 EaOwner#, 32 EaMKeyId, 33 EaEncAlg, 34 EaIntAlg, 35 EaColKlc, 36 EaKLcLen, 37 EaFlags 38 ) 39 as 40 select 41 o.logmnr_uid, 42 o.obj#, 43 o.objv#, 44 lc.segcol#, 45 lc.intcol#, 46 lc.col#, 47 lc.name, 48 lc.type#, 49 lc.length, 50 lc.precision#, 51 lc.scale, 52 lc.spare2, /* INTERVAL_LEADING_PRECISION */ 53 lc.spare1, /* INTERVAL_TRAILING_PRECISION */ 54 lc.property, 55 lc.charsetid, 56 lc.charsetform, 57 NULL LogmnrColFlags, /* THIS IS BEING SET IN C */ 58 case lc.type# 59 when 1 /* DTYCHR */ then NULL /* shortcut for most common */ 60 when 2 /* DTYNUM */ then NULL 61 when 12 /* DTYDAT */ then NULL 62 when 58 /* DTYOPQ - XMLType, ANYDATA, etc. */ then 63 (select lv.data_type_owner 64 from sys.logmnr_tab_cols_support lv 65 where lv.logmnr_uid = o.logmnr_uid and 66 lv.obj# = lc.obj# and 67 lv.internal_column_id = lc.intcol#) 68 when 121 /* DTYADT */ then 69 (select lv.data_type_owner 70 from sys.logmnr_tab_cols_support lv 71 where lv.logmnr_uid = o.logmnr_uid and 72 lv.obj# = lc.obj# and 73 lv.internal_column_id = lc.intcol#) 74 when 122 /* DTYNTB */ then 75 (select lv.data_type_owner 76 from sys.logmnr_tab_cols_support lv 77 where lv.logmnr_uid = o.logmnr_uid and 78 lv.obj# = lc.obj# and 79 lv.internal_column_id = lc.intcol#) 80 when 123 /* DTYNAR */ then 81 (select lv.data_type_owner 82 from sys.logmnr_tab_cols_support lv 83 where lv.logmnr_uid = o.logmnr_uid and 84 lv.obj# = lc.obj# and 85 lv.internal_column_id = lc.intcol#) 86 when 111 /* DTYIREF */ then /* needed? copied from dba_tab_cols */ 87 (select lv.data_type_owner 88 from sys.logmnr_tab_cols_support lv 89 where lv.logmnr_uid = o.logmnr_uid and 90 lv.obj# = lc.obj# and 91 lv.internal_column_id = lc.intcol#) 92 else NULL end XTypeSchemaName, 93 case lc.type# 94 when 1 /* DTYCHR */ then NULL /* shortcut for most common */ 95 when 2 /* DTYNUM */ then NULL 96 when 12 /* DTYDAT */ then NULL 97 when 58 /* DTYOPQ - XMLTYPE, ANYDATA, etc. */ then 98 (select lv.data_type 99 from sys.logmnr_tab_cols_support lv 100 where lv.logmnr_uid = o.logmnr_uid and 101 lv.obj# = lc.obj# and 102 lv.internal_column_id = lc.intcol#) 103 when 121 /* DTYADT */ then 104 (select lv.data_type 105 from sys.logmnr_tab_cols_support lv 106 where lv.logmnr_uid = o.logmnr_uid and 107 lv.obj# = lc.obj# and 108 lv.internal_column_id = lc.intcol#) 109 when 122 /* DTYNTB */ then 110 (select lv.data_type 111 from sys.logmnr_tab_cols_support lv 112 where lv.logmnr_uid = o.logmnr_uid and 113 lv.obj# = lc.obj# and 114 lv.internal_column_id = lc.intcol#) 115 when 123 /* DTYNAR */ then 116 (select lv.data_type 117 from sys.logmnr_tab_cols_support lv 118 where lv.logmnr_uid = o.logmnr_uid and 119 lv.obj# = lc.obj# and 120 lv.internal_column_id = lc.intcol#) 121 when 111 /* DTYIREF */ then /* needed? copied from dba_tab_cols */ 122 (select lv.data_type 123 from sys.logmnr_tab_cols_support lv 124 where lv.logmnr_uid = o.logmnr_uid and 125 lv.obj# = lc.obj# and 126 lv.internal_column_id = lc.intcol#) 127 else NULL end XTypeName, 128 case bitand(lc.property, 1029) 129 when 0 then 130 null 131 when 1 then 132 (select lv.qualified_col_name 133 from sys.logmnr_tab_cols_support lv 134 where lv.logmnr_uid = o.logmnr_uid and 135 lv.obj# = lc.obj# and 136 lv.internal_column_id = lc.intcol#) 137 when 5 then 138 (select lv.qualified_col_name 139 from sys.logmnr_tab_cols_support lv 140 where lv.logmnr_uid = o.logmnr_uid and 141 lv.obj# = lc.obj# and 142 lv.internal_column_id = lc.intcol#) 143 when 4 then 144 (select lv.qualified_col_name 145 from sys.logmnr_tab_cols_support lv 146 where lv.logmnr_uid = o.logmnr_uid and 147 lv.obj# = lc.obj# and 148 lv.internal_column_id = lc.intcol#) 149 when 1024 then 150 (select lv.qualified_col_name 151 from sys.logmnr_tab_cols_support lv 152 where lv.logmnr_uid = o.logmnr_uid and 153 lv.obj# = lc.obj# and 154 lv.internal_column_id = lc.intcol#) 155 else NULL end XFQColName, 156 /* topintcol */ 157 case when (bitand(lt.property,1) = 0) /* typed table bit not set */ 158 then /* relational table */ 159 /* most columns are not hidden and thus do not have */ 160 /* an associated topintcol. Certain special columns */ 161 /* where col# = 0 also do not have topintcol */ 162 case when 163 (bitand(lc.property,32) = 0) or /* not hidden column */ 164 (lc.col# = 0)then /* special column */ 165 NULL /* do not set topintcol */ 166 else /* it is hidden and is not col# = 0 (ie special) */ 167 /* so find the covering user visible column */ 168 (select min(sc.intcol#) /* min for speedup only */ 169 from system.logmnr_col$ sc 170 where sc.logmnr_uid = o.logmnr_uid and 171 sc.obj# = lc.obj# and 172 sc.col# = lc.col# and 173 bitand(sc.property,1) = 0 and /*not an attribute*/ 174 bitand(sc.property, 32) = 0) /* not hidden */ 175 end 176 else /* typed table */ 177 /* everything gets rowinfo$ column as topintcol except */ 178 /* for the rowinfo$ itself, and the oid */ 179 case when 180 (bitand(lc.property,2) = 0) and /* not an oid */ 181 (bitand(lc.property,512) = 0) then /* not rowinfo$ */ 182 (select min(sc.intcol#) /* min for speedup only */ 183 from system.logmnr_col$ sc 184 where sc.logmnr_uid = o.logmnr_uid and 185 sc.obj# = lc.obj# and 186 bitand(sc.property, 512) = 512) /* rowinfo col */ 187 else NULL end /* oid/rowinfo, leave topintcol null */ 188 end XTopIntCol, 189 case LC.TYPE# when 111 /* DTYIREF */ then 190 (select oo.obj# 191 from system.logmnr_obj$ oo, system.logmnr_refcon$ r 192 where oo.logmnr_uid = o.logmnr_uid and 193 r.logmnr_uid = o.logmnr_uid and 194 oo.oid$ = r.stabid and 195 r.intcol# = lc.intcol# and 196 r.obj# = o.obj#) 197 else NULL end XReffedTableObjn, 198 case LC.TYPE# when 111 /* DTYIREF */ then 199 (select oo.objv# 200 from system.logmnr_obj$ oo, system.logmnr_refcon$ r 201 where oo.logmnr_uid = o.logmnr_uid and 202 r.logmnr_uid = o.logmnr_uid and 203 oo.oid$ = r.stabid and 204 r.intcol# = lc.intcol# and 205 r.obj# = o.obj#) 206 else NULL end XReffedTableObjv, 207 case LC.TYPE# when 58 /* DTYOPQ */ then 208 (select ct.flags 209 from system.logmnr_coltype$ ct 210 where ct.logmnr_uid = o.logmnr_uid and ct.obj# = o.obj# and 211 ct.intcol# = lc.INTCOL#) 212 else NULL end XColTypeFlags, 213 case LC.TYPE# when 58 /* DTYOPQ */ then 214 (select ot.type 215 from system.logmnr_opqtype$ ot 216 where ot.logmnr_uid = o.logmnr_uid and ot.obj# = o.obj# and 217 ot.intcol# = lc.intcol#) 218 else NULL end XOpqTypeType, 219 case LC.TYPE# when 58 /* DTYOPQ */ then 220 (select ot.flags 221 from system.logmnr_opqtype$ ot 222 where ot.logmnr_uid = o.logmnr_uid and ot.obj# = o.obj# and 223 ot.intcol# = lc.intcol#) 224 else NULL end XOpqTypeFlags, 225 case LC.TYPE# when 58 /* DTYOPQ */ then 226 (select ot.lobcol 227 from system.logmnr_opqtype$ ot 228 where ot.logmnr_uid = o.logmnr_uid and ot.obj# = o.obj# and 229 ot.intcol# = lc.intcol#) 230 else NULL end XOpqLobIntcol, 231 case LC.TYPE# when 58 /* DTYOPQ */ then 232 (select ot.objcol 233 from system.logmnr_opqtype$ ot 234 where ot.logmnr_uid = o.logmnr_uid and ot.obj# = o.obj# and 235 ot.intcol# = lc.intcol#) 236 else NULL end XOpqObjIntcol, 237 /* xmlintcol */ 238 case when (bitand(lt.property,1) = 0) /* typed table bit not set */ 239 then /* relational table */ 240 /* most columns are not hidden and thus do not have */ 241 /* an associated topintcol/xmlintocol. */ 242 case when 243 (bitand(lc.property,32) = 0) then /* not hidden column */ 244 NULL /* do not set XMLintcol */ 245 else /* it is hidden and is not col# = 0 (ie special) */ 246 /* so find the covering user visible column */ 247 /* if it is not XML, then we want/get NULL */ 248 (select min(sc.intcol#) 249 from system.logmnr_col$ sc, system.logmnr_opqtype$ opq 250 where sc.logmnr_uid = o.logmnr_uid and 251 opq.logmnr_uid = o.logmnr_uid and 252 sc.obj# = lc.obj# and /* same obj# */ 253 opq.obj# = lc.obj# and /* same obj# */ 254 sc.col# = lc.col# and /* same col# */ 255 sc.intcol# = opq.intcol# and 256 bitand(sc.property,1) = 0 and /*not an attribute*/ 257 sc.type# = 58 and /* opaque type */ 258 opq.type = 1) /* XML */ 259 end 260 else /* typed table */ 261 (select min(sc.intcol#) /* NULL if topintocl is not XML */ 262 from system.logmnr_col$ sc, system.logmnr_opqtype$ opq 263 where sc.logmnr_uid = o.logmnr_uid and sc.obj# = lc.obj# and 264 opq.logmnr_uid = o.logmnr_uid and opq.obj# = lc.obj# and 265 opq.intcol# = sc.intcol# and 266 bitand(sc.property, 512) = 512 and /* rowinfo col */ 267 sc.type# = 58 and /* opaque type */ 268 opq.type = 1) /* XML */ 269 end XXMLIntCol, 270 case when (bitand(lc.property, 67108864) = 67108864) /* encrypt col */ 271 then 272 (select ea.owner# 273 from system.logmnr_enc$ ea 274 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 275 else NULL end EaOwner#, 276 case when (bitand(lc.property, 67108864) = 67108864) 277 then 278 (select ea.mkeyid 279 from system.logmnr_enc$ ea 280 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 281 else NULL end EaMKeyId, 282 case when (bitand(lc.property, 67108864) = 67108864) 283 then 284 (select ea.encalg 285 from system.logmnr_enc$ ea 286 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 287 else NULL end EaEncAlg, 288 case when (bitand(lc.property, 67108864) = 67108864) 289 then 290 (select ea.intalg 291 from system.logmnr_enc$ ea 292 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 293 else NULL end EaIntAlg, 294 case when (bitand(lc.property, 67108864) = 67108864) 295 then 296 (select ea.colklc 297 from system.logmnr_enc$ ea 298 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 299 else NULL end EaColKlc, 300 case when (bitand(lc.property, 67108864) = 67108864) 301 then 302 (select ea.klclen 303 from system.logmnr_enc$ ea 304 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 305 else NULL end EaKLcLen, 306 case when (bitand(lc.property, 67108864) = 67108864) 307 then 308 (select nvl(ea.flag,0) 309 from system.logmnr_enc$ ea 310 where ea.logmnr_uid = o.logmnr_uid and ea.obj# = o.obj#) 311 else NULL end EaFlags 312 from 313 system.logmnr_col$ lc, system.logmnr_tab$ lt, system.logmnr_obj$ o 314 where 315 o.logmnr_uid = lc.logmnr_uid AND 316 o.logmnr_uid = lt.logmnr_uid AND 317 o.obj# = lt.obj# AND 318 o.obj# = lc.obj# 319 order by lc.logmnr_uid, o.obj#, lc.intcol#; View created. SQL> @?/rdbms/admin/prvtredacta.plb SQL> CREATE OR REPLACE LIBRARY dbms_redact_lib 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 16 20 2b 61 21 Q7rRMxW3WwEtyoW5JnbNK7R/NR4wg04I9Z7AdBjDWqGXYkqW8i6hWdH0cvpZCee9nrLLUjLM 22 pXQr58tSdAj1Ycmmpnu6skg= 23 24 / Library created. SQL> CREATE OR REPLACE PACKAGE dbms_redact_int 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 9 20 10ae 34b 21 8o9ie443X7hpiLjHEuuPNXqy2twwg0Pqr0rrfC9DaGSl8xRGqe/Vy+KCeS62BcLGmAXtVJhW 22 W8u4qXOqOMbe/XjwHifV3+NNANsjcoIgBkK3Fpc89b1dCO7GIP4eBYZzsUn+c8G2a8nf75Gj 23 JLXqo2VN2DnmCpc+k8dhCNlGNKdOlt1QiGGsQPFVlUS+6Ow7Tfm0BhmfVzX9yhTWbRIfhsV8 24 WccCcRiEccbk0ljnurH3lZF5/fcFAGp7gjwVnm9Ly3ie8VTH0U0ZV9Evpw4dCux41N5NFmq/ 25 be7LGCdPf6zfRFLuK958yRNDEUQ1UEKQiTicT4kqUKRVu0qD5pHeT5s7m4hrroCJK0sL3mkq 26 AY90J9GnY1ZsssZBboyU5MhpFAsr9i90ZYn+vWNrhSv48k96ts35fdgItFmN+FfGCsyyYpLX 27 PdgORNViXDUob2FwOFscFWBeEN6q5XNqE0aEzEAHAFR3ta84jIZ6xgPoHiK+3LWaTEOTXs1x 28 PJl7BHg4M1mx2/F+hg5uRYYbPpbDhtBBk8Z+vmlvVeYnqqvHOREI50imbZhM64PJ6QKlvKRV 29 q98fjgGVnWYe04x5ZFXlGGZTj/+QXlsXSAMqLasV38eaDj/eE8xxqGr29h3uGGK5tpp/ukhU 30 qBRqeUKQi2IyEVfvevc5dL5KRFlC3t3d/Zl1pYODbJIVl94QESPYpwc0+9agzEkweDCcfQVO 31 SFfig7rASUQUNOQmof/W+/VqOH8n3Gz/w+AMbE84AEetVVVeIW4XbBWFAY2kQs2ral8K0Gau 32 xHhOmrqShR0qqlwwMHHK5fn4cAS56mT5puRoQmU= 33 34 / Package created. SQL> show errors; No errors. SQL> CREATE OR REPLACE PACKAGE BODY dbms_redact_int 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 2acc 85d 21 RXVM6qC2DQSM9sVtkIm5vZbUdp8wg81UDF52eC//WA9rZXbKDUNl27BpElAnNgp8ClglEXTO 22 ZQId4sCI2tEFXcgPTzwLyYFukETGG2GtptWBDHMQVSd58PqIImMRzJScfZI9mK5VxhMeCiQk 23 vyAZqmBTMTXa5z1RZqARROlTFkVFxYi+RgFGMwqVLImF4qgMRRURzjh27d2sVi1XJcCC1cYI 24 GGYhZhd+rqfVEYQ2CmwKMBYXKqpP7xmnY7NmXDHiznWB8ztiEJCgbhYx3Ic8d04NcHZt2UpS 25 oa4maaOV4D31rG91hbBJLQKrmeNUCbNZpQyWJzUT6NBlEzWXCFHSJXzb6lxsldZ7VJxRY2AM 26 Z4UfKqIUqHYiKtYrDFBF20af8I5fT9w95QpAocFX+nQcI8WUqDsvibZ7UZtHXpM4oaceWSBd 27 RmGWmGH7MfdWmMCk1cIXUCVbknj2L+1pMZXUH+bsZK4Z+QueTvySRfj4ffRV1THmqaSc5qTY 28 MVXHG5zjw4+G5maYYcnr3Cz/vJSIb8lYReLngo/p8TgubBSCDZDIR7hXqFgmfSnxXx9fcJO9 29 d1ZKPCVY/HlvcniXfsJ96sdmJX5VSc3J/FNMduIBZVwTpZA7uxq7WUzBzdSkcEdIVDqHMwNV 30 OEfgtAQJb4aLf8l/iv06A8akG954xwNDHj68nPGfgsRUvAnogy6/FYlV9Zb1f1dXGQjU8ObD 31 gUZCCwZTf1KD55XoDUMe0KoQtLw+JFNJrs2FXvhSVlt1NoJwvTciGD4vtogZ87fJViqVq6ck 32 kdHPNLYZtCGBjK5IKCOtfgqBsrDbBXJ4LLsqST/QC+BhkfHqo+g7MGoVcq9OwWk6x03knXSN 33 +aZeS2DtWN/wfF7UnD6M2QDB+nhP4odVGc9k72Nb40JqSHY+Sde3t0D6+DXATvkTymWy0N4R 34 ftQGGoc16t7/dHRfsTuK3MX78BtEZ9WQcxEFEZ3dAQxehRZ4L/K/YJa78PoeKLsZTBAj+Jqs 35 BheoAgecB0apT/RGqU9t3nwN5FKmAuhmMv75B9vlO5lW3rAZEDNuJ4Uly0ehM0KYo91zRAwQ 36 EmXVFvkpLAT8xmipptsOJjI9nubvRaNy4LQK1K5YXxz+pOVUx8sQAJprJdmt0tL1uTROJo3X 37 wbfwjGOBFLqzYAZc7TW7cbzS/8Q86xrDLLPZGF6urg0KSzbk4VP4uHOSuTM8UKpf5POB7wZb 38 oE9E5Pvy7I1HvCQyzXRxGDGO8drJunqdAnT0fqJ08rTntIgx47QTGGofGIbniFhL80sofk2N 39 R0gl5t2E9jX3Fu/3LQYtZd5sj3l+lSHo+VgH3Cl8eBPfGiQRJXtV3WhqrJcr0nmhXkyWKAvE 40 MVc8bTYFwUgg4LXEFyfngJkjl1Pw6badjdiRm5s+EcN2FWIxDEVK4N9U7Gvxm16+cdh4KMtK 41 O2y1roQMBPD1cJi4dJOyf0HjJ2MkimtObAK82EdHB3B/lsgjabv/KPAB/mg8QIMONOPr5x1Y 42 T+n4jjjcl6y+eScY8N6gMhi/1AOKRvGXAwNVF3vOAbayrN9y32mQyc6qcuNDCUyQx2cRGUkM 43 Yibt6ECw5ORpEN8xIch2qMrCOv6+OAjIlobfbXR6eluRQMPUhVOaJVnp1HX5BoVXaxrIUmEA 44 kVYcpkRaVFp+RqvTzqq2FKZDNK6wErgL1C4II1PeysYInDkPc8yQkgZm3X9+k/u40a1oMgEt 45 jB+4vyH/kqvXGRx0HdyEgXIZXjySS1GLXpqWyYU7rQqPZgzlp9lzDyh0oEhUqw83bVxJbQBb 46 4Ftpsrg7f7/CKVAHkDAbwX2I8QyDv/bUqFreev5KIbyYgguU+RaBHdUgQAW8BnDHzcfOj2cB 47 QlnZ6J3/R0c0M0QhghyLiMJ5QsnKZXYxCXuEBqjaoWHGmhEuqACSwtiuz75utzqbjX/SnYAJ 48 fx2ceXAr+s+rTX0zcgv1nWXvBY1Yhw3wQhl463eQRQHz8TLzox6EKvEtJyGoNlyI65E0xfQ7 49 8s3eQSZAB2MRoGkL0K/XovIY6VHYE2SjsPSS8j0r5dxh0adbaH9EyCzIEN0uZeBtfqrVPksD 50 pqyCDbu8kDd7xp3kmfQ/UP8= 51 52 / Package body created. SQL> show errors; No errors. SQL> CREATE OR REPLACE PACKAGE BODY dbms_redact 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 36e9 725 21 4T62shDrFEa7csrx8R0dmVbSiQgwg82jDNAF3y+5MZ2sB+GYOazpJQsfy2cM0uxM9I5aJ7+Q 22 bcjfADMlM7WMGofP4/GhMf974s98bu7PblsXzs7fRFlB7rbhuuwc3cSatZKwkvhyIA+1zh9n 23 vOEOcCE13vovqd6jlCFq+jUY+1OwBZppZsVBiszLNbWvNjRnp4qo+GON5EX7GkfCq4Fr6fN1 24 76Y0TWBkLY7YnGZBfHHnWaHjH73Xl25Z1yI3GKAN1aFR9dVSFsgB9m29kQeetjdBL15N9RNO 25 GGuOGwY4eG5rqVkjVi+G+5+zuq8vwZCcjIiiNkiC1bLtqonJ5zO4rZhwbCdpWUXkK1rQRvUH 26 RslL6X/DkXw1lB90t7BpwzWtb2BXGXQ/wsohofLUL6FQNl2MRPprWjN764DPutkg2JKRbUF8 27 JukwwTM5iypwstscKnumpR2qfCu6Ok6P9bTDnHkiCojlRpd8GdtzTPr3dE5DuWpMtktNiV1I 28 Va4hPDDAZguiCtDST8N4YDn8SPYRMvaihmCrzAZf9zdFxl8gooZgI2kG2PMo3UittnBfEWha 29 66FuHH+gczuwoB7zO60lSAnrHIjKaCvr5xKREZcp32rD2mWpU1XoqCORpsD4LtZu84yeX9Nb 30 sNJGPmS4q3jz3PgmPNCBKIlS9WEzYWCn34eDMN6GDMQtSJHxlwvkUj1PwUH86gd7lGrWAIrO 31 /rsvdvQnEfzolh1I/DtM0miTRZIAPbfwYY5VmhDeI59HmZyLUAYo6msfemTc1X1CvhCcRfm8 32 rdJhN5JjIFyBPzs6GImzZqlLfJq/+1npyszu5ZCBkH1gMx0yh7QurWXd/ha1LRMVNJQuZTZY 33 wWmGxL68SQISRApV5GXldzEjcBuWRepapxWiU67sysUJzS3X0RCeECPton2OKc4kSVeu77SG 34 acFsXlUcegUcqw09onkhC7LFjRP3PV+Y6hT208ZY2Aa9t1TTkRtE0y6pRw4ki/EsTjBhQqAx 35 WBGnu9eNYDJku/JL9SklYwycQYNjItQmYqr48YtJQ2/J9ThgmvCIpDvrOCzRISnmtxlXLidx 36 TXFRjseB6pcLz+l0zKsVaXGnZqTU9RJW3vVfsYSQk+LagbTks+QWEG/paFvMyR87hTjDeOrI 37 s6iHLgCjQdpDU9XAOmePci5s4AmJUYPMG5p0QcJRY3zUW2qykkTJbJuUY2XvmmA9gnvOl/N0 38 HrPEdKdqHZwBo1k1taNhduom30SQp82qJFxiffWKyhpKqHwPH8W7kApBiZxd7be8y67E7oqB 39 STRSPKFCkxppDvJSzXm4GOZNzSHSrwA+Tjs05lrMxJPf03zkVAUIb7dMYGsR9+xr4mO3U4mn 40 5WL2DtQqJcxuo5gZ2auwFKZ2TgNMM8t7GuWAuNvfTZtlyVDUMTmUSEcOAgqx+hiuoUrGSVM3 41 5VLhweOZdR+AuGQGbZRP1O3gLWS1vbxprEr3Ory5raO/1pe3ROJE1YEp4v88e039Az59oIrY 42 DGIMUN4xbeVZ7KyH2RXFYl5Q3jGZGw2gDl4tsWDlVOE7AeKiOwHnfovonTsE+v34qjXXq6Y5 43 6zSDlGa1iIWwKxOROvy0BF40ucztJJ3KYTohCDNh7CL/SFtcpzveG34Tn/Au74O41nli/bYC 44 dbmxAP/lrD7WAHrbp5PJUoujGsIR3NNF4pHokyWIbMxS8To30+8J0wQnIMS7UFcT8uiKgaVQ 45 oGHNHBcuTf41Yd4t7uhFAO887BUqOZiI5n5BKQr53BFBC7NVAehKy76ngdpeT9/QJHNbTkp1 46 LA== 47 48 / Package body created. SQL> show errors; No errors. SQL> @?/rdbms/admin/prvtpckl.plb SQL> create or replace library SYS.DBMS_PICKLER_LIB 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 16 20 2b 61 21 aAn+BI9qqDtarCwYQNuFQC2dGnQwg04I9Z7AdBjDuFKbskoopfUzM1KyGP4I9QnnvZ6yy1Iy 22 zKV0K+fLUnQI9cmmpst5mfw= 23 24 / Library created. SQL> create or replace package dbms_pickler 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 9 20 2a4 15c 21 2cx8UAQRQDdifROcEcqAnXO7Ic0wgzvxAPZqfC9A2vjqaH2psOJY/yX60y0iV6E+WDZzBOa6 22 Fs21B6OyO4YvrilS6xIsu8fm+5XLW6zBxv5km1LPIxASOja2E2ABSfEIyzny6UJhdQ5cJdZy 23 vQQs392JZdp98IQijobTstsFOXD/Q6f158NR1GdQYGv6Zor3AmC8u3DFe6AXFSGqGCYG8OSB 24 zXCudh6XxVbXmEJg1E+SfVW47KuWiS4qVK3uOYqqa7mAmg+oh1siqk4NbtCXNeBR8SH4en0V 25 Gg6y2KduH1/I/CoNhtAzJwS6quuyhbKtvcLELTbvn4Z3I/6yXQsORA== 26 27 / Package created. SQL> CREATE OR REPLACE PUBLIC SYNONYM dbms_pickler FOR sys.dbms_pickler 2 / Synonym created. SQL> GRANT EXECUTE ON dbms_pickler TO PUBLIC 2 / Grant succeeded. SQL> create or replace package body dbms_pickler 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 bb4 390 21 er+M1S70C/BUEHeqrGsMXz9EiW0wg1UrmtC3Zy8zWJ3gNLDf7ms8GxvxElRwN9dimZOnTpKi 22 UT3bTS0I0rW/Mx9E8v0FXXdxT7RYkCDJvDp7abddSl2OBsVVFblzxMZItTpqnGQsqqb2rMr2 23 6VFUbMqw5dnFk9M9lXmnzL1tVjsOJ5Ram0i98eUrnuNYysAFf2sRSr8vrCIWxUTuN8psAhMA 24 4KqDEJ29J2azqbzU4Wx0UuZQcmxCj8NntiDm0G1y2akDVGZ7GlIx9SoMuVeNpKuMMXu1oGdQ 25 rS1JEHkII+2jO6fzqwFlvv1Ef9dYS+LExMZfVlb/ZeFtJpaTt68DOgGsSMUl3tc+edP6J1z6 26 OW8uCVDx3QD3oTVdezYNO/e81vsIiiiklAwQnKho70+rCf3UQyjgJdTOQmzA/ZVJp2x2niJm 27 R3BH8IHBuVIhK7HpjBS2Que5haKX06wQgzp71f/a6gJ/shLrLvgwv27b2h70MGrwXqfay9s9 28 mtLY8GoqPiJvT8HhOo/LJFLBq0S1HSrbNBgXibhg50khSz9AZmdIMAHTo2JfTiS+dksngypE 29 JimqvP1QAj5zZVXOTBhNxpmncogXYdFn5qKEPm4xata1be+FTtNFrJIzhOoufZ583pM51TBC 30 beNFg+EXi4WEz7PAHIjgkh0sHHysm0DLZn7UItSLHox+o5CUDx11QuTAdRJ45HMIDy10/9yH 31 hgCMWCTNhQV7bBif5ch5Sd7oRGFNAd9BBpGsDvWoiznVgcFoDZnksT94g5p7LQ/earLetiPQ 32 1ymunOJThGpcEx/owZmruZXa+JipspZ/jkD/Sg97I7SpDBmsMNahETaGDod5KyCKHHXcv2Xy 33 VT1pibSshkjew3xqNpsapISSUR+d+/0M/M8= 34 35 / Package body created. SQL> begin 2 execute immediate 'revoke execute on dbms_java_test from PUBLIC'; 3 exception when others 4 then null; 5 end; 6 / PL/SQL procedure successfully completed. SQL> create or replace package dbms_java_test 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 9 20 2e60 1a1 21 B2Rm0P1PcoDMwbdCpBaTSvF2YfEwg83smMusZy/pO3MYPiprac/GJwKB9BG0PadwoH8tFc5z 22 q5n9tu0Rz+5jZhN2cBe53p911SBROaM8CkyrILeE07t4KYdg6BYlD0ZBpNcVTvCe4T5CN2Vg 23 p8WbQMXApFgn2m46nALCooPRUaXCUBBdPv+9RapY/LAPmeG5chBJ53ebnX8vTQPT6o2mNzkM 24 /s8pZw76o6oOPMpQ4Mc/a63KUMl4xzEuL31Lc36qp9RcBAQ5iy3dDqKN8wvbGZR/ibiI8kCb 25 EoT003qeC1/HlAuJj/pJ1rXBr4C9QfVelOXxzJSJjxHWwMzinNkC03bJzID8zgJ7UTbBnI51 26 4cHmcImPR+yXXjokXBwyu4uqnnvSlbsuLnorDJS6eX7EuDZDbHKs 27 28 / Package created. SQL> CREATE OR REPLACE PUBLIC SYNONYM dbms_java_test FOR sys.dbms_java_test 2 / Synonym created. SQL> create or replace package body dbms_java_test 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 63c5 4f5 21 BffvCpTdZTFoT3O1HqWf7nN37eUwg81xDK6GfARogp0VBjYJKDrx0mzcSCfyp8hR20NSGLSx 22 OA+jvZ+qtUAl4Arx9gs4fQsjZy57tvE65NeiO5AMQZBO9HCMKc6nEDrSHrw6P/674kLOI7Xd 23 m5KpLeuTWPrPo8JfH+leDNFO2DqFZDDHqF0x9UdKo1Dr1dUwTAPVhwEXNBjafvswGQh0XT0a 24 +ugDCcLMh5v8YfoMPhtRCePsQd5+Vtw62MjYbpQCQOM749sYWjvj4pSzA2aSK9vdGASj844x 25 qJ9c+tHVMTJsmEuR6qeKJfFMusJtDJ8yC9ZFxtjTwCuN/OtCseP9PuXxH80F8Q/nn87BTtBP 26 mvn5IpGKe5wXVhNh7/lgYSwPm+VEoH3spGIz5aqYV5+ol6EM5YDeF77VlsZC1EOg7LtM3q+j 27 K0KtKVZhdFDpv9EtbS4dVDKK5BR36PuaM7ub3c26thYrDrTn8o4Wf6wJRPLwDuLhMvAOQeGB 28 Xw684YHwDjfhsl8Oa+Gy1+Bg7Oz3iOhtSCuQITH62NreFbeTQiUaSQMzGvSuyYGht09Hkrcr 29 pmXqqaDTyL45GpQ3R1zjDcXb1VxXIhabzD1giP3Q0fyLZXL/mcwqzf+3HQCiLJqgrYNhkpLY 30 IbSXWlmbwDr3qMhPy+164AfpxklZiQudTmmcnbljY4HVQVcAp4Yurhn3LwdTg84IJ1XccIH1 31 37rvgObT5nfbD8OWK8ILY7gUGqgnnLwyzTRUKbzqaPdQsn+iRQV/ojRUTHTYH8tWgOaW21qK 32 zZta0uCBfD+E0A+A5iTbqbsL3WQ8lW09gBN+cRNX0zmokiepvCOQvJvgslDwBZrwSkY44zOk 33 URCaAxDtVIQhcxzf7fbuUcoPeYCl9M1OvZZv6UsftG3W7VNlFeQ8YHwa7X8UJKuvxo8LNc9H 34 jfNdv78Y7s+4vIHvPdBvanw4df3gdeJfygO4FjeVFeDWVNgsYjeCaljEPFhMiDXJQ8yelgec 35 IPGc+LN8ILbzS67zj5fnZa6cReeyRtTLRkAssl6+9yqF7DKThpfnZb9PfEIsKaDGKV2AapLL 36 RqvmzTKE143zkekoOKEo4C9/ziUE0ow4MR8ltik6GSkpl+fCJdBLdyhCbTQQjDSBjDgAFuCr 37 f+0Qf82X58I5dUvnBK9KcJqKcP6MOCZXuVu4JEso/h3i7R9dCKZ/HCip2udoNYpdpEYP6goH 38 WqCqT0F/Iv4oPidCm+4kqc5WiA== 39 40 / Package body created. SQL> begin 2 execute immediate 3 'declare objn number;begin select obj# into objn from obj$ where name =''DBMS_JAVA'' and type#=11;dbms_utility.validate(objn);end;'; 4 exception when others 5 then null; 6 end; 7 / PL/SQL procedure successfully completed. SQL> PROMPT Processing Spatial... Processing Spatial... SQL> ALTER SESSION SET current_schema = sys; Session altered. SQL> @?/patch/scripts/bug17088068.sql SQL> Rem SQL> Rem $Header: sdo/admin/bug17088068.sql /st_sdo_11.2.0.4.0dbpsu/1 2013/10/15 10:39:46 zzhang Exp $ SQL> Rem SQL> Rem bug17088068.sql SQL> Rem SQL> Rem Copyright (c) 2013, Oracle and/or its affiliates. All rights reserved. SQL> Rem SQL> Rem NAME SQL> Rem bug17088068.sql - <one-line expansion of the name> SQL> Rem SQL> Rem DESCRIPTION SQL> Rem <short description of component this file declares/defines> SQL> Rem SQL> Rem NOTES SQL> Rem <other useful comments, qualifications, etc.> SQL> Rem SQL> Rem MODIFIED (MM/DD/YY) SQL> Rem zzhang 10/09/13 - Created SQL> Rem SQL> Rem BEGIN SQL_FILE_METADATA SQL> Rem SQL_SOURCE_FILE: sdo/admin/bug17088068.sql SQL> Rem SQL_SHIPPED_FILE: SQL> Rem SQL_PHASE: SQL> Rem SQL_STARTUP_MODE: NORMAL SQL> Rem SQL_IGNORABLE_ERRORS: NONE SQL> Rem SQL_CALLING_FILE: SQL> Rem END SQL_FILE_METADATA SQL> SQL> SQL> ALTER SESSION SET CURRENT_SCHEMA = MDSYS; Session altered. SQL> SQL> declare 2 begin 3 begin 4 execute immediate 'drop package MDSYS.sdo_geor_lizardtech '; 5 exception when others then NULL; 6 end; 7 begin 8 execute immediate 'drop library MDSYS.sdo_geor_lizardtech_lib '; 9 exception when others then NULL; 10 end; 11 end; 12 / PL/SQL procedure successfully completed. SQL> ALTER SESSION SET CURRENT_SCHEMA = SYS; Session altered. SQL> SQL> declare 2 stmt varchar2(200); 3 oname varchar2(32); 4 otype varchar2(32); 5 type cursor_type is REF CURSOR; 6 query_crs cursor_type ; 7 begin 8 stmt :='select object_name,OBJECT_TYPE from all_objects where owner=''MDSYS'' and status = ''INVALID'''; 9 OPEN query_crs FOR stmt; 10 LOOP 11 BEGIN 12 fetch query_crs into oname,otype; 13 EXIT when query_crs%NOTFOUND ; 14 begin 15 if(otype='PACKAGE BODY') 16 then 17 EXECUTE immediate ' alter package mdsys.'||oname||' compile body'; 18 elsif (otype='FUNCTION') 19 then 20 EXECUTE immediate ' alter function mdsys.'||oname||' compile'; 21 end if; 22 EXCEPTION 23 WHEN OTHERS THEN 24 oname:=''; 25 end; 26 commit; 27 end; 28 END LOOP; 29 close query_crs; 30 end; 31 / PL/SQL procedure successfully completed. SQL> SQL> SQL> ALTER SESSION SET current_schema = SYS; Session altered. SQL> PROMPT Updating registry... Updating registry... SQL> INSERT INTO registry$history 2 (action_time, action, 3 namespace, version, id, 4 bundle_series, comments) 5 VALUES 6 (SYSTIMESTAMP, 'APPLY', 7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'), 8 '11.2.0.4', 9 4, 10 'PSU', 11 'PSU 11.2.0.4.4'); 1 row created. SQL> COMMIT; Commit complete. SQL> SPOOL off SQL> SET echo off Check the following log file for errors: /opt/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_TRAIL_APPLY_2014Dec04_21_57_47.log
4.验证PSU补丁是否应用成功
[oracle@DB OPatch]$ ./opatch lspatches 19121551;Database Patch Set Update : 11.2.0.4.4 (19121551) [oracle@DB OPatch]$ ./opatch lsinventory 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_22-26-01下午_1.log Lsinventory Output file location : /opt/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-12-04_22-26-01下午.txt -------------------------------------------------------------------------------- 已安装的顶级产品 (1): Oracle Database 11g 11.2.0.4.0 此 Oracle 主目录中已安装 1 个产品。 中间补丁程序 (1) : Patch 19121551 : applied on Thu Dec 04 21:54:53 CST 2014 Unique Patch ID: 17949166 Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDT Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@DB OPatch]$ SQL> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ------------------------------ -------------------- ---------- ---------- ---------- --------------- ---------------------------------------- 2013-08-24 12:03:45.119862 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 2014-12-04 17:48:29.485704 APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 2014-12-04 21:57:50.086900 APPLY SERVER 11.2.0.4 4 PSU PSU 11.2.0.4.4 SQL>
AlfredZhao©版权所有「从Oracle起航,领略精彩的IT技术。」