oracle11g安装补丁升级

时间:2022-10-30 08:31:48

检查当前数据库CPU和PSU补丁信息

方法一:

登录数据库,检查DBA_REGISTRY_HIST视图。

SYS@orcl> select *from dba_registry_history;

 

ACTION_TIME                 ACTION                               NAMESPACE  VERSION    ID BUNDLE_SERIES

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

COMMENTS

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

2013-08-24 12:03:45.119862     APPLY                               SERVER         11.2.0.4      0 PSU

Patchset 11.2.0.2.0

 

2015-07-24 17:37:04.622489     APPLY                               SERVER         11.2.0.4      0 PSU

Patchset 11.2.0.2.0

 

方法二:

通过opatch lsinventory方式。

$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory

 

查看opatch版本信息

[oracle@OCP ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.4

 

OPatch succeeded.

升级前关闭数据库和监听。

 

上传PSU11.2.0.4.5补丁包并解压

本例是将补丁包复制到/u01/app/oracle/patchPakge下

用unzip进行解压

[oracle@OCP patchPakge]$ unzip p19769489_112040_Linux-x86-64.zip

进入解压目录进行安装

安装补丁

[oracle@OCP patchPakge]$ cd 19769489/

[oracle@OCP 19769489]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.4

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-08-16PM_1.log

 

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckMinimumOPatchVersion" failed.

The details are:

 

 

The OPatch being used has version 11.2.0.3.4 while the following patch(es) require higher versions:

Patch 17478514 requires OPatch version 11.2.0.3.5.

Patch 18031668 requires OPatch version 11.2.0.3.5.

Patch 18522509 requires OPatch version 11.2.0.3.5.

Patch 19121551 requires OPatch version 11.2.0.3.5.

Patch 19769489 requires OPatch version 11.2.0.3.5.

Please download latest OPatch from My Oracle Support.

 

UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-08-16PM_1.log

 

OPatch failed with error code 73

 

2、OPatch应用报错,检查日志

[oracle@OCP19769489]$cat u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-08-16PM_1.log

[Jul 24, 2015 8:08:26 PM]    Prerequisite check "CheckMinimumOPatchVersion" failed.

                             The details are:

[Jul 24, 2015 8:08:26 PM]    OUI-67073:UtilSession failed: Prerequisite check "CheckMinimumOPatchVersion" failed.

[Jul 24, 2015 8:08:26 PM]    Stack Description: java.lang.RuntimeException: Prerequisite check "CheckMinimumOPatchVersion" failed.

显示opatch版本有问题,先更新opatch版本。

 

 

下载p6880880,并解压缩

[oracle@OCP patchPakge]$ unzip p6880880_112000_Linux-x86-64.zip

[oracle@OCP patchPakge]$ rm -rf /u01/app/oracle/product/11.2.0/db_1/OPatch

[oracle@OCP patchPakge]$  cp -r OPatch/ /u01/app/oracle/product/11.2.0/db_1/

[oracle@OCP patchPakge]$  /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.6

 

OPatch succeeded.

更新成功。

通过新版本Opatch安装PSU

[oracle@OCP 19769489]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.6

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-23-44PM_1.log

 

Verifying environment and performing prerequisite checks...

Prerequisite check "CheckActiveFilesAndExecutables" failed.

The details are:

 

 

Following executables are active :

/u01/app/oracle/product/11.2.0/db_1/bin/oracle

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-23-44PM_1.log

 

OPatch failed with error code 73

 

通过报错提示“Check Active Files And Executables”可能是有些执行程序用到了/u01/app/oracle/product/11.2.0/db_1/lib/目录下的库文件libclntsh.so.11.1和/u01/app/oracle/product/11.2.0/db_1/bin/下的oracle。

 

用fuser查看是谁在用这些文件并kill这些进程。

[oracle@OCP 19769489]$ fuser /u01/app/oracle/product/11.2.0/db_1/bin/oracle

/u01/app/oracle/product/11.2.0/db_1/bin/oracle:  3221e

[oracle@OCP 19769489]$ fuser /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1

/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1:  3174m

[oracle@OCP 19769489]$ kill -9 3221 3174

重新执行安装opatch

[oracle@OCP 19769489]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.6

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-30-44PM_1.log

 

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489 

 

Do you want to proceed? [y|n]

y    

User Responded with: Y

All checks passed.

…………………….

 

Composite patch 19769489 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-30-44PM_1.log

 

OPatch completed with warnings.

检查Opatch是否已经完成

[oracle@OCP 19769489]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

 

 

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc

OPatch version    : 11.2.0.3.6

OUI version       : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-07-24_20-40-00PM_1.log

 

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-07-24_20-40-00PM.txt

 

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

Installed Top-level Products (1):

 

Oracle Database 11g                                                  11.2.0.4.0

There are 1 product(s) installed in this Oracle Home.

 

 

Interim patches (1) :

 

Patch  19769489     : applied on Fri Jul 24 20:36:26 CST 2015

Unique Patch ID:  18236413

Patch description:  "Database Patch Set Update : 11.2.0.4.5 (19769489)"

   Created on 28 Dec 2014, 21:22:44 hrs PST8PDT

Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"

Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"

Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"

Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"

   Bugs fixed:

     17288409, 18273830, 17811429, 17205719, 19972566, 17922254, 17754782

     17726838, 16934803, 13364795, 17311728, 17441661, 17284817, 13645875

     16992075, 18199537, 16542886, 17446237, 14565184, 19972569, 17071721

     17610798, 17449815, 17375354, 17397545, 19463897, 18230522, 13866822

     16360112, 17982555, 17235750, 19769489, 17478514, 12905058, 18235390

     14338435, 13944971, 18641451, 20142975, 16929165, 12747740, 17546973

     14054676, 17088068, 18264060, 17042658, 17343514, 17016369, 14602788

     19972568, 19680952, 18471685, 18508861, 14657740, 17332800, 19211724

     13951456, 16315398, 19972564, 18744139, 17186905, 16850630, 18315328

     17437634, 19049453, 18673304, 17883081, 19006849, 18641419, 17296856

     18674024, 18262334, 17006183, 18277454, 16833527, 17232014, 16855292

     10136473, 17705023, 17865671, 18554871, 19121551, 18334586, 19854503

     19309466, 17551709, 17588480, 19827973, 17842825, 17344412, 18828868

     18681862, 18554763, 17390160, 17025461, 13955826, 11883252, 13609098

     18139690, 17501491, 17239687, 17299889, 17752121, 17602269, 19197175

     18673325, 17313525, 18293054, 17242746, 19544839, 18964939, 17600719

     18191164, 17571306, 18482502, 19466309, 17951233, 18094246, 19615136

     17165204, 17011832, 17040527, 18098207, 16785708, 17477958, 17174582

     16180763, 17465741, 16777840, 18522509, 17323222, 19463893, 16595641

     12816846, 16875449, 16524926, 17237521, 18228645, 18282562, 17596908

     17811438, 17811447, 18031668, 17184721, 16494615, 16912439, 18061914

     17282229, 17545847, 18202441, 17082359, 19554106, 17614134, 13558557

     17341326, 14034426, 17891946, 18339044, 19458377, 17716305, 17752995

     16392068, 19271443, 17891943, 18092127, 17258090, 17767676, 17614227

     17040764, 14106803, 17381384, 15913355, 18973907, 18356166, 18673342

     14084247, 17389192, 17612828, 17006570, 13853126, 17721717, 17570240

     18203837, 17390431, 14245531, 16043574, 16863422, 19727057, 17468141

     17786518, 17912217, 16422541, 19972570, 17037130, 17267114, 18244962

     18203838, 16198143, 16956380, 17478145, 14829250, 17394950, 18189036

     18641461, 17835627, 17027426, 16268425, 18247991, 14458214, 19584068

     18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673

     16314254, 17443671, 16228604, 16837842, 17571039, 17393683, 16344544

     17787259, 18009564, 20074391, 14354737, 15861775, 18135678, 18614015

     16399083, 18018515, 17835048, 16472716, 17936109, 17050888, 17325413

     14010183, 18747196, 17036973, 16613964, 17080436, 17761775, 16721594

     18280813, 17302277, 16901385, 15979965, 15990359, 18203835, 17297939

     17811456, 16731148, 17215560, 14133975, 17385178, 17586955, 18441944

     16450169, 17655634, 9756271, 19730508, 17892268, 17648596, 16220077

     16069901, 11733603, 16285691, 17587063, 16538760, 18180390, 17393915

     17274537, 18096714, 17308789, 17238511, 18436647, 17824637, 14285317

     19289642, 14764829, 18328509, 17622427, 16943711, 18306996, 17346671

     18996843, 14852021, 17783588, 16618694, 18674047, 17672719, 12364061

     17851160, 17546761

 

 

 

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

 

OPatch succeeded.

结果显示安装成功。

 

更新dba_registry_history视图为最新PSU信息

 

SQL>startup 

SQL> !lsnrctl start 

SQL> alter system register; 

SQL> @?/rdbms/admin/catbundle.sql psu apply

 

查看更新后的视图信息

SYS@orcl> select * from dba_registry_history;

 

ACTION_TIME                    ACTION NAMESPACE  VERSION            ID BUNDLE_SERIES   COMMENTS

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

2013-08-24 12:03:45.119862     APPLY  SERVER     11.2.0.4            0 PSU             Patchset 11.2.0.2.0

2015-07-24 17:37:04.622489     APPLY  SERVER     11.2.0.4            0 PSU             Patchset 11.2.0.2.0

2015-07-24 20:52:13.592073     APPLY  SERVER     11.2.0.4            5 PSU             PSU 11.2.0.4.5

 

3 rows selected.

 

SYS@orcl> select action,comments from registry$history;

 

ACTION COMMENTS

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

APPLY  Patchset 11.2.0.2.0

APPLY  Patchset 11.2.0.2.0

APPLY  PSU 11.2.0.4.5

 

3 rows selected

显示安装成功,成功从11.2.0.2.0升级到11.2.0.4.5