1. Critical Patch Update
oracle 유저로 패치 내역 확인
export PATH=$PATH:$ORACLE_HOME/OPatch:/usr/ccs/bin opatch lsinventory
[oracle@orcl ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch:/usr/ccs/bin [oracle@orcl ~]$ opatch lsinventory Oracle Interim Patch Installer version 1.0.0.0.61 Copyright (c) 2009 Oracle Corporation. All Rights Reserved.. Oracle recommends you to use the latest OPatch version and read the OPatch documentation available in the OPatch/docs directory for usage. For information about the latest OPatch and other support-related issues, refer to document ID 293369.1 available on My Oracle Support (https://myoraclesupport.oracle.com) Oracle Home : /u01/app/oracle/product/10.1.0/db_1 Oracle Home Inventory : /u01/app/oracle/product/10.1.0/db_1/inventory Central Inventory : /u01/app/oracle/oraInventory from : /etc/oraInst.loc OUI location : /u01/app/oracle/product/10.1.0/db_1/oui OUI shared library : /u01/app/oracle/product/10.1.0/db_1/oui/lib/linux/liboraInstaller.so Java location : /u01/app/oracle/product/10.1.0/db_1/jre/1.4.2/bin/java Log file location : /u01/app/oracle/product/10.1.0/db_1/.patch_storage/<patch ID>/*.log Creating log file "/u01/app/oracle/product/10.1.0/db_1/.patch_storage/LsInventory__06-21-2017_12-56-17.log" Result: There is no Interim Patch OPatch succeeded.
oracle 유저로 패치
cd 13343482 opatch apply
[oracle@orcl sf_oracle]$ cd 13343482 [oracle@orcl 13343482]$ opatch apply Oracle Interim Patch Installer version 1.0.0.0.61 Copyright (c) 2009 Oracle Corporation. All Rights Reserved.. Oracle recommends you to use the latest OPatch version and read the OPatch documentation available in the OPatch/docs directory for usage. For information about the latest OPatch and other support-related issues, refer to document ID 293369.1 available on My Oracle Support (https://myoraclesupport.oracle.com) Oracle Home : /u01/app/oracle/product/10.1.0/db_1 Oracle Home Inventory : /u01/app/oracle/product/10.1.0/db_1/inventory Central Inventory : /u01/app/oracle/oraInventory from : /etc/oraInst.loc OUI location : /u01/app/oracle/product/10.1.0/db_1/oui OUI shared library : /u01/app/oracle/product/10.1.0/db_1/oui/lib/linux/liboraInstaller.so Java location : /u01/app/oracle/product/10.1.0/db_1/jre/1.4.2/bin/java Log file location : /u01/app/oracle/product/10.1.0/db_1/.patch_storage/<patch ID>/*.log Creating log file "/u01/app/oracle/product/10.1.0/db_1/.patch_storage/13343482/Apply_13343482_06-21-2017_12-58-36.log" Invoking fuser to check for active processes. Invoking fuser on "/u01/app/oracle/product/10.1.0/db_1/bin/oracle" Invoking fuser on "/u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr" Backing up comps.xml ... OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Please shut down Oracle instances running out of this ORACLE_HOME (Oracle Home = /u01/app/oracle/product/10.1.0/db_1) Is this system ready for updating? Please respond Y|N > y Executing the Apply pre-patch script (/media/sf_oracle/13343482/custom/scripts/pre)... Applying patch 13343482... Patching archive files... Patching jar files... Patching copy files... Creating new directory "/u01/app/oracle/product/10.1.0/db_1/cpu/CPUJan2012/MODPLSQL/owa_all/30" Creating new directory "/u01/app/oracle/product/10.1.0/db_1/cpu/CPUJan2012/MODPLSQL/owa_all/101" Creating new directory "/u01/app/oracle/product/10.1.0/db_1/cpu/CPUJan2012/MODPLSQL/owa_all/90" Creating new directory "/u01/app/oracle/product/10.1.0/db_1/cpu/scripts" Creating new directory "/u01/app/oracle/product/10.1.0/db_1/j2ee/OC4J_EM/applications/em/em/admin/rep" Creating new directory "/u01/app/oracle/product/10.1.0/db_1/cpu/view_recompile" Creating file to hold list of directories that were mkdir'ed: "/u01/app/oracle/product/10.1.0/db_1/.patch_storage/13343482/opatch_dirs_created.lst" Running make for target client_sharedlib. Running make for target ioracle. Running make for target iokinit. Running make for target ioklist. Running make for target iokdstry. Running make for target itnsping. Running make for target ilsnrctl. Running make for target itnslsnr. Running make for target iimp. Running make for target ictxload. Running make for target libnmemso. Inventory is good and does not have any dangling patches. Updating inventory... Verifying patch... Backing up comps.xml ... Executing the Apply post-patch script (/media/sf_oracle/13343482/custom/scripts/post)... OPatch succeeded.
oracle 유저로 패치 결과 확인
opatch lsinventory
[oracle@orcl ~]$ opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.61
Copyright (c) 2009 Oracle Corporation. All Rights Reserved..
Oracle recommends you to use the latest OPatch version
and read the OPatch documentation available in the OPatch/docs
directory for usage. For information about the latest OPatch and
other support-related issues, refer to document ID 293369.1
available on My Oracle Support (https://myoraclesupport.oracle.com)
Oracle Home : /u01/app/oracle/product/10.1.0/db_1
Oracle Home Inventory : /u01/app/oracle/product/10.1.0/db_1/inventory
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OUI location : /u01/app/oracle/product/10.1.0/db_1/oui
OUI shared library : /u01/app/oracle/product/10.1.0/db_1/oui/lib/linux/liboraInstaller.so
Java location : /u01/app/oracle/product/10.1.0/db_1/jre/1.4.2/bin/java
Log file location : /u01/app/oracle/product/10.1.0/db_1/.patch_storage/<patch ID>/*.log
Creating log file "/u01/app/oracle/product/10.1.0/db_1/.patch_storage/LsInventory__06-21-2017_13-22-33.log"
Result:
Installed Patch List:
=====================
1) Patch 13343482 applied on Wed Jun 21 13:14:06 KST 2017
Unique Patch ID: 14274679
[ Bug fixes: 5220448 6350565 6079585 5458753 9655023 4175906 5901912 6864078 4486132 5896963 11725035 6647005 5095815 4519477 5347751 4691191 4754900 5861360 8290534 5382595 5071931 6370967 5458543 6607951 5179574 4329444 5029950 5464895 5029952 5029954 5738539 5648727 5352587 5631915 4402808 4871035 6455161 5114396 5091108 5584790 4605877 4751932 5751672 5490845 10080564 6753516 8534394 3345756 5933477 7592360 5094098 10183338 5015557 5675556 4679094 5154689 12828135 5222931 5910829 5754150 5227879 4152843 4661844 6079603 5637094 7044603 6016022 4905112 8290629 4581220 4166537 7120513 5276400 7154097 7154098 5408664 5563256 6395024 4146291 6397568 6854919 12419228 9108675 5901877 4768040 5049074 7022400 5960451 5490935 5049077 4542188 4680009 4593539 4555795 12565867 5406923 4359124 5689908 5258410 4969005 3962946 3743912 5648102 9352208 5057964 8836540 3935623 5014128 4873311 4439469 4331689 6705965 4597251 4903532 6055387 9764906 7576788 5650178 5225797 4047969 4554284 5376215 4874628 5401921 5151518 4458415 4700543 7375686 5226235 4900129 5122955 5095648 4561867 5239126 5869471 4712638 5354517 4925103 4745776 5998987 4939157 6404864 4627335 7300525 5501362 4587572 4969029 9119261 6270140 5055442 7334756 6639839 4492467 5222032 5151675 5242647 6999528 6737308 7137797 6864202 4587431 5605370 6647068 9952279 6826532 4335559 5417371 4671216 5065930 9362645 4575854 6130365 5355257 7173149 5243019 6639553 4966417 5884075 4899479 4610820 3837600 5092688 4528572 4449900 4601861 6009358 4226736 6404447 13343482 4348230 8785236 5233111 5644862 4197970 ]
OPatch succeeded.
