Oracle11g rac 打PSU

1:升级Opatch
到OPatch目录下：
备份之前的OPatch目录：
mv OPatch/  /tmp/OPatch_20150922
unzip  ***
opatch version


2:升级grid


(1) root用户下打grid需要关闭grid(两节点都执行)


cd /u01/app/11.2.0/grid/bin   
./crsctl stop cluster
(2):
grid用户下测试兼容性，针对多次打CPU的环境中
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 


/u01/software/21523375/21352649 -oh $ORACLE_HOME    


输出:
Invoking prereq "checkconflictagainstohwithdetail"


Prereq "checkConflictAgainstOHWithDetail" passed.


OPatch succeeded.  
(3):
开始升级GRID
依次节点1，节点2上人执行
第1步: 执行脚本, 一定要执行，否则无法成功，确保CRS是关闭状态
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
输出:
Using configuration parameter file: /grid/grid_home/crs/install/crsconfig_params    
CRS-4544: Unable to connect to OHAS     
CRS-4000: Command Stop failed, or completed with errors.     
Successfully unlock /grid/grid_home


(4):解压补丁包升级:
su - grid
/u01/app/11.2.0/grid/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/21523375/21352649   
过程中按照提示输入:






./opatch version
./opatch lsinventory
opatch lspatches


(5):两节点启动crs
# ./crsctl start has  


3:  打database PSU补丁


Oracle用户下检查兼容性,针对多次打CPU的环境中


$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 


/u01/software/21523375/21352635 -oh $ORACLE_HOME    


打PSU:
su - oracle   
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local 


/u01/software/21523375/21352635


升级数据库数据字典


3:更新dba_registry_history视图信息


SQL>@?/rdbms/admin/catbundle.sql psu apply
SQL>select action_time,action,namespace,version,id from dba_registry_history;




注:如果启动数据库时报错:请更改权限:
SQL> startup


ORA-01565: error in identifying file '+DATA/orcl/spfileorcl.ora'   
ORA-17503: ksfdopn:2 Failed to open file +DATA/orcl/spfileorcl.ora    
ORA-15001: diskgroup "DATA" does not exist or is not mounted    
ORA-15040: diskgroup is incomplete    
ORA-15040: diskgroup is incomplete    
ORA-15040: diskgroup is incomplete


说明：无法启动数据库，经过查询是因为oracle权限被更改为oracle:oinstall。通过如下方式解决。     
在集群的所有节点上执行如下命令修改：       
# chown oracle:asmadmin /u01/app/oracle/product/11.2.0/db_1/bin/oracle       
# chmod 6751 /u01/app/oracle/product/11.2.0/db_1/bin/oracle