1. Patch Set Update
oracle 유저로 opatch 업데이트
cd $ORACLE_HOME OPatch/opatch version mv OPatch OPatch.old cp -r /media/oracle/OPatch . cp -r /media/oracle/OPatch .
[oracle@orcl ~]$ cd $ORACLE_HOME [oracle@orcl db_1]$ OPatch/opatch version Invoking OPatch 11.1.0.6.0 OPatch Version: 11.1.0.6.0 OPatch succeeded. [oracle@orcl db_1]$ mv OPatch OPatch.old [oracle@orcl db_1]$ cp -r /media/oracle/OPatch . [oracle@orcl db_1]$ OPatch/opatch version OPatch Version: 11.1.0.12.9 OPatch succeeded.
oracle 유저로 사전 조사
export PATH=$PATH:$ORACLE_HOME/OPatch:/usr/ccs/bin opatch lsinventory cd <패치 파일 압축 해제 경로> opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./20761024
[oracle@orcl ~]$ export PATH=$PATH:$ORACLE_HOME/OPatch:/usr/ccs/bin [oracle@orcl ~]$ opatch lsinventory Oracle Interim 패치 설치 프로그램 버전 11.1.0.12.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.1.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.1.0/db_1/oraInst.loc OPatch version : 11.1.0.12.9 OUI version : 11.1.0.7.0 Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2017-06-17_18-56-46오후_1.log Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-06-17_18-56-46오후.txt -------------------------------------------------------------------------------- 설치된 최상위 레벨 제품(2): Oracle Database 11g 11.1.0.6.0 Oracle Database 11g Patch Set 1 11.1.0.7.0 이 Oracle 홈에 2개의 제품이 설치되어 있습니다. 이 Oracle 홈에 설치된 Interim 패치가 없습니다. -------------------------------------------------------------------------------- OPatch succeeded. [oracle@orcl ~]$ cd /media/oracle [oracle@orcl oracle]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./20761024 Oracle Interim 패치 설치 프로그램 버전 11.1.0.12.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.1.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.1.0/db_1/oraInst.loc OPatch version : 11.1.0.12.9 OUI version : 11.1.0.7.0 Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2017-06-17_18-57-48오후_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
oracle 유저로 패치
cd 20761024 opatch apply
[oracle@orcl oracle]$ cd 20761024 [oracle@orcl 20761024]$ opatch apply Oracle Interim 패치 설치 프로그램 버전 11.1.0.12.9 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.1.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.1.0/db_1/oraInst.loc OPatch version : 11.1.0.12.9 OUI version : 11.1.0.7.0 Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/20761024_Jun_17_2017_18_59_14/apply2017-06-17_18-59-14오후_1.log Applying interim patch '20761024' to OH '/u01/app/oracle/product/11.1.0/db_1' Verifying environment and performing prerequisite checks... Patch 20761024: Optional component(s) missing : [ oracle.network.cman, 11.1.0.7.0 ] , [ oracle.rdbms.dv.oc4j, 11.1.0.7.0 ] , [ oracle.rdbms.dv, 11.1.0.7.0 ] All checks passed. 보안 문제에 대한 알림을 받을 전자 메일 주소를 제공하고 Oracle Configuration Manager를 설치하여 시작하십시오. My Oracle Support 전자 메일 주소/사용자 이름을 사용할 경우 보다 간편하게 작업을 진행할 수 있습니다. 자세한 내용을 확인하려면 http://www.oracle.com/support/policies.html을 방문하십시오. 전자 메일 주소/사용자 이름: 보안 문제에 대한 알림을 받을 전자 메일 주소를 제공하지 않았습니다. 보안 문제에 대한 알림을 받지 않겠습니까(예[Y], 아니오[N]) [N]: Y 로컬 시스템의 이 ORACLE_HOME에서 실행 중인 Oracle 인스턴스를 종료하십시오. (Oracle 홈 = '/u01/app/oracle/product/11.1.0/db_1') 로컬 시스템이 패치할 준비가 되었습니까? [y|n] y User Responded with: Y Backing up files... oracle.network.listener, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.network.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms.rman, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.sdo.locator, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.sysman.console.db, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.sysman.repository.core, 10.2.0.4.1 구성 요소를 패치하는 중... oracle.sysman.oms.core, 10.2.0.4.1 구성 요소를 패치하는 중... oracle.sysman.console.db, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms.dbscripts, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.javavm.server, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.precomp.common, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.oraolap, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.xdk.parser.java, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.xdk, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.xdk.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ldap.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ldap.rsf.ic, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ctx, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.rdbms.util, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.network.rsf, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.network.client, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ordim.jai, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ordim.client, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.dbjava.ic, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.dbjava.jdbc, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ovm, 11.1.0.7.0 구성 요소를 패치하는 중... oracle.ordim.server, 11.1.0.7.0 구성 요소를 패치하는 중... Verifying the update... Patch 20761024 successfully applied Log file location: /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/20761024_Jun_17_2017_18_59_14/apply2017-06-17_18-59-14오후_1.log OPatch succeeded.
oracle 유저로 패치 결과 확인
opatch lsinventory
[oracle@orcl ~]$ opatch lsinventory
Oracle Interim 패치 설치 프로그램 버전 11.1.0.12.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.1.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.1.0/db_1/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.7.0
Log file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/opatch2017-06-17_19-01-43오후_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-06-17_19-01-43오후.txt
--------------------------------------------------------------------------------
설치된 최상위 레벨 제품(2):
Oracle Database 11g 11.1.0.6.0
Oracle Database 11g Patch Set 1 11.1.0.7.0
이 Oracle 홈에 2개의 제품이 설치되어 있습니다.
Interim 패치(1):
Patch 20761024 : applied on Sat Jun 17 19:00:44 KST 2017
Unique Patch ID: 19021586
Created on 11 Jun 2015, 00:40:36 hrs PST8PDT
Bugs fixed:
9068088, 16946580, 16946581, 16946582, 16946583, 7207654, 8865718
7835247, 7648406, 9054253, 6851110, 7206858, 9744252, 7497788, 9956713
14275623, 8251486, 12984377, 6434104, 8851675, 7502237, 8211920, 9352179
7013124, 7643188, 7135702, 7529174, 20299012, 7196532, 8300793, 9049725
7705669, 16867278, 7119382, 9001453, 19274522, 20331945, 7424804, 7408621
7426336, 20074391, 8856696, 6843972, 10264680, 14841452, 8437213, 7028779
8836375, 8216875, 7527650, 20299020, 7454752, 8290478, 9499302, 7412296
6805009, 8318050, 13621679, 7185113, 7639602, 8539335, 9711859, 15890514
9011088, 15890515, 15890516, 14390384, 15890517, 7131291, 15890518
9109536, 12780098, 15890519, 13561951, 8199266, 9114072, 8230457, 17721717
7420394, 8914979, 9713537, 14459552, 19458377, 8876094, 15890520, 15890521
7348847, 9311909, 8408887, 15890522, 7183523, 7441663, 7329252, 8622613
16308394, 10249534, 7719668, 8577450, 9458811, 8534338, 9272086, 8339404
8517426, 9458814, 9458816, 7384419, 7690421, 9458819, 12565867, 19414539
8419383, 14023636, 7447559, 8247855, 8394351, 20510936, 20510937
6772911, 20510938, 7175513, 7417614, 9143376, 8243648, 13490818, 8367827
8365141, 8761101, 7350127, 8462173, 9027691, 11724999, 9485429, 19414540
19414541, 7572069, 14841558, 9458829, 8825048, 8328853, 7585314, 8341623
8409848, 10358019, 6988517, 8860821, 9830111, 8306933, 8306934, 16306019
9166322, 6840740, 12828097, 18242494, 9563951, 18242495, 18242496
9458831, 6981690, 8304329, 8281906, 7480809, 8339352, 7340448, 7393258
10165083, 19854433, 6599920, 7630416, 8342506, 8717461, 19769499, 6407486
7416901, 7281382, 8599477, 7475055, 8217795, 8982191, 8362693, 12687462
9702142, 7436152, 7680907, 9702143, 8481935, 7657365, 7345543, 10046072
7670135, 10187168, 10648873, 7708340, 8499043, 12419265, 14258925
8224083, 6983384, 7385253, 7225720, 8354686, 8399549, 9118620, 6856345
9118622, 9209238, 9311954, 16359931, 7484102, 16359932, 7661251, 13813945
8771916, 6991626, 5552232, 14488890, 14488891, 9229631, 14488892, 7022234
7462112, 8248911, 13358127, 7296258, 13737031, 9369783, 13737032
13737033, 19309466, 13737034, 13737035, 13737036, 13737037, 6812439
13737038, 13737039, 6870937, 7828187, 18009564, 20004021, 7263842
8287680, 8870559, 9488887, 17716305, 13503598, 8990527, 9242411, 9448311
7500792, 8352304, 13737040, 13737041, 8352309, 13737042, 13737043
8565359, 8324760, 7019313, 8775066, 8686128, 14145193, 7486595, 7643632
9032717, 8658581, 7499911, 6734871, 7411865, 10094989, 7111196, 16450169
7276960, 8890026, 8360192, 16872333, 7522002, 7613481, 12748240, 7452373
9267837, 14586023, 8763922, 10399808, 6770443, 18838136, 18838137
17019974, 7334226, 11856395, 19699191, 8284438, 13015379, 19554106
8232287, 7318049, 8214576, 9021155, 6679303, 8815639, 8740993, 7516536
7675269, 8244734, 13343453, 8490879, 7646055, 8268330, 9255542, 8496830
9095091, 12419384, 6647480, 9473270, 8416414, 6858062, 7189645, 8476517
7497251, 7436280, 5970301, 13343461, 9363145, 19827973, 9312879, 7506785
16382448, 13791364, 6977167, 10426994, 6445948, 5929055, 7298982, 8348464
6522654, 8737065, 9774756, 8833297, 6016633, 7606362, 8332021, 9188470
8502963, 14141300, 12710774, 14141301, 8285404, 8391256, 9399991, 13630102
9776431, 6798427, 11829892, 7138523, 6971433, 7829321, 19289642, 18681875
7311601, 8433270, 11829897, 8563941, 8563942, 8563943, 8563944, 8563945
8563946, 7345904, 8563947, 12827740, 8563948, 17352830, 12899066
17352831, 17352832, 6870994, 17352833, 14038803, 17352834, 7523787
9135679, 17352835, 16721594, 8528171, 7697360, 9210925, 7378322, 13596521
17088068, 20004087, 8348481, 9081430, 8974548, 7331867, 18443839
17841015, 17841016, 17841017, 17841018, 19915271, 17841019, 7273819
16619896, 7254221, 7036284, 8847439, 7515779, 13632731, 9434549, 8402548
9637033, 8608377, 7510766, 8364676, 9066130, 7628387, 7553884, 14121009
7694979, 8565708, 8813142, 6972189, 17841021, 7682745, 10209232, 6598432
6768362, 6501490, 9841005, 20803573, 9672816, 7719143, 8402551, 16710324
7484261, 8402555, 7719148, 8284633, 10009222, 7307821, 8613137, 7650993
9714832, 8940197, 6970731, 12560400, 10009229, 7589862, 12560402, 9170608
8263441, 14273397, 12560404, 12560405, 7586451, 6709070, 7446163, 7460818
6618461, 7451927, 7373196, 16703112, 7336031, 8413059, 20994144, 7338648
9399090, 8402562, 13504767, 8402637, 7393804, 7190092, 6196748, 7627743
8834425, 16212405, 8531282, 18096714, 18436647, 16338983, 9145541
10411618, 7720494, 19006849, 13000884, 8645846, 8539923, 8236851, 7602341
7036453, 7610362, 8855553, 16462834, 18641419, 8855559, 8543737, 10336518
10009241, 7626014, 9654987, 20126847, 20126848, 10009173, 10009246
8649055, 7341598, 7706138, 7292503, 6797677, 8603465, 17082366, 8946311
8342923, 8549480, 7356443, 7593835, 19152553, 8483871, 20296213, 8242410
7044551, 7639121, 9275072, 8855565, 9795214, 7253531, 10336525, 20126850
20126851, 6851669, 16742110, 14205448, 7318276, 8257122, 14141297
7013817, 14141298, 14141299, 7309458, 8450529, 17082374, 11807302
13923474, 16279211, 8855570, 8499600, 8501439, 8588540, 8855575, 8790767
7652915, 7426959, 8855577, 16710363, 13554409, 6980601, 9857702, 17865671
6452375, 16056268, 8607693, 7653579, 9341448, 7535429, 13353523, 8582594
12560374, 16864562, 14546638, 7409110, 18139703, 7432514, 9655014
9581240, 8764031, 9689310, 7332001, 8240762, 7707103, 9084111, 9007102
10336548, 7013835, 16362358, 17465583, 12564597, 8361398, 6784747
7524944, 6780602, 7496908, 7662620, 12880299, 12560385, 14546575
12560386, 10127716, 9189647, 12560459, 18641451, 7417140, 6941717
7122161, 8668823, 19211724, 8898852, 21025013, 7377810, 7477246, 8363210
21025014, 21025015, 6798650, 7299153, 21025016, 8213302, 12796518
8909984, 8755082, 14739378, 8702276, 14263036, 14469008, 7497640, 12560461
7630874, 12560390, 12560464, 7133740, 9368549, 7311909, 7614692, 9703463
12560393, 7432601, 18031726, 8650719, 7213937, 7352414, 18641461
7516867, 12560398, 8199107, 16372203, 7662491, 12371955, 8856478, 10336560
7041254, 9549042, 10336565, 14671238, 18522513, 7219752, 17551415
9952228, 6900214, 8981059, 6882739, 11807271, 8546332, 8813366, 8296070
11807278, 7508788, 12531263, 7538000, 18673304, 9165206, 7242222, 8834636
7652888, 10336577, 7330434, 7113299, 7307972, 8592394, 8487273, 8660422
7462709, 14546673, 16279401, 8650661, 11807283, 8244217, 11699057
7515145, 13483152, 7202451, 7432556, 10019218, 7022905, 8674263, 8221425
7694273, 8211733, 9074535, 9188010, 7438445, 16344758, 9197917, 11807291
11807293, 8803762, 7494333, 7834195, 8250643, 11807297, 7298601, 13561750
8277580, 7172752, 7326645, 7171015, 7715244, 18673325, 7461921, 9241202
14263073, 6980597, 7499353, 8301559, 9532911, 7357609, 7462589, 8768374
7610592, 10248531, 7830065, 7203349, 8702535, 8669679, 9768907, 8268775
6955744, 7366290, 9952269, 8433693, 18093615, 7702085, 10145558, 8570572
7185872, 11724936, 8625762, 6059178, 7257038, 7336280, 6690853, 9744092
8595043, 8542307, 8578132, 20761024, 7330611, 8226397, 18673342, 7628866
16610144, 7278231, 20558005, 10324526, 6903819, 7676737, 9620202, 9231605
8636407, 16946578, 8782971, 16946579, 7258928, 9264021, 10169304, 7511040
7434194, 8315482, 8369094, 12984367, 12984369, 7716219, 14035825, 9246245
7556778, 8220734, 7597354, 13916709, 7710260
--------------------------------------------------------------------------------
OPatch succeeded.
