Oracle 11.2.0.4 opatch auto applied

主要步骤：

---

1. 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>

$ <ORACLE_HOME>/OPatch/opatch version

 

2. OCM Configuration

$ export GRID_HOME

$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output <specify_the_location>/file.rsp

 

3. 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>

 

4. Stop EM Agent Processes Prior to Patching and Prior to Rolling Back the Patch

$ <ORACLE_HOME>/bin/emctl stop dbconsole

 

5. Patching Oracle RAC Database Homes and GI Together

GI Home and the Database Homes that are not shared and ACFS file system is not configured.

As root user, execute the following command on each node of the cluster:

# opatch auto <UNZIPPED_PATCH_LOCATION>/27475913 -ocmrf <ocm response file>

 

6. Loading Modified SQL Files into the Database

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

SQL> @?/rdbms/admin/utlrp.sql

 

 

实际操作：

---

1.更新OPatch

mv $ORACLE_HOME/OPatch/ $ORACLE_HOME/OPatch/OPatchbk

cp /u01/app/stage/OPatch/ $ORACLE_HOME

chown -R grid:oinstall OPatch

chmod 755 OPatch

 

----查看是否在11.2.0.3.6 或者以上

$ <ORACLE_HOME>/OPatch/opatch version

 

2.用grid用户配置ocm响应文件

$ /u01/app/oracle/product/11.2.0.4/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/ocm.rsp

 

3.验证

GI home and each database home：

$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

 

4.两节点运行

# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/app/stage/27475913 -ocmrf /tmp/ocm.rsp

# /u01/app/oracle/product/11.2.0.4/OPatch/opatch auto /u01/app/stage/27475913 -ocmrf /tmp/ocm.rsp

 

5.查看升级情况

$ORACLE_HOME/OPatch/opatch lspatches

 

6. 升级数据字典（单节点运行）

---升级数据字典

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

---编译java类

SQL> @?/rdbms/admin/utlrp.sql

select * from dba_registry_history;