버전 비교

이전 버전 1

changes.mady.by.user 윤병훈

에 저장

비교대상

새 버전 2

changes.mady.by.user 윤병훈

에 저장

키

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.
코드 블럭
languagebash
titleoracle 유저로 opatch 업데이트
linenumberstrue
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.

 

코드 블럭
languagebash
titleoracle 유저로 사전 조사
linenumberstrue
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.

 

 

 

코드 블럭
languagebash
titleoracle 유저로 패치
linenumberstrue
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.

 

코드 블럭
languagebash
titleoracle 유저로 패치 결과 확인
linenumberstrue
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.