Oracle 11g RAC自动打GI PSU补丁(11.2.0.4.8)(5)

$ /u01/app/oracle/product/11.2.0/db_1/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/oracle/product/11.2.0/db_1/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.

六、升级数据库数据字典

数据库启动，并加载修改SQL Files到数据库

$ sqlplus / as sysdba  
 
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 25 11:26:02 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production    
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,    
Data Mining and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE  
--------------------    
READ WRITE

SQL>    
SQL>

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

SQL>    
执行完后我们可以查到PSU更新信息：    
SQL>

set line 150  
col ACTION_TIME for a30    
col ACTION for a8    
col NAMESPACE for a8    
col VERSION for a10    
col BUNDLE_SERIES for a5    
col COMMENTS for a20    
select * from dba_registry_history;    
 

ACTION_TIME                    ACTION  NAMESPAC VERSION            ID BUNDL COMMENTS  
------------------------------ -------- -------- ---------- ---------- ----- --------------------    
24-AUG-13 12.03.45.119862 PM  APPLY    SERVER  11.2.0.4            0 PSU  Patchset 11.2.0.2.0    
22-DEC-15 03.53.27.330912 PM  APPLY    SERVER  11.2.0.4            0 PSU  Patchset 11.2.0.2.0    
25-DEC-15 11.54.19.486765 AM  APPLY    SERVER  11.2.0.4            8 PSU  PSU 11.2.0.4.8

3 rows selected.

SQL>    

小节：自动打还是比较顺利的，没有出现手动打出现的问题，在此记录。

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