Oracle 11g RAC 应用补丁简明版(3)

p23177551_112040_Linux-x86-64.zip

7.2 应用OJVM PSU su - oracle cp /tmp/p23177551_112040_Linux-x86-64.zip /usr2 && cd /usr2 && unzip p23177551_112040_Linux-x86-64.zip $ cd <PATCH_TOP_DIR>/23177551 $ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ cd /usr2/23177551 && opatch apply 7.3 数据库应用OJVM PSU --1.For an Oracle RAC environment, reload the packages on one of the nodes using the following commands. Make sure no other instance of the database is up on the remote nodes. cd $ORACLE_HOME/sqlpatch/23177551 sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> alter system set cluster_database=false scope=spfile; SQL> SHUTDOWN SQL> STARTUP UPGRADE SQL> @postinstall.sql SQL> alter system set cluster_database=true scope=spfile; SQL> SHUTDOWN SQL> STARTUP --2.After installing the SQL portion of the patch, some packages could become INVALID. This will get recompiled upon access or you can run utlrp.sql to get them back into a VALID state. cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> @utlrp.sql 8.应用补丁结果

最终验证应用补丁的结果：
各节点的$GRID_HOME,$ORACLE_HOME,都可以使用opatch lspatches查看补丁应用的情况：

[root@db02 tmp]# su - grid [grid@db02 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359) 22502505;ACFS Patch Set Update : 11.2.0.4.160419 (22502505) 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319) OPatch succeeded. [grid@db02 ~]$ exit logout [root@db02 tmp]# su - oracle [oracle@lrnopdb02 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 23177551;OJVM PATCH SET UPDATE 11.2.0.4.160719 23054359;Database Patch Set Update : 11.2.0.4.160719 (23054359) 23054319;OCW Patch Set Update : 11.2.0.4.160719 (23054319) OPatch succeeded. [oracle@db02 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 18 17:39:41 2016 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> set linesize 1000 SQL> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS --------------------------------------------------------------------------- ------------------------------ ------------------------------ ------------------------------ ---------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 28-JUN-16 12.36.13.876461 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0 18-AUG-16 03.49.29.881506 PM APPLY SERVER 11.2.0.4 160719 PSU PSU 11.2.0.4.160719 18-AUG-16 05.20.06.098533 PM jvmpsu.sql SERVER 11.2.0.4.160719OJVMPSU 0 RAN jvmpsu.sql 18-AUG-16 05.20.06.213324 PM APPLY SERVER 11.2.0.4.160719OJVMPSU 0 OJVM PSU post-install 18-AUG-16 05.20.06.245501 PM APPLY 23177551 Patch 23177551 applied 6 rows selected. SQL> select count(1) from gv$instance; COUNT(1) ---------- 4 SQL>

至此，Oracle 11g RAC 应用补丁简明版整个过程的示例完毕。