11.2.0.4psu到11.2.0.4.8

1、grid用户创建ocm.rsp

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /software/ocm.rsp

chmod 775  /software /ocm.rsp
2、root用户逐个节点执行下列命令


./opatch auto /software/psu/21523375/ -ocmrf /software/ocm.rsp 

如果出现下列情况，参考mos文章id1946048.1
[root@ora6 OPatch]# ./opatch auto /software/psu/21523375/ -ocmrf /software/ocm.rsp 
Executing /u01/app/11.2.0/grid/perl/bin/perl ./crs/patch11203.pl -patchdir /software/psu -patchn 21523375 -ocmrf /software/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params


This is the main log file: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2017-02-23_04-31-44.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.0/dbhome_1/cfgtoollogs/opatchauto2017-02-23_04-31-44.report.log


2017-02-23 04:31:44: 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/dbhome_1/ ...
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1/ successfully


patch /software/psu/21523375/21352635  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1/ 
patch /software/psu/21523375/21352649/custom/server/21352649  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1/ 


Stopping RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/dbhome_1 successfully


patch /software/psu/21523375/21352635  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1 
patch /software/psu/21523375/21352649/custom/server/21352649  apply successful for home  /u01/app/oracle/product/11.2.0/dbhome_1 


Stopping CRS...
Stopped CRS successfully


patch /software/psu/21523375/21352635  apply successful for home  /u01/app/11.2.0/grid 
patch /software/psu/21523375/21352649  apply successful for home  /u01/app/11.2.0/grid 
patch /software/psu/21523375/21352642  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.


Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1/ ...
Started RAC /u01/app/oracle/product/11.2.0/dbhome_1/ successfully


Starting RAC /u01/app/oracle/product/11.2.0/dbhome_1 ...
Failed to start resources from  database home /u01/app/oracle/product/11.2.0/dbhome_1
ERROR: Refer log file for more details.




opatch auto failed.

4.执行下列命令升级数据字典

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

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

如果使用了catalog，则升级catalog

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29802484/viewspace-2138496/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29802484/viewspace-2138496/