本文记录了打PSU的全过程,意在体会数据库打PSU补丁的整个过程。
1.OPatch替换为最新版本
代码语言:javascript复制[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补丁程序
代码语言:javascript复制[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.数据库打补丁
代码语言:javascript复制[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补丁是否应用成功
代码语言:javascript复制[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>