本文主要是介绍11.2.0.3.5打PSU 11补丁--手动方式(p18706488_112030_AIX64-5L.zip)，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
11.2.0.3.5打PSU 11补丁--手动方式(p18706488_112030_AIX64-5L.zip)
一：版本情况
操作系统平台
AIX 61009
oracle版本
11.2.0.3.5
二：打补丁前的准备工作
1.备份ASM/RDBMS的spfile文件
grid用户
$sqlplus '/as sysasm'
SQL>create pfile='/apps/*****/backup/pfile_grid_201410.ora' from spfile;oracle用户
$sqlplus '/as sysdba'
SQL>create pfile='/apps/******/backup/pfile_rdbms_201410.ora' from spfile;
2.备份oracle软件和crs软件
root用户
#cd /apps/*****/backup
#tar -cvf oracle201410.tar /apps/oracle/product/11.2.0.3/db_1/*
#tar -cvf grid201410.tar /apps/11.2.0.3/grid/*
#tar -cvf oraInventory201410.tar /apps/oracle/oraInventory/*3.OPatch Utility Information(下载符合要求的OPatch，对每个节点的grid_home和oracle_home目录下的目录进行覆盖)
a.Download the OPatch utility
download from My Oracle Support patch6880880 by selecting ARU link for the 11.2.0.0.0 release
b.For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility
$ unzip <OPATCH-ZIP> -d <ORACLE_HOME> ##分别以grid和oracle用户执行
$ <ORACLE_HOME>/OPatch/opatch version --覆盖后检查opatch版本是否改变
Validation of Oracle Inventory
Before beginning patch application, check the consistency of inventory information for GI home and each database home to be patched. Run the following command as respective Oracle home owner to check the consistency.
$ <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>
If this command succeeds, it lists the Oracle components that are installed in the home. Save the output so you have the status prior to the patch apply.
If this command fails, contact Oracle Support Services for assistance.
#在两个节点执行分别以oracle和grid用户执行命令并保存结果
5.冲突检查
使用Patch Conflict Checker工具进行冲突检查(方法见"My Oracle Support 补丁冲突检查器（Patch Conflict Checker）")
三：打PSU补丁
##分别在每个节点上执行如下命令
1.在打补丁之前先停掉相应节点EM
As the Oracle RAC database home owner execute:
$ <ORACLE_HOME>/bin/emctl stop dbconsole
2.Stop the CRS managed resources running from DB homes ##.停止CRS管理的资源.
【oracle用户】
1) case1
If this is a GI Home environment, as the database home owner execute: $ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name>
如：
/apps/oracle/product/11.2.0.3/db_1/bin/srvctl stop home -o /apps/oracle/product/11.2.0.3/db_1 -s /apps/****/s1.out -n node12) case2
If this is an Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location>##这一步会停掉相应节点的数据库实例
3. Run the pre root script. ##.运行pre root脚本.
【root用户】
1) case1
If this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -unlock如：/apps/11.2.0.3/grid/crs/install/rootcrs.pl -unlock
2) case2
If this is an Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -unlock##这一步会停掉相应节点的CRS
Note:
You need to make sure that the Oracle ACFS file systems are unmounted (see My Oracle Support document1494652.1How to Mount or Unmount ACFS File System While Applying GI Patches?) and all other Oracle processes are shutdown before you proceed.（在打补丁之前确保ACFS文件系统已经卸载并且所有的oracle相关进程已经停止，第2步会听到实例等相关资源，第3步会停掉CRS）
4. Apply the CRS patch using ##.安装CRS补丁.
【grid用户】
##注意如果是AIX操作系统在打补丁之前以ROOT用户执行几次slibclean命令移除内核和库中任何当前不用的模块
As the GI home owner execute:$ <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_components_number>如：/apps/11.2.0.3/grid/OPatch/opatch napply -oh /apps/11.2.0.3/grid -local /apps/****/psu/17592127As the GI home owner execute:$ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <UNZIPPED_PATCH_LOCATION>/<DB_PSU_number>
如：/apps/11.2.0.3/grid/OPatch/opatch apply -oh /apps/11.2.0.3/grid -local /apps/****/psu/18522512
</span>##注意在打新的grid PSU之前会把之前的grid pus回滚掉。在打database的pus时不会这样。这样就出现一种情况，我们如果把新打的PSU补丁rollback，那么db的PSU版本会变成原来的(我们这里变成了原来的psu5)，但是grid上就不会再有任何补丁信息
5. Run the pre script for DB component of the patch.As the database home owner execute: ##.运行DB组件的 pre script.
【oracle用户】
$ <UNZIPPED_PATCH_LOCATION>/<GI_components_number>/custom/server/<GI_components_number>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>如：/apps/****/psu/17592127/custom/server/17592127/custom/scripts/prepatch.sh -dbhome /apps/oracle/product/11.2.0.3/db_1
6.Apply the DB patch.As the database home owner execute: ##.安装DB patch.
【oracle用户】
$ <ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<GI_components_number>/custom/server/<GI_components_number>
$ <ORACLE_HOME>/OPatch/opatch apply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<DB_PSU_number>
如：/apps/oracle/product/11.2.0.3/db_1/OPatch/opatch napply -oh /apps/oracle/product/11.2.0.3/db_1 -local /apps/****/psu/17592127/custom/server/17592127
/apps/oracle/product/11.2.0.3/db_1/OPatch/opatch apply -oh /apps/oracle/product/11.2.0.3/db_1 -local /apps/****/psu/185225127.Run the post script for DB component of the patch.As the database home owner execute: ##.运行DB组件的 post script.
【oracle用户】
$ <UNZIPPED_PATCH_LOCATION>/<GI_components_number>/custom/server/<GI_components_number>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>如：/apps/****/psu/17592127/custom/server/17592127/custom/scripts/postpatch.sh -dbhome /apps/oracle/product/11.2.0.3/db_1
8. Run the post script.As the root user execute: ##.运行post script.
【root用户】
1)
# <GI_HOME>/rdbms/install/rootadd_rdbms.sh
2)
case1
If this is a GI Home, as the root user execute:
# <GI_HOME>/crs/install/rootcrs.pl -patch
case2
If this is an Oracle Restart Home, as the root user execute:
# <GI_HOME>/crs/install/roothas.pl -patch如：
/apps/11.2.0.3/grid/rdbms/install/rootadd_rdbms.sh
/apps/11.2.0.3/grid/crs/install/rootcrs.pl -patch
9.如果出现消息"A system reboot is recommended before using ACFS”,那么需要重启主机.
If the message, "A system reboot is recommended before using ACFS” is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.
10.Start the CRS managed resources that were earlier running from DB homes. ##.启动CRS管理的资源.
【oracle用户】
1) case1
If this is a GI Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name>如：
/apps/oracle/product/11.2.0.3/db_1/bin/srvctl start home -o /apps/oracle/product/11.2.0.3/db_1 -s /apps/****/s1.out -n node1
2) case2
If this is an Oracle Restart Home environment, as the database home owner execute:
$ <ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location>
11.确定系统补丁是否打成功
在grid和oracle用户下执行 opatch lsinventory
查看是否打上了最新的PSU
##注意因为grid的PSU从PSU9以后就没有新的补丁集增加，所以我们看到虽然我们打的是PSU11，但是我们查询结果如下：
Patch 17592127 : applied on Mon Oct 13 21:19:44 CST 2014
Unique Patch ID: 17508149
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)"Created on 8 Jan 2014, 23:02:20 hrs PST8PDTBugs fixed:
12.在其他RAC节点上重复一样步骤
13.所有节点psu打成功后，加载数据库脚本
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> QUIT
14.Upgrade Oracle Recovery Manager Catalog ##.更新catalog库.
##如果使用了catalog库我们需要在打完psu后，需要更新catalog
rman target / catalog rman/*****@tocatalog
RMAN> UPGRADE CATALOG;
##至此完成psu补丁安装
##详细信息请参考Readme - Patch Installation and Deinstallation For 11.2.0.3.x GI PSU (Doc ID 1494646.1) 第五部分“Manual Steps for Apply/Rollback Patch”
##通过Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)可以查看到各版本目前最新的psu(通常GI PSU中包含database psu)
这篇关于11.2.0.3.5打PSU 11补丁--手动方式(p18706488_112030_AIX64-5L.zip)的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
