1. psu 概述
Oracle PSU的全名是Patch Set Update，是Oracle对于发行的官方补丁包，包含了bug的修复。Oracle选取被用户下载数量多，且被验证过具有较低风险的补丁放入到每个季度的PSU中。在每个PSU中不但包含Bug的修复而且还包含了新的CPU。PSU通常随CPU一起发布。
在新部署环境建议打上新的补丁包
2. 升级环境描述
本次升级基本环境如下：
数据库版本 | 系统版本 | 升级psu版本 | 文件名 |
oracle 11.2.0.4 | redhat 7.4 | 11.2.0.4.190416 | p29255947 |
2016年1月份推出对PSU、SPU、Bundle Patch新的命名规则。 新的命名规则为（以11.2.0.4为例）：11.2.0.4.YYMMDD ，YYMMDD为主要patch （PSU、SPU、Bundle）发布的具体日期年份后两位、两位的月份以及两位的日期。如：11.2.0.4.190416表示这11.2.0.4的PSU 是在19年4月16日推出的patch。
3. 升级详细步骤
此升级oracle psu详细步骤如下：
[root@zfbadb1]mkdir /patch [root@zfbadb1]mv p6880880_112000_Linux-x86-64.zip p29255947_112040_Linux-x86-64.zip /patch/ [root@zfbadb1]cd /u01/app/11.2/grid/ [root@zfbadb1]mv OPatch OPatch_bak [root@zfbadb1]unzip /patch/p6880880_112000_Linux-x86-64.zip -d ./ [root@zfbadb1]chmod -R 777 OPatch [root@zfbadb1]chown -R grid:oinstall OPatch ll OPatch* OPatch: total 176 drwxr-x--- 6 grid oinstall 4096 Jun 13 17:54 auto drwxr-x--- 2 grid oinstall 4096 Jun 13 17:54 config drwxr-x--- 3 grid oinstall 4096 Jun 13 17:54 crs drwxr-x--- 2 grid oinstall 4096 Jun 13 17:54 docs -rwxr-x--- 1 grid oinstall 23550 Jun 13 17:54 emdpatch.pl drwxr-x--- 2 grid oinstall 4096 Jun 13 17:54 jlib drwxr-x--- 6 grid oinstall 4096 Jun 13 17:54 jre drwxr-x--- 9 grid oinstall 4096 Jun 13 17:54 modules drwxr-x--- 5 grid oinstall 4096 Jun 13 17:54 ocm -rwxr-x--- 1 grid oinstall 48493 Jun 13 17:54 opatch -rwxr-x--- 1 grid oinstall 16326 Jun 13 17:54 opatch.bat -rwxr-x--- 1 grid oinstall 4290 Jun 13 17:54 opatch_env.sh -rw-r----- 1 grid oinstall 2551 Jun 13 17:54 opatch.pl drwxr-x--- 4 grid oinstall 4096 Jun 13 17:54 opatchprereqs -rwxr-x--- 1 grid oinstall 3159 Jun 13 17:54 operr -rwxr-x--- 1 grid oinstall 4218 Jun 13 17:54 operr.bat -rw-r----- 1 grid oinstall 3177 Jun 13 17:54 operr_readme.txt drwxr-x--- 3 grid oinstall 4096 Jun 13 17:54 oplan drwxr-x--- 3 grid oinstall 4096 Jun 13 17:54 oracle_common drwxr-x--- 3 grid oinstall 4096 Jun 13 17:54 plugins -rw-r----- 1 grid oinstall 2915 Jun 13 17:54 README.txt drwxr-x--- 2 grid oinstall 4096 Jun 13 17:54 scripts -rw-r----- 1 grid oinstall 27 Jun 13 17:54 version.txt OPatch_bak: total 132 drwxr-xr-x 3 grid oinstall 4096 Jun 13 10:04 crs drwxr-xr-x 2 grid oinstall 4096 Jun 13 10:04 docs -rw-r----- 1 grid oinstall 23695 Aug 2 2010 emdpatch.pl drwxr-xr-x 3 grid oinstall 4096 Jun 13 10:04 jlib drwxr-xr-x 5 grid oinstall 4096 Jun 13 10:04 ocm -rwx--x--- 1 grid oinstall 31493 May 28 2013 opatch -rwx--x--- 1 grid oinstall 19867 May 28 2013 opatch.bat -rwx--x--- 1 grid oinstall 10056 Mar 31 2011 opatchdiag -rwx--x--- 1 grid oinstall 9352 Mar 31 2011 opatchdiag.bat -rw-r----- 1 grid oinstall 49 Jun 13 10:04 opatch.ini -rw-r----- 1 grid oinstall 2576 May 6 2009 opatch.pl drwxr-xr-x 4 grid oinstall 4096 Jun 13 10:04 opatchprereqs drwxr-xr-x 3 grid oinstall 4096 Jun 13 10:04 oplan [root@zfbadb1]# su - oracle Last login: Thu Jun 13 16:15:23 CST 2019 on pts/1 [root@zfbadb1]$ echo $ORACLE_HOME /u01/app/oracle/product/11.2 [root@zfbadb1]$ cd $ORACLE_HOME [root@zfbadb1]$ mv OPatch OPatch_bak [root@zfbadb1]$ unzip /patch/p6880880_112000_Linux-x86-64.zip -d ./ [root@zfbadb1]$ exit logout [root@zfbadb1 grid]# [root@zfbadb1 grid]# [root@zfbadb1 grid]]# [root@zfbadb1 grid]# ll -d OPatch* drwxr-xr-x 15 grid oinstall 4096 Jun 13 17:54 OPatch drwxr-xr-x 8 grid oinstall 4096 Jun 13 10:04 OPatch_20190613 [root@dntodu001 grid]# su - grid Last login: Thu Jun 13 18:00:09 CST 2019 [root@zfbadb1 grid]$ $ORACLE_HOME/OPatch/opatch version OPatch Version: 11.2.0.3.21 OPatch succeeded. [root@zfbadb1 grid]$ [root@zfbadb1 grid] cd /patch/ [root@zfbadb1 grid] unzip p29255947_112040_Linux-x86-64.zip [root@zfbadb1] chmod -R 777 /patch/29255947 正式打psu前需要，生成环境文件，需要在grid用户下生成。oracle用户的环境文件在oracle用户下生成：/u01/app/oracle/product/11.2.0.4/OPatch/ocm/bin/下 [root@zfbadb1] chown grid:oinstall -R /patch/ [grid@zfbadb1]$ cd /u01/app/11.2/grid/OPatch/ocm/bin/ [grid@zfbadb1]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. 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 The OCM configuration response file (ocm.rsp) was successfully created. [grid@zfbadb1 bin]$ [grid@zfbadb1 bin]$ exit logout [root@zfbadb1 grid]# 打psu前面需要先确认psu文件权限属主属组要修改为grid:oinstall 。打Oracle psu时，修改为oracle:oinstall [root@dntodu001 grid]# /u01/app/11.2/grid/OPatch/opatch auto /patch/29255947/ -oh /u01/app/11.2/grid/ -ocmrf /u01/app/11.2/grid/OPatch/ocm/bin/ocm.rsp Executing /u01/app/11.2/grid/perl/bin/perl /u01/app/11.2/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 29255947 -oh /u01/app/11.2/grid/ -ocmrf /u01/app/11.2/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2/grid/crs/install/crsconfig_params This is the main log file: /u01/app/11.2/grid/cfgtoollogs/opatchauto2021-01-29_18-20-20.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/11.2/grid/cfgtoollogs/opatchauto2021-01-29_18-20-20.report.log 2019-06-13 18:20:20: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2/grid/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /u01/soft/29255947/29141201 apply successful for home /u01/app/11.2/grid patch /u01/soft/29255947/29141056 apply successful for home /u01/app/11.2/grid patch /u01/soft/29255947/28729245 apply successful for home /u01/app/11.2/grid Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. opatch auto succeeded. [root@zfbadb1 grid]# [root@zagldb1 ~]# chown oracle:oinstall -R /patch/ [root@zagldb1 ~]$ cd /u01/app/oracle/product/11.2/OPatch/ocm/bin/ [oracle@zagldb1 bin]$ ./emocmrsp OCM Installation Response Generator 10.3.7.0.0 - Production Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved. 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 The OCM configuration response file (ocm.rsp) was successfully created. [oracle@zagldb1 bin]$ [root@zagldb1 11.2]# /u01/app/oracle/product/11.2/OPatch/opatch auto /patch/29255947/ -oh /u01/app/oracle/product/11.2/ -ocmrf /u01/app/oracle/product/11.2/OPatch/ocm/bin/ocm.rsp Executing /u01/app/11.2/grid/perl/bin/perl /u01/app/oracle/product/11.2/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 29255947 -oh /u01/app/oracle/product/11.2/ -ocmrf /u01/app/oracle/product/11.2/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2/grid/crs/install/crsconfig_params This is the main log file: /u01/app/oracle/product/11.2/cfgtoollogs/opatchauto2021-01-29_18-35-16.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/oracle/product/11.2/cfgtoollogs/opatchauto2021-01-29_18-35-16.log 2019-06-13 18:35:16: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2/grid/crs/install/crsconfig_params Stopping RAC /u01/app/oracle/product/11.2 ... Stopped RAC /u01/app/oracle/product/11.2 successfully patch /u01/soft/29255947/29141201/custom/server/29141201 apply successful for home /u01/app/oracle/product/11.2 patch /u01/soft/29255947/29141056 apply successful for home /u01/app/oracle/product/11.2 Starting RAC /u01/app/oracle/product/11.2 ... Started RAC /u01/app/oracle/product/11.2 successfully opatch auto succeeded. [root@zagldb1 11.2]# |
