Oracle 11g RAC手动打GI PSU补丁(11.2.0.4.8)(2)

$ /u01/app/11.2.0/grid/OPatch/opatch lsinv   
                                                   
Patch  21352635    : applied on Fri Dec 18 17:38:24 CST 2015    
Unique Patch ID:  19227862    
Patch description:  "Database Patch Set Update : 11.2.0.4.8 (21352635)"    
  Created on 1 Sep 2015, 07:49:44 hrs    
Sub-patch  20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"    
Sub-patch  20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"    
Sub-patch  19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"    
Sub-patch  19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"    
Sub-patch  18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"    
Sub-patch  18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"    
Sub-patch  17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"    
  Bugs fixed:    
...

$ /u01/app/11.2.0/grid/OPatch/opatch lspatches

21352635;Database Patch Set Update : 11.2.0.4.8 (21352635)  
21352642;ACFS Patch Set Update : 11.2.0.4.8 (21352642)    
21352649;OCW Patch Set Update : 11.2.0.4.8 (21352649)

OPatch succeeded.

3. 两节点启动crs

说明：因为是手动打PSU,需要手动进行关闭与启动操作。  
# cd /u01/app/11.2.0/grid/bin    
# ./crsctl start has    
CRS-4123: Oracle High Availability Services has been started.

五、打database PSU补丁 1. 准备工作

(1) Root用户下，重新给PSU补丁包赋予权限

cd /u01/software/  
rm -rf 21523375    
chown oracle:oinstall p21523375_112040_Linux-x86-64.zip

(2) oracle用户

su - oracle  
cd /u01/software/;unzip p21523375_112040_Linux-x86-64.zip

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

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/21523375/21352635 -oh $ORACLE_HOME    
----------------------------------------------------    
Oracle Interim Patch Installer version 11.2.0.3.11    
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home      : /u01/app/oracle/product/11.2.0/db_1  
Central Inventory : /u01/app/oraInventory    
  from          : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc    
OPatch version    : 11.2.0.3.11    
OUI version      : 11.2.0.4.0    
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2015-12-21_09-25-57AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.  
----------------------------------------------------

2. oracle database打补丁，还是用同一个补丁包

su - oracle  
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/21523375/21352635

查看打补丁情况：

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv  
/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches

六、升级数据库数据字典 1. 数据库启动

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

cd /u01/app/11.2.0/grid/bin  
./crsctl start has

或直接执行如下命令，同时关闭两个节点。  
./crs_start -all

$ sqlplus / as sysdba    
 
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 15 13:40:39 2013    
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.    
 
Connected to an idle instance.    
 
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

SQL> startup  
ORACLE instance started.