Online Patching OCP 050Oracle 11gonline patch(hot patch)Hot patchingfixdiagnostic patchesOracle bug Oracle opatch Oraclebug 2.1 1 Oracle2 OPatch 3 OPatch opatch query -is_online_patch
2.4 1 Linux x86 Linux x86-64 Solaris SPARC64–1.3 2 Oracle Oracle OS (OS) Linux x86 4 KBSolaris SPARC64 8 KBOracle 4 MB 3 Oracle 4 bug bug bug 5 6 bug . Online Patch 11.2.0.3SQL> select * from v$version;BANNER——————————————–Oracle Database 11g Enterprise EditionRelease 11.2.0.3.0 – 64bit ProductionPL/SQL Release 11.2.0.3.0 – ProductionCORE11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 -ProductionNLSRTL Version 11.2.0.3.0 ProductionGoogleonlinepatchOracle online patching for bug 13817131(backport for ORA-7445 near ksfqfcrx()+X during RMAN backups)http://jakub.wartak.pl/blog/?p=624online patch138171313.1 [oracle@dave u01]$ unzipp13817131_112030_Linux-x86-64.zipArchive:p13817131_112030_Linux-x86-64.zipcreating: 13817131/creating: 13817131/etc/creating: 13817131/etc/xml/inflating: 13817131/etc/xml/ShiphomeDirectoryStructure.xmlinflating: 13817131/etc/xml/GenericActions.xmlcreating: 13817131/etc/config/inflating: 13817131/etc/config/inventory.xmlinflating: 13817131/etc/config/actions.xmlinflating: 13817131/etc/config/deploy.xmlcreating: 13817131/online/creating: 13817131/online/files/creating: 13817131/online/files/hpatch/inflating: 13817131/online/files/hpatch/bug13817131.pchcreating: 13817131/online/etc/creating: 13817131/online/etc/xml/inflating: 13817131/online/etc/xml/GenericActions.xmlinflating: 13817131/online/etc/xml/ShiphomeDirectoryStructure.xmlcreating: 13817131/online/etc/config/inflating: 13817131/online/etc/config/actions.xmlinflating: 13817131/online/etc/config/deploy.xmlinflating: 13817131/online/etc/config/inventory.xmlcreating: 13817131/files/creating: 13817131/files/lib/creating: 13817131/files/lib/libserver11.a/inflating: 13817131/files/lib/libserver11.a/ksfq.oinflating: 13817131/README.txt3.2 Patch 3.2.1 online patchonline [oracle@dave u01]$ ls13817131dave dave2.trc p13817131_112030_Linux-x86-64.zip rcopy.shrename.shappdave1.trc nohup.out rcopy.out rcopy.sh.out[oracle@dave u01]$ tree 1381713113817131|– etc||– config|| |– actions.xml|| |– deploy.xml|| `– inventory.xml|`– xml||– GenericActions.xml|`– ShiphomeDirectoryStructure.xml|– files|`– lib|`– libserver11.a|`– ksfq.o|– online||– etc|| |– config|| | |– actions.xml|| | |– deploy.xml|| | `– inventory.xml|| `– xml|| |– GenericActions.xml|| `–ShiphomeDirectoryStructure.xml|`– files|`– hpatch|`– bug13817131.pch`– README.txt12 directories, 13 files3.2.2 opatch patch [oracle@dave u01]$ mv 13817131/u01/app/oracle/product/11.2.0/db_1/OPatch[ora免费云主机域名cle@dave u01]$ cd/u01/app/oracle/product/11.2.0/db_1/OPatch[oracle@dave OPatch]$ ls13817131emdpatch.pl jlib opatchopatch.ini opatchprereqsdocsfmw ocm opatch.batopatch.pl[oracle@dave OPatch]$ ./opatch query 13817131 -allInvoking OPatch 11.2.0.1.7Oracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventoryfrom : /etc/oraInst.locOPatch version : 11.2.0.1.7OUI version : 11.2.0.3.0Log file location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3012-10-09_19-00-40????.log——————————————–Patch created on 25 Sep 2012, 08:46:37 hrsPST8PDTNeedto shutdown Oracle instances: truePatch is roll-backable: truePatch is a “Patchset Update”: falsePatch is a rolling patch: truePatch has sql related actions: falsePatch is an online patch: falsePatch is a portal patch: falsePatch is an “auto-enabled” patch:falseListof platforms supported:226: Linux x86-64Listof bugs to be fixed:13817131: OAMORA-7445-[KSFQFCRX()+812] [SIGSEGV] [ADDR 0X8 ]Thispatch is a “singleton” patch.Thispatch belongs to the “db” product familyListof executables affected:ORACLE_HOME/bin/oracleListof optional components:oracle.rdbms: 11.2.0.3.0Listof optional actions:Update /u01/app/oracle/product/11.2.0/db_1/lib/libserver11.a with/ksfq.o cd/u01/app/oracle/product/11.2.0/db_1/rdbms/lib; make -f ins_rdbms.mk ioracleORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1Possible XML representation of the patch:
rm orapatch$ORACLE_SID.cfg–
Removing the orapatch*.cfg removes all of the online patches currentlyinstalled for the instance.–online patch[oracle@dave db_1]$ cd hpatch/[oracle@dave hpatch]$ pwd/u01/app/oracle/product/11.2.0/db_1/hpatch[oracle@dave hpatch]$ lsbug13817131.pch bug13817131.pchdave.fixup bug13817131.so orapatchdave.cfg3.5 rollback patch1.7 [oracle@dave db_1]$ opatch rollback -id 13817131 -connectString dave:sys:oracleInvoking OPatch 11.2.0.1.7Oracle 11.2.0.1.7 (c) 2011, Oracle CorporationOracle Home : /u01/app/oracle/product/11.2.0/db_1Central Inventory : /u01/app/oraInventoryfrom : /etc/oraInst.locOPatch version : 11.2.0.1.7OUI version : 11.2.0.3.0Log file location :/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3012-10-09_19-32-31.logRollbackSession OH ‘/u01/app/oracle/product/11.2.0/db_1’ ‘13817131’ ‘-all_nodes’ / RAC ‘-all_nodes’ oracle.rdbms, 11.2.0.3.0 …The patch will be removed from activedatabase instances. ‘dave’ ‘bug13817131.pch’RollbackSession ‘13817131’Log file location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3012-10-09_19-32-31.logOPatch succeeded.–alert logTue Oct 09 19:32:41 2012Patch bug13817131.pch Disabled – Update #5Patch bug13817131.pch Removed – Update #6Tue Oct 09 19:32:44 2012Online patchbug13817131.pch has been disabledOnline patchbug13817131.pch has been removed–PMON[oracle@dave trace]$ pmap -d 2118|tail-2000007fb4ef239000 264 rwx– 0000000000288000 008:00003libnnz11.so00007fb4ef27b000 12 rwx– 0000000000000000 000:00000 [ anon ]00007fb4ef28c000 4 r-x– 000000000c955000 008:00003oracle00007fb4ef28d000 4rwxs- 0000000000000000 008:00003 hc_dave.dat00007fb4ef28e000 8 rwx– 0000000000000000 000:00000 [ anon ]00007fb4ef290000 864 r-x– 0000000000000000 008:00003libskgxp11.so00007fb4ef368000 1024 —– 00000000000d8000 008:00003libskgxp11.so00007fb4ef468000 8 rwx– 00000000000d8000 008:00003libskgxp11.so00007fb4ef46a000 392 r-x– 0000000000000000 008:00003libcell11.so00007fb4ef4cc000 1024 —– 0000000000062000 008:00003libcell11.so00007fb4ef5cc000 40 rwx– 0000000000062000 008:00003libcell11.so00007fb4ef5d6000 8 rwx– 0000000000000000 000:00000 [ anon ]00007fb4ef5d8000 4 r-x– 0000000000000000 008:00003libodmd11.so00007fb4ef5d9000 1024 —– 0000000000001000 008:00003libodmd11.so00007fb4ef6d9000 4 rwx– 0000000000001000 008:00003libodmd11.so00007fb4ef6da000 4 rwx– 0000000000000000 000:00000 [ anon ]00007ffff0261000 132 rwx– 0000000000000000 000:00000 [ stack ]00007ffff03f6000 4 r-x– 0000000000000000 000:00000 [ anon ]ffffffffff600000 4 r-x– 0000000000000000 000:00000 [ anon ]mapped: 964344K writeable/private: 8068K shared: 720900Koradebugdisable opatch rollback online patch
这篇文章主要介绍了怎么给第三方人员提供oracle接口，具有一定借鉴价值，感兴趣的朋友可以参考下，希望大家阅读完这篇文章之后大有收获，下面让小编带着大家一起了解一下。在实际项目中常常需要做接口提供给其他平台使用，需要给调用者提供Oracle数据库用户，此用户可…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
