单实例patch 11.2.0.4.0->11.2.0.4.2

最新推荐文章于 2023-05-11 22:11:04 发布

達爾蓋的旗幟

最新推荐文章于 2023-05-11 22:11:04 发布

阅读量1.2k

点赞数

分类专栏： oracle常用

本文链接：https://blog.csdn.net/wuxbeyond/article/details/30041065

版权

oracle常用专栏收录该内容

39 篇文章 0 订阅

订阅专栏

这只是个人记录，自己根据自己的环境下载相应的PSU，更详细的步骤可以参考PSU里的readme.html

1：下载OPatch utility version 11.2.0.3.6 解压到$ORACLE_HOME
[oracle@primary OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.6
OPatch succeeded.

2: 添加opatch环境变量
vi /home/oracle/.bash_profile
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

3:解压psu,执行安装检查
[oracle@primary tmp]$ ll p18031668_112040_Linux-x86-64_psu.zip
-rw-r--r-- 1 oracle oinstall 16941425 May 8 10:44 p18031668_112040_Linux-x86-64_psu.zip
[oracle@primary tmp]$ unzip p18031668_112040_Linux-x86-64_psu.zip

[oracle@primary tmp]$ cd 18031668/
[oracle@primary 18031668]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11g
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11g/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11g/cfgtoollogs/opatch/opatch2014-06-11_03-06-

54AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

4：shut down all instances and listeners 安装psu

[oracle@primary tmp]$ cd 18031668/
[oracle@primary 18031668]$ opatch apply

[oracle@primary tmp]$ cd 18031668/
[oracle@primary 18031668]$ 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/11g
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11g/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11g/cfgtoollogs/opatch/opatch2014-06-11_03-10-08AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: 

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y^H



Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11g')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11g'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.sdo, 11.2.0.4.0...

Patching component oracle.sysman.agent, 10.2.0.4.5...

Patching component oracle.xdk, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.sdo.locator, 11.2.0.4.0...

Patching component oracle.nlsrtl.rsf, 11.2.0.4.0...

Patching component oracle.xdk.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Verifying the update...
Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11g'

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.rsf, 11.2.0.4.0...

Patching component oracle.ldap.rsf, 11.2.0.4.0...

Patching component oracle.rdbms.crs, 11.2.0.4.0...

Patching component oracle.precomp.common, 11.2.0.4.0...

Patching component oracle.ldap.rsf.ic, 11.2.0.4.0...

Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Patching component oracle.rdbms.rman, 11.2.0.4.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/u01/app/oracle/product/11g/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11g/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'


Composite patch 18031668 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11g/cfgtoollogs/opatch/opatch2014-06-11_03-10-08AM_1.log

OPatch completed with warnings.

有2个警告，查了说明
Warnings may be returned during the re-link phase of 18031668. These warnings may be ignored.
warning: overriding commands for target `nmosudo'
warning: ignoring old commands for target `nmosudo'

5：执行脚本

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

 Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
 catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

6：补丁升级检查

select * from dba_registry_history;

或者

[oracle@primary 11g]$ 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/11g
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11g/oraInst.loc
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11g/cfgtoollogs/opatch/opatch2014-06-11_03-30-26AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11g/cfgtoollogs/opatch/lsinv/lsinventory2014-06-11_03-30-26AM.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  18031668     : applied on Wed Jun 11 03:12:47 CST 2014
Unique Patch ID:  17255543
Patch description:  "Database Patch Set Update : 11.2.0.4.2 (18031668)"
   Created on 20 Feb 2014, 05:15:58 hrs PST8PDT
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
   Bugs fixed:
     17288409, 16399083, 17205719, 17811429, 10136473, 16472716, 17614227
     17050888, 17040764, 17865671, 17325413, 14010183, 17726838, 13364795
     17389192, 17612828, 17080436, 16613964, 17284817, 17441661, 17761775
     17721717, 16721594, 17390431, 18203837, 17551709, 17344412, 16043574
     17446237, 16863422, 18139690, 17071721, 17501491, 17610798, 17239687
     17752121, 17468141, 17602269, 18203835, 17375354, 17313525, 17811456
     16731148, 14133975, 18203838, 16956380, 17385178, 17235750, 13866822
     17394950, 17478514, 17027426, 12905058, 14338435, 16450169, 13944971
     18094246, 16929165, 16785708, 17265217, 17465741, 16220077, 16180763
     16069901, 17546973, 16285691, 17323222, 18180390, 17088068, 16875449
     17016369, 17443671, 16228604, 17811438, 17811447, 16837842, 18031668
     16912439, 17332800, 17393683, 17622427, 17545847, 17186905, 16943711
     16850630, 17082359, 17346671, 14852021, 17783588, 17437634, 16618694
     17341326, 17296856, 17546761, 17716305



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

OPatch succeeded.