Oracle 10g R2 RAC手动打补丁PSU(10.2.0.5.19)(3)

Rac system comprising of multiple nodes  
  Local node = node1    
  Remote node = node2    
--------------------------------------------------------------------------------    
OPatch succeeded.

四、升级数据库数据字典 1，数据库启动，数据库已经启动的情况下,不需要再启动数据库，直接执行脚本即可。

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

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

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

ACTION_TIME                    ACTION    NAMESPAC VERSION                    ID BUNDL COMMENTS  
------------------------------ ---------- -------- ------------------ ---------- ----- --------------------    
29-MAR-16 04.15.04.729398 PM  jvmpsu.sql SERVER  10.2.0.5.2OJVMBP            0      RAN jvmpsu.sql    
29-MAR-16 04.15.52.723026 PM  jvmpsu.sql SERVER  10.2.0.5.2OJVMBP            0      RAN jvmpsu.sql    
29-MAR-16 04.24.14.043257 PM  APPLY      SERVER  10.2.0.5                  19 PSU  PSU 10.2.0.5.19

3 rows selected.  
SQL>