View and manage Oraclepatch

Oracle patch is also an Oracle patch. Oracle patches also contain several kinds, small patches are simply difficult to count, it is inevitable to dazzle people. However, Oracle patch is still in order. And Oracle's Opatch tools are handy for installing Oracle patch and viewing the patch that the current system has installed. This article lists several types of patch and describes the patch application of the current database through the Opatch tool. Refer to the official Oracle documentation for how to apply patch.

1. Oracle Patch Type

Critical Patch Update (CPU)

Bundled patches (for Windows and Exadata only)

PSR (Patch set release)/patch set Update (PSU)

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30-31 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 The 96 97 98 99 100 101 102 103 104 105 106 107 108 109 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140-1 41 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170-171 172

Oracle provides us with tools for patch installation, fallback, management, and tracking Opatch, which is a command-line tool that is easy to use and can be used to get help information based on Opatch help commands #获得opatch的帮助信息 [oracle@linux1 opatch]$./opatch-help invoking Opatch 11.1.0.6.6   #opatch的版本   Oracle Interim Patch-Installer version 11 .1.0.6.6 Copyright (c) 2009, Oracle corporation.  All rights reserved.    usage:opatch [-help] [-r[eport]] [command]           &NBS P;   command: = apply          #安装patch                          lsinventory    #查看所有已安装的patch                         napply          #用于Apply A set of patches at a time                         nrollback       #用于Rollback A set of patches at a time            & nbsp;           rollback        #Rollback A existing one-off patch indicated by the Reference-id                         query                                   version                          prereq         #用于检查安装patch之前的先决条件      & nbsp;                  util    <global_arguments>: =-help       Displays the help message for the Command.                         -report     Print the actions without executing.  example:                              #可以通过下面的方式来查看每一个具体命令的用法      ' opatch-help '     ' opatch apply-help '               ' Opatch lsinventory-help '         ' opatch napply-help '               ' opatch nrollback-help '     ' Opatch RollbaCk-help '     ' opatch prereq-help '     ' opatch util-help '     opatch Succeeded.   #下面查看oracle The patch information under 10g, for how to install the patch, this article does not make a demo oracle@m10db01p:/users/oracle/orahome10g/opatch>./opatch Lsinventory invoking Opatch 10.2.0.3.0    &nbsp ..... Oracle home      :/users/oracle/orahome10g Inventory:/users/oracle/ Orainventory    from          :/etc/ Orainst.loc opatch version   : 10.2.0.3.0 OUI version      : 10.2.0.3.0 OUI location     :/users/oracle/orahome10g/oui Log file Location:/users/oracle/orahome10g /cfgtoollogs/opatch/opatch2013-12-19_09-54-27am.log   lsinventory Output file location:/users/oracle/ Orahome10g/cfgtoollogs/opatch/lsinv/lsinventory2013-12-19_09-54-27am.txt  -------------------------------- ------------------------------------------------installed top-level products (2):   Oracle Database 10g                                                     10.2.0.1.0 #基础版本号 Oracle Database 10g Release 2 Patch Set 2                              10.2.0.3.0 #PSR号为3 There are 2 products installed at this Oracle home.     Interim Patches (2):                                                  #列出了2个临时补丁paTCH number and bug number   patch  5556081     : Applied on Wed Feb-11:16:15 HKT nbsp Created on 9 Nov 2006, 22:20:50 hrs PST8PDT    bugs fixed:      5556081   Pat ch  5557962     : Applied on Wed Feb-11:16:08 HKT-   created on 9 No V 2006, 23:23:06 hrs PST8PDT    bugs fixed:      4269423, 5557962, 5528974----- ---------------------------------------------------------------------------Opatch succeeded.   #也可以通过查询dba_server_registry查看当前数据补丁的使用情况 sql> Select comp_name,version from Dba_server_registry;   comp_name                                            VERSION--------------------------------------------------------------------------------Oracle XML database                                  10.2.0.3.0 Oracle Label security                                10.2.0.3.0 Oracle Expression filter                            10.2.0.3.0 Oracle Rules manager                                10.2.0.3.0 Oracle Workspace manager                            10.2.0.1.0 Oracle Database Catalog views                       10.2.0.3.0 Oracle Database Packages and types                  10.2.0.3.0 jserver JAVA Virtual machine                        10.2.0.3.0 Oracle XDK                                            10.2.0.3.0 Oracle Database Java packages                       10.2.0.3.0   Ten rows selected.  #下面是Oracle the application of patch in the use of lsinventory-detail under 11g [oracle@linux1 opatch]$./opatch Lsinventory-detail Invoking Opatch 11.1.0.6.6   Oracle Interim Patch Installer version 11.1.0.6.6 Copyright (c) 2009, Oracle corporation.  A ll rights reserved.                ......... (omitted)--------------------------------------------------------------------------------installed top-level products (1):   Oracle Database 11g                                                    11.2.0.1.0 There are 1 products installed at this Oracle home.   Installed Products (134):   Agent Required Support files        & Nbsp;                                 10.2.0.4.2 Assistant Common files                                                  11.2.0.1.0 Bali share                                                              1.1.18.0.0 Buildtools Common files                                                11.2.0.1.0 Character Set Migration utility                                        11.2.0.1.0 Cluster Verification Utility Common files                             11.2.0.1.0 Database Configuration and Upgrade assistants                         11.2.0.1.0                  ......... Omitted SSL Required Support Files for Instantclient                          11.2.0.1.0 Sun jdk                                                                 1.5.0.17.0 XDK Required Support files                                             11.2.0.1.0 XML Parser for java                                                     11.2.0.1.0 XML Parser for Oracle jvm                                              11.2.0.1.0 There are 134 products installed at this Oracle home.   Interim Patches (1):   patch  8670579     : Applied on Thu Aug-CST 2013 Unique Patch id:  12243614    created on Feb/09:55:12 hrs us/eastern     Bugs fixed:      8670579    files touched:        #这里列出了相应的文件      /ahseteco.o--> oracle_home/lib/libnnz11.a       /AM11RKG.O-->oracle_home/lib/libnnz11.a      /AMSHA.O--> oracle_home/lib/libnnz11.a       /CPUI32.O--> oracle_home/lib/libnnz11.a      /sha.o--> ORACLE_ home/lib/libnnz11.a      /x931rand.o--> oracle_home/lib/libnnz11.a       /AM11DKG.O--> oracle_home/lib/libnnz11.a      /am931rnd.o--> ORACLE_ home/lib/libnnz11.a      /amsharnd.o--> oracle_home/lib/libnnz11.a       /GHASH.O--> oracle_home/lib/libnnz11.a      /shacomm.o--> ORACLE_HOME/ lib/libnnz11.a      libnnz11.so--> oracle_home/lib/libnnz11.so     Patch Location in Inventory:      /u01/app/oracle/db_1/inventory/oneoffs/8670579     patch Location in Storage area:      /U01/APP/ORACLE/DB_1/.PAtch_storage/8670579_feb_25_2010_09_55_12   RAC system comprising of multiple nodes   #列出了当前环境的节点    local node = linux1   remote node = linux2----------------------------------------------------------- ---------------------Opatch succeeded.   #下面是Oracle 11g using lsinventory-bugs_fixed to view patch [Oracle@linux1 opatch]$ ./opatch lsinventory-bugs_ Fixed invoking Opatch 11.1.0.6.6               ............... (omitted)------------------------------------------------------------------------------------------------------ Installed top-level products (1):   Oracle Database 11g                                                     11.2.0.1.0 There are 1 products installed at this Oracle home.   List of Bugs fixed by installed patches:   bug        fixed by  instal LED at                    Description             Patch                                                ---       -------- --------- ---                   -----------  #下面给出了和bug有关的具体描述   8670579    8670579   Thu Aug 17:53:20 CST 2 013   DBBETA:NETCA/DBCA FAILED with HOTSPOT VirtuAL MACHINE   RAC system comprising of multiple nodes   local node = linux1   remote node = linux2 ------------------------------------------------------------------------------------------------------Opatch Succeeded.