설치된 oracle 패치 정보 리스트

오라클의 설치된 패치정보를 보는 명령어

내가 현재 있는 고객사의 DB가 설치된곳은 미국이다. 미국의 서버호스팅업체중 이름을 들으면 "아 거기~" 하는 업체가 있는데
하도 지랄스럽게 관리하여 현재 운영되는 DB와 신규로 이관한 DB의 패치정보도 직접봐야하는 상황이라서
해당 정보보는 방법을 찾아보고 메모한다.

 

$ opatch lsinventory -all
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /oracle/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /oracle/app/oraInventory
   from           : /oracle/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.4
OUI version       : 11.2.0.3.0
Log file location : /oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-10-14_14-31-39PM_1.log

Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-10-14_14-31-39PM.txt

--------------------------------------------------------------------------------
List of Oracle Homes:
  Name          Location
   OraDb11g_home1         /oracle/app/oracle/product/11.2.0/dbhome_1
   agent12c3         /oraagent/oracle/agent12g/core/12.1.0.3.0
   sbin12c3         /oraagent/oracle/agent12g/sbin
   OraHome11         /oraagent/oracle/agent12g/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.3.0
   OraHome12         /oraagent/oracle/agent12g/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.4.0
   OraHome13         /oraagent/oracle/agent12g/plugins/oracle.sysman.db.discovery.plugin_12.1.0.4.0
   OraHome14         /oraagent/oracle/agent12g/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.4.0
   OraHome15         /oraagent/oracle/agent12g/plugins/oracle.sysman.oh.agent.plugin_12.1.0.3.0
   agent12c2         /oraagent/oracle/agent12c/core/12.1.0.3.0
   OraHome6         /oraagent/oracle/agent12c/plugins/oracle.sysman.beacon.agent.plugin_12.1.0.3.0
   OraHome7         /oraagent/oracle/agent12c/plugins/oracle.sysman.csa.discovery.plugin_12.1.0.3.0
   OraHome8         /oraagent/oracle/agent12c/plugins/oracle.sysman.csa.agent.plugin_12.1.0.3.0
   OraHome9         /oraagent/oracle/agent12c/plugins/oracle.sysman.emrep.agent.plugin_12.1.0.3.0
   OraHome17         /oraagent/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.4.0
   OraHome21         /oraagent/oracle/agent12c/plugins/oracle.sysman.emas.agent.plugin_12.1.0.4.0
   agent12c1         /oracle/oracle/agent12c/core/12.1.0.3.0
   sbin12c11         /oracle/oracle/agent12c/sbin
   OraHome10         /oracle/oracle/agent12c/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.3.0
   OraHome16         /oracle/oracle/agent12c/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.4.0
   OraHome18         /oracle/oracle/agent12c/plugins/oracle.sysman.db.discovery.plugin_12.1.0.4.0
   OraHome19         /oracle/oracle/agent12c/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.4.0
   OraHome20         /oracle/oracle/agent12c/plugins/oracle.sysman.oh.agent.plugin_12.1.0.3.0
   oracle_sysman_db_12_1_0_4_0_agent_Home0         /oracle/oracle/agent12c/plugins/oracle.sysman.db.agent.plugin_12.1.0.4.0
   sbin12c4         /oraagent/oracle/agent12c/sbin
   OraHome1         /oraagent/oracle/agent12c/plugins/oracle.sysman.oh.discovery.plugin_12.1.0.3.0
   OraHome2         /oraagent/oracle/agent12c/plugins/oracle.sysman.xa.discovery.plugin_12.1.0.4.0
   OraHome3         /oraagent/oracle/agent12c/plugins/oracle.sysman.db.discovery.plugin_12.1.0.4.0
   OraHome4         /oraagent/oracle/agent12c/plugins/oracle.sysman.emas.discovery.plugin_12.1.0.4.0
   OraHome5         /oraagent/oracle/agent12c/plugins/oracle.sysman.oh.agent.plugin_12.1.0.3.0

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  16056266     : applied on Tue Jul 23 00:00:15 KST 2013
Unique Patch ID:  15962803
Patch description:  "Database Patch Set Update : 11.2.0.3.6 (16056266)"
   Created on 12 Mar 2013, 02:14:47 hrs PST8PDT
Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     13566938, 13593999, 10350832, 14138130, 12919564, 13561951, 13624984
     13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875
     14472647, 12880299, 14664355, 14409183, 12998795, 14469008, 13719081
     13492735, 13496884, 12857027, 14263036, 14263073, 13732226, 13742433
     16368108, 16314469, 12905058, 13742434, 12849688, 12950644, 13742435
     13464002, 13534412, 12879027, 13958038, 14613900, 12585543, 12535346
     12588744, 11877623, 13786142, 12847466, 13649031, 13981051, 12582664
     12797765, 14262913, 12923168, 13384182, 13612575, 13466801, 13484963
     14207163, 11063191, 13772618, 13070939, 12797420, 13041324, 16314467
     16314468, 12976376, 11708510, 13680405, 14589750, 13026410, 13742437
     13737746, 14644185, 13742438, 13326736, 13596521, 13001379, 16344871
     13099577, 9873405, 14275605, 13742436, 9858539, 14841812, 11715084
     16231699, 14040433, 12662040, 9703627, 12617123, 12845115, 12764337
     13354082, 14459552, 13397104, 13913630, 12964067, 12983611, 13550185
     13810393, 12780983, 12583611, 14546575, 13476583, 15862016, 11840910
     13903046, 15862017, 13572659, 16294378, 13718279, 14088346, 13657605
     13448206, 16314466, 14480676, 13419660, 13632717, 14063281, 14110275
     13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784
     13616375, 14035825, 12861463, 12834027, 15862021, 13632809, 13377816
     13036331, 14727310, 13685544, 15862018, 13499128, 16175381, 13584130
     12829021, 15862019, 12794305, 14546673, 12791981, 13787482, 13503598
     10133521, 12718090, 13399435, 14023636, 13860201, 12401111, 13257247
     13362079, 14176879, 12917230, 13923374, 14220725, 14480675, 13524899
     13559697, 9706792, 14480674, 13916709, 13098318, 13773133, 14076523
     13340388, 13366202, 13528551, 12894807, 13454210, 13343438, 12748240
     14205448, 13385346, 15853081, 14273397, 12971775, 13582702, 10242202
     13035804, 13544396, 16382353, 8547978, 14226599, 14062795, 13035360
     12693626, 13332439, 14038787, 14062796, 12913474, 14841409, 14390252
     16314470, 13370330, 13059165, 14062797, 14062794, 12959852, 13358781
     12345082, 12960925, 9659614, 13699124, 14546638, 13936424, 13338048
     12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684
     14062792, 13807411, 13250244, 12594032, 15862022, 9761357, 12612118
     13742464, 14052474, 13911821, 13457582, 13527323, 15862020, 13910420
     13502183, 12780098, 13705338, 13696216, 14841558, 10263668, 15862023
     16056266, 15862024, 13554409, 13645917, 13103913, 13011409, 14063280

 

--------------------------------------------------------------------------------

OPatch succeeded.
$