阿里云-云小站(无限量代金券发放中)
【腾讯云】云服务器、云数据库、COS、CDN、短信等热卖云产品特惠抢购

Oracle 11.2.0.4.0打PSU到11.2.0.4.16-适用于新安装RAC,尚未创建数据库

197次阅读
没有评论

共计 5232 个字符,预计需要花费 14 分钟才能阅读完成。

一、准备软件包
 下载合适的 OPatch 以及最新的 PSU 补丁集,并上传到 Oracle RAC 各个节点服务器(节点 1 和节点 2 分别做下面的操作)
[root@rac1 psu]# pwd
 /u01/psu
 [root@rac1 psu]# ll
 -rw-r–r–  1 root root 753393263 Oct 26 16:21 p23615403_112040_Linux-x86-64.zip
 -rw-r–r–  1 root root  52733900 Oct 26 16:20 p6880880_112000_Linux-x86-64.zip

二、升级 grid 以及 Oracle 用户的 OPatch(节点 1 和节点 2 分别做下面的操作)
1、查看当前 OPatch 版本
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch version
 OPatch Version: 11.2.0.3.4
 OPatch succeeded.

 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
 OPatch Version: 11.2.0.3.4
 OPatch succeeded.

 2、升级 Opatch
 [root@rac1 psu]# unzip p6880880_112000_Linux-x86-64.zip
 [root@rac1 psu]# mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatch_bak
 [root@rac1 psu]# cp -rp /u01/psu/OPatch /u01/app/11.2.0/grid/
 [root@rac1 psu]# chown -R grid:oinstall /u01/app/11.2.0/grid/OPatch
 [root@rac1 psu]# mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatch_bak
 [root@rac1 psu]# cp -rp /u01/psu/OPatch /u01/app/oracle/product/11.2.0/db_1/
 [root@rac1 psu]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1/OPatch

 3、验证升级
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch version
 OPatch Version: 11.2.0.3.12
 OPatch succeeded.

 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version
 OPatch Version: 11.2.0.3.12
 OPatch succeeded.

三、生成 ocm 文件(节点 1 和 2 分别做下面的操作)
[grid@rac1 ~]$ cd /tmp/
 [grid@rac1 tmp]$ /u01/app/11.2.0/grid/OPatch/ocm/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.
 [grid@rac1 tmp]$ chmod 777 ocm.rsp
 [grid@rac1 tmp]$ ll ocm.rsp
 -rwxrwxrwx 1 grid oinstall 621 Oct 26 17:20 ocm.rsp

四、升级 database 和 grid 软件(节点 1 和 2 分别做下面的操作)
1、解压 PSU 升级包
[root@rac1 psu]# mkdir 23615403
 [root@rac1 psu]# unzip p23615403_112040_Linux-x86-64.zip -d 23615403
 [root@rac1 psu]# chmod -R 777 23615403

 2、升级 grid 软件

[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/psu/23615403/ -ocmrf /tmp/ocm.rsp
 Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/psu -patchn 23615403 -ocmrf /tmp/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-39-17.log

 This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
 /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-39-17.report.log

 2016-10-26 21:39:17: Starting Clusterware Patch Setup
 Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 Stopping CRS…
 Stopped CRS successfully

 patch /u01/psu/23615403/23054359  apply successful for home  /u01/app/11.2.0/grid
 patch /u01/psu/23615403/23054319  apply successful for home  /u01/app/11.2.0/grid
 patch /u01/psu/23615403/22502505  apply successful for home  /u01/app/11.2.0/grid

 Starting CRS…
 Installing Trace File Analyzer
 CRS-4123: Oracle High Availability Services has been started.

 opatch auto succeeded.

验证 grid 升级情况:
[grid@rac1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch lspatches
 22502505;ACFS Patch Set Update : 11.2.0.4.160419 (22502505)
 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319)
 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359)

 OPatch succeeded.

 3、升级 Oracle database 软件
[root@rac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/psu/23615403/ -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1/
 Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/psu -patchn 23615403 -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1/ -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

 This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-53-22.log

 This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
 /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2016-10-26_21-53-22.report.log

 2016-10-26 21:53:22: Starting Clusterware Patch Setup
 Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

 Stopping RAC /u01/app/oracle/product/11.2.0/db_1 …
 Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

 patch /u01/psu/23615403/23054359  apply successful for home  /u01/app/oracle/product/11.2.0/db_1
 patch /u01/psu/23615403/23054319/custom/server/23054319  apply successful for home  /u01/app/oracle/product/11.2.0/db_1
 patch /u01/psu/23615403/23177551  apply successful for home  /u01/app/oracle/product/11.2.0/db_1

 Starting RAC /u01/app/oracle/product/11.2.0/db_1 …
 Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

 opatch auto succeeded.

验证 Oracle database 升级情况:
[root@rac1 ~]# su – oracle
 [oracle@rac1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches
 23177551;OJVM PATCH SET UPDATE 11.2.0.4.160719
 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319)
 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359)

 OPatch succeeded.

更多 Oracle 相关信息见 Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

本文永久更新链接地址 :http://www.linuxidc.com/Linux/2016-12/138681.htm

正文完
星哥玩云-微信公众号
post-qrcode
 0
星锅
版权声明:本站原创文章,由 星锅 于2022-01-22发表,共计5232字。
转载说明:除特殊说明外本站文章皆由CC-4.0协议发布,转载请注明出处。
【腾讯云】推广者专属福利,新客户无门槛领取总价值高达2860元代金券,每种代金券限量500张,先到先得。
阿里云-最新活动爆款每日限量供应
评论(没有评论)
验证码
【腾讯云】云服务器、云数据库、COS、CDN、短信等云产品特惠热卖中