首页 > 数据库 > Oracle > 正文

查看及管理Oraclepatch

2019-11-02 15:54:34
字体:
来源:转载
供稿:网友

 Oracle patch也即是Oracle补丁。Oracle补丁又包含好几个种类,小的补丁简直是难以数计,难免让人眼花缭乱。尽管如此,Oracle patch还是有序可循的。而且Oracle提供的opatch工具非常方便的用于安装oracle patch,以及查看当前系统已经安装的patch。本文列出了patch的几种类型,以及主要描述通过opatch工具查看当前数据库的patch应用的情况。对于如何apply patch可参考Oracle官方文档。

1、Oracle patch类型

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 32 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 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 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 141 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 为我们提供了用于patch安装、回退、管理与追踪的工具opatch,该工具为命令行工具,简单易用,可以根据opatch的帮助命令来获取帮助信息 #获得opatch的帮助信息 [[email protected] 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 ]               command := apply          #安装patch                        lsinventory    #查看所有已安装的patch                        napply         #用于Apply a set of patches at a time                        nrollback      #用于Rollback a set of patches at a time                        rollback       #Rollback an existing one-off patch indicated by the reference-id                        query                                 version                        prereq         #用于检查安装patch之前的先决条件                        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 10g下的补丁信息,对于如何安装补丁,本文不作演示 [email protected]:/users/oracle/OraHome10g/OPatch> ./opatch lsinventory Invoking OPatch 10.2.0.3.0     ......... Oracle Home       : /users/oracle/OraHome10g Central 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 in this Oracle Home.     Interim patches (2) :                                                #列出了2个临时补丁patch号及bug号   Patch  5556081      : applied on Wed Feb 15 11:16:15 HKT 2012    Created on 9 Nov 2006, 22:20:50 hrs PST8PDT    Bugs fixed:      5556081   Patch  5557962      : applied on Wed Feb 15 11:16:08 HKT 2012    Created on 9 Nov 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
发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表