Thursday, September 10, 2015

PSU on Oracle 12c RAC



 Oracle 12c RAC
 Patchset Update - PSU 12c


Today I am going demonstrate PSU on 12c RAC (12.1.0.1) on two nodes RAC database.   In this article we have existing 12c R1 Grid Infrastructure and 12c (12.1.0.1) RDBMS binary installed.  I have not created any Container database as well as Pluggable database.  For more information about PSU on Container and  Pluggable database you can visit my previous written blog.  Pluggable database click here.


Operating System     :        Oracle Enterprise Linux 6.5 x64
Oracle Cluster                   :        Grid Infrastructure 12.1.0.1
RDBMS Binary          :        Database 12.1.0.1
RDBMS Database       :        NOBITA


ON NODE 1

First we have to download the latest OPatch utility  p6880880_121010_Linux-x86-64.zip  from Oracle Support in order to apply PSU.

Before applying patchset we have to ensure the existing apply PSU/CPU.

[oracle@rac131 ~]$ /grid/app/12.1.0.1/grid/OPatch/opatch version
OPatch Version: 12.1.0.1.0

OPatch succeeded.
[oracle@rac131 ~]$ /grid/app/12.1.0.1/grid/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /grid/app/12.1.0.1/grid
Central Inventory : /grid/app/oraInventory
   from           : /grid/app/12.1.0.1/grid/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /grid/app/12.1.0.1/grid/cfgtoollogs/opatch/opatch2015-09-09_                                                             11-48-36AM_1.log

Lsinventory Output file location : /grid/app/12.1.0.1/grid/cfgtoollogs/opatch/ls                                                             inv/lsinventory2015-09-09_11-48-36AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure 12c                                       12.1.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Patch level status of Cluster nodes :

 Patching Level                  Nodes
 --------------                  -----
 0                               rac132,rac131

--------------------------------------------------------------------------------

OPatch succeeded.


[oracle@rac131 ~]$ /grid/app/12.1.0.1/grid/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/grid/app/12.1.0.1/g                                                             rid".


After downloading OPatch extract into the GRID HOME and RDBMS Home on both node of cluster.  Also move your existing OPatch directory to other location as per your availability .


[oracle@rac131 ~]$ cd /u01/app/oracle/product/12.1.0.1/dbhome_1/

[oracle@rac131 dbhome_1]$ mv OPatch old_OPatch

[oracle@rac131 dbhome_1]$ cd /SOFT/
[oracle@rac131 SOFT]$ ls
19440385
oracleasmlib-2.0.4-1.el6.x86_64.rpm
oracleasm-support-2.1.8-1.el6.x86_64.rpm
p19440385_112030_Linux-x86-64_GI_DB.zip
p20485762_121010_Linux-x86-64.zip
p6880880_112000_Linux-x86-64_Jun2015_oplan.zip
p6880880_121010_Linux-x86-64.zip

Extracting OPatch  GI on both nodes.


[oracle@rac131 SOFT]$ unzip -d /grid/app/12.1.0.1/grid/ p6880880_121010_Linux-x86-64.zip
Archive:  p6880880_121010_Linux-x86-64.zip
   creating: /grid/app/12.1.0.1/grid/OPatch/scripts/
  inflating: /grid/app/12.1.0.1/grid/OPatch/scripts/opatch_jvm_discovery.bat
  inflating: /grid/app/12.1.0.1/grid/OPatch/scripts/opatch_wls.bat
  inflating: /grid/app/12.1.0.1/grid/OPatch/scripts/opatch_wls
  inflating: /grid/app/12.1.0.1/grid/OPatch/scripts/opatch_jvm_discovery
 
Extracting OPatch  RDBMS on both nodes.


[oracle@rac131 SOFT]$ unzip -d /u01/app/oracle/product/12.1.0.1/dbhome_1/ p68808                                                             80_121010_Linux-x86-64.zip
Archive:  p6880880_121010_Linux-x86-64.zip
   creating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/
   creating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/
  inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_jvm                                                             _discovery.bat
  inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_wls                                                             .bat
  inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_wls                                                             
  inflating: /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/scripts/opatch_jvm                                                             _discovery


Download the GI and DB PSU p20485762_121010_Linux-x86-64.zip from Oracle Support.  After download extract the patchset to staging location on both nodes.


[oracle@rac131 12cPUS]$ unzip p20485762_121010_Linux-x86-64.zip
Archive:  p20485762_121010_Linux-x86-64.zip
   creating: 20485762/
   creating: 20485762/20299016/
   creating: 20485762/20299016/20299016/
   creating: 20485762/20299016/20299016/etc/
   creating: 20485762/20299016/20299016/etc/xml/
  inflating: 20485762/20299016/20299016/etc/xml/ShiphomeDirectoryStructure.xml
...
...
  inflating: 20485762/17077442/README.txt
   creating: 20485762/17077442/custom/
   creating: 20485762/17077442/custom/scripts/
  inflating: 20485762/17077442/custom/scripts/prepatch.sh
  inflating: 20485762/17077442/custom/scripts/postpatch.sh
  inflating: PatchSearch.xml

Opatch requires ocm.rsp file. 

Note 966023.1 describes How To Create An OCM Response File For Opatch Silent Installation. Let's create one for our setup in current directory. I didn't specify my MOS credentials as this is only used for demo purpose.

[oracle@rac131]$  $ORACLE_HOME/OPatch/ocm/bin/emocmrsp   -no_banner
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y
The OCM configuration response file (ocm.rsp) was successfully created.

Copy this on both nodes

[oracle@rac131 bin]$ ls
emocmrsp  ocm.rsp
[oracle@rac131 bin]$ cp ocm.rsp /SOFT/12cPUS/
[oracle@rac131 bin]$ scp ocm.rsp oracle@rac132:/SOFT/12cPUS/
ocm.rsp                                 100%  623     0.6KB/s   00:00


Now applying PSU using opatchauto utility as root user using rolling fashion method  where its doesn't require any database downtime.  Better to move or relocate service for any user connection failure.



 [root@rac131 20485762]# /grid/app/12.1.0.1/grid/OPatch/opatchauto apply /SOFT/12cPUS/20485762/ -ocmrf /SOFT/12cPUS/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.7
OUI Version        : 12.1.0.1.0
Running from       : /grid/app/12.1.0.1/grid

opatchauto log file: /grid/app/12.1.0.1/grid/cfgtoollogs/opatchauto/20485762/opatch_gi_2015-09-09_12-25-54_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /SOFT/12cPUS/20485762
Grid Infrastructure Patch(es): 17077442 17303297 20299016
DB Patch(es): 17077442 20299016

Patch Validation: Successful
Grid Infrastructure home:
/grid/app/12.1.0.1/grid
DB home(s):
/u01/app/oracle/product/12.1.0.1/dbhome_1


Performing prepatch operations on CRS Home... Successful

Applying patch(es) to "/u01/app/oracle/product/12.1.0.1/dbhome_1" ...
Patch "/SOFT/12cPUS/20485762/17077442" successfully applied to "/u01/app/oracle/product/12.1.0.1/dbhome_1".
Patch "/SOFT/12cPUS/20485762/20299016" successfully applied to "/u01/app/oracle/product/12.1.0.1/dbhome_1".

Applying patch(es) to "/grid/app/12.1.0.1/grid" ...
Patch "/SOFT/12cPUS/20485762/17077442" successfully applied to "/grid/app/12.1.0.1/grid".
Patch "/SOFT/12cPUS/20485762/17303297" successfully applied to "/grid/app/12.1.0.1/grid".
Patch "/SOFT/12cPUS/20485762/20299016" successfully applied to "/grid/app/12.1.0.1/grid".

Performing postpatch operations on CRS Home... Successful

[WARNING] SQL changes, if any, could not be applied on the following database(s): NOBITA ... Please refer to the log file for more details.

Apply Summary:
Following patch(es) are successfully installed:
GI Home: /grid/app/12.1.0.1/grid: 17077442,17303297,20299016
DB Home: /u01/app/oracle/product/12.1.0.1/dbhome_1: 17077442,20299016

opatchauto succeeded.

Opatchauto succeeded on Node One.  Now the status of cluster.

[root@rac131 20485762]# crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_DATA.dg
               ONLINE  ONLINE       rac131                   STABLE
               ONLINE  ONLINE       rac132                   STABLE
ora.DG_OCR.dg
               ONLINE  ONLINE       rac131                   STABLE
               ONLINE  ONLINE       rac132                   STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac131                   STABLE
               ONLINE  ONLINE       rac132                   STABLE
ora.asm
               ONLINE  ONLINE       rac131                   Started,STABLE
               ONLINE  ONLINE       rac132                   Started,STABLE
ora.net1.network
               ONLINE  ONLINE       rac131                   STABLE
               ONLINE  ONLINE       rac132                   STABLE
ora.ons
               ONLINE  ONLINE       rac131                   STABLE
               ONLINE  ONLINE       rac132                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac131                   STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac132                   STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac132                   STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       rac131                   169.254.52.14 10.10.
                                                             10.131 20.20.20.131,
                                                             STABLE
ora.cvu
      1        ONLINE  ONLINE       rac132                   STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       rac131                   Open,STABLE
ora.nobita.db
      1        ONLINE  ONLINE       rac131                   Open,STABLE
      2        ONLINE  ONLINE       rac132                   Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       rac132                   STABLE
ora.rac131.vip
      1        ONLINE  ONLINE       rac131                   STABLE
ora.rac132.vip
      1        ONLINE  ONLINE       rac132                   STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       rac131                   STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       rac132                   STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       rac132                   STABLE
--------------------------------------------------------------------------------

Looks like everything smooth.  Now we can move on next cluster node.  We will use the same procedure to complete.

ON NODE 2

Applying PSU on second node.

[root@rac132 ~]# /grid/app/12.1.0.1/grid/OPatch/opatchauto apply /SOFT/12cPUS/20485762/ -ocmrf /SOFT/12cPUS/ocm.rsp
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.7
OUI Version        : 12.1.0.1.0
Running from       : /grid/app/12.1.0.1/grid

opatchauto log file: /grid/app/12.1.0.1/grid/cfgtoollogs/opatchauto/20485762/opatch_gi_2015-09-09_13-03-15_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /SOFT/12cPUS/20485762
Grid Infrastructure Patch(es): 17077442 17303297 20299016
DB Patch(es): 17077442 20299016

Patch Validation: Successful
Grid Infrastructure home:
/grid/app/12.1.0.1/grid
DB home(s):
/u01/app/oracle/product/12.1.0.1/dbhome_1


Performing prepatch operations on CRS Home... Successful

Applying patch(es) to "/u01/app/oracle/product/12.1.0.1/dbhome_1" ...
Patch "/SOFT/12cPUS/20485762/17077442" successfully applied to "/u01/app/oracle/product/12.1.0.1/dbhome_1".
Patch "/SOFT/12cPUS/20485762/20299016" successfully applied to "/u01/app/oracle/product/12.1.0.1/dbhome_1".

Applying patch(es) to "/grid/app/12.1.0.1/grid" ...
Patch "/SOFT/12cPUS/20485762/17077442" successfully applied to "/grid/app/12.1.0.1/grid".
Patch "/SOFT/12cPUS/20485762/17303297" successfully applied to "/grid/app/12.1.0.1/grid".
Patch "/SOFT/12cPUS/20485762/20299016" successfully applied to "/grid/app/12.1.0.1/grid".

Performing postpatch operations on CRS Home... Successful

Apply Summary:
Following patch(es) are successfully installed:
GI Home: /grid/app/12.1.0.1/grid: 17077442,17303297,20299016
DB Home: /u01/app/oracle/product/12.1.0.1/dbhome_1: 17077442,20299016

opatchauto succeeded.

Finally PSU has successfully applied on both node. 

From 12c onwards we need to apply datapatch on database (RDBMS).  Prior to 12c  we were used catbundle.sql. 

Login to any of the node.  Here I am applying datapatch on Node 1.


ON NODE 1

Set the environment and apply datapatch as oracle user.

[oracle@rac131 20485762]$ . oraenv
ORACLE_SID = [oracle] ? NOBITA1

Before applying check the database registry history information and verify after datapatch.

 [oracle@rac131 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 9 13:28:27 2015

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options

SQL> @reg

ACTION_TIME                  ACTION        NAMESPACE  VERSION            ID COMMENTS             BUNDLE_SER
---------------------------- ------------- ---------- ---------- ---------- -------------------- ----------
17-SEP-11 10.21.11.595816 AM APPLY         SERVER     11.2.0.3            0 Patchset 11.2.0.2.0  PSU
08-SEP-15 09.34.55.797434 PM APPLY         SERVER     11.2.0.3            0 Patchset 11.2.0.2.0  PSU
08-SEP-15 11.56.28.357498 PM APPLY         SERVER     11.2.0.3           12 PSU 11.2.0.3.12      PSU
09-SEP-15 05.40.10.997725 AM VIEW INVALIDA                          8289601 view invalidation
                             TE

09-SEP-15 05.42.41.761736 AM UPGRADE       SERVER     12.1.0.1.0            Upgraded from 11.2.0
                                                                            .3.0

09-SEP-15 05.46.25.451966 AM APPLY         SERVER     12.1.0.1            0 Patchset 12.1.0.0.0  PSU

6 rows selected.


Applying database on Cluster Database.  If we have CDB/PDB then refer to my existing blog for datapatch apply Pluggable database click here.



[oracle@rac131 ~]$ /u01/app/oracle/product/12.1.0.1/dbhome_1/OPatch/datapatch
SQL Patching tool version 12.1.0.1.0 on Wed Sep  9 13:47:22 2015
Copyright (c) 2014, Oracle.  All rights reserved.

Connecting to database...OK
Determining current state...
done
Adding patches to installation queue and performing prereq checks...done
Installation queue:
  Nothing to roll back
  The following patches will be applied: 19769486,20299016
Installing patches...
Patch installation complete.  Total patches installed: 2
Validating logfiles...done
SQL Patching tool complete on Wed Sep  9 13:52:21 2015


Datapatch applied successfully.  Now its high time to verify the post verification .


POST VERIFICATION


Post verification of database registry.

SQL> select * from registry$history;

ACTION_TIME                  ACTION        NAMESPACE  VERSION        ID COMMENTS             BUNDLE_SER
---------------------------- ------------- ---------- --------- ------- -------------------- ----------
17-SEP-11 10.21.11.595816 AM APPLY         SERVER     11.2.0.3        0 Patchset 11.2.0.2.0  PSU
08-SEP-15 09.34.55.797434 PM APPLY         SERVER     11.2.0.3        0 Patchset 11.2.0.2.0  PSU
08-SEP-15 11.56.28.357498 PM APPLY         SERVER     11.2.0.3       12 PSU 11.2.0.3.12      PSU
09-SEP-15 05.40.10.997725 AM VIEW INVALIDA                      8289601 view invalidation
                             TE

09-SEP-15 05.42.41.761736 AM UPGRADE       SERVER     12.1.0.1.0        Upgraded from 11.2.0
                                                                        .3.0

09-SEP-15 05.46.25.451966 AM APPLY         SERVER     12.1.0.1        0 Patchset 12.1.0.0.0  PSU
09-SEP-15 01.52.18.744867 PM APPLY         SERVER     12.1.0.1        7 PSU 12.1.0.1.7       PSU
09-SEP-15 01.52.21.161055 PM APPLY         SERVER     12.1.0.1        7 PSU 12.1.0.1.7       PSU

8 rows selected.

Verify the applied patch set.

[oracle@rac131 OPatch]$ ./opatch lspatches
20299016;Database Patch Set Update : 12.1.0.1.7 (20299016)
17077442;Oracle Clusterware Patch Set Update 12.1.0.1.1

OPatch succeeded.



[oracle@rac131 ~]$ cd /grid/app/12.1.0.1/grid/OPatch/
[oracle@rac131 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.7
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/12.1.0.1/dbhome_1
Central Inventory : /grid/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0.1/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.7
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/opatch2015-09-09_15-16-58PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0.1/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-09_15-16-58PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac131.ora.com
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.


Interim patches (2) :

Patch  20299016     : applied on Wed Sep 09 12:31:51 IST 2015
Unique Patch ID:  18536956
Patch description:  "Database Patch Set Update : 12.1.0.1.7 (20299016)"
   Created on 2 Feb 2015, 02:34:14 hrs PST8PDT
Sub-patch  19769486; "Database Patch Set Update : 12.1.0.1.6 (19769486)"
   Bugs fixed:
     16406802, 16576250, 17605522, 16433745, 18439152, 16465158, 16523150
     18002100, 17830435, 16101465, 17316776, 16660558, 17797837, 16433540
     16462834, 16924879, 16842274, 16663465, 16465149, 18603606, 14010183
     16705020, 17912217, 14664684, 15921906, 17817656, 17040764, 17478145
     17039360, 19358317, 16991789, 17777061, 18148383, 16485876, 16787973
     17405549, 16433869, 18641419, 16715647, 17467075, 13771513, 16911800
     16456371, 18420490, 16712618, 17216406, 16825779, 19297295, 16921340
     17797453, 16443657, 16994576, 16479182, 17441661, 17465741, 16993424
     16788832, 16888264, 17437634, 14237793, 16910001, 16838328, 16689109
     17298973, 18126350, 16795944, 19554106, 19458377, 16512817, 16762985
     17596344, 17516005, 16524968, 16757934, 18641461, 16946613, 16978185
     16495802, 16543323, 19309466, 17171530, 16935643, 17308691, 17571945
     16782193, 17226980, 18641451, 17982838, 16855202, 16683859, 16619979
     17888553, 16173738, 17364702, 16837842, 17005047, 16772060, 16710753
     14197853, 17205719, 17848854, 16459685, 17860549, 17976046, 17750832
     16347904, 17359546, 17080436, 17898041, 18155703, 18078926, 16007562
     16410570, 17551812, 17390431, 16856570, 16613964, 16802693, 19556045
     16061921, 18355572, 16551086, 17954431, 16668226, 17217040, 17600719
     17184677, 16527374, 20074391, 16228604, 16042673, 14576755, 17393683
     19006849, 17174582, 18393024, 17210416, 17000176, 18121501, 18348157
     16697600, 17436936, 17034172, 17762296, 16450169, 17019974, 17974104
     17898730, 18423374, 15994107, 15914210, 17289787, 16191248, 15986012
     16679874, 16570023, 17442449, 15905421, 15996344, 19866250, 16475788
     17489214, 17572525, 20296213, 14595800, 16263492, 15931910, 17608025
     17659488, 17753428, 17391312, 17027533, 17311728, 17753514, 18096714
     17897716, 16681689, 17478811, 16320173, 18554871, 16178562, 16864562
     16362358, 16855292, 16039096, 17026503, 20299016, 18093615, 17324822
     18513099, 16864359, 16698577, 17806676, 17867137, 20328279, 16850996
     16901482, 17182200, 17892268, 17257820, 16603924, 16930325, 16212405
     19248799, 16849982, 15987992, 16457621, 17443671, 16473934, 16913149
     18308576, 17158214, 18856947, 18889652, 16707927, 16275522, 14355775
     18099539, 16816103, 16912439, 16584684, 16517900, 16851772, 16859937
     16919176, 17349104, 16741246, 17537657, 16972213, 17552800, 18522516
     17341326, 17346196, 16928832, 16087650, 16585173, 19049453, 17735933
     16796277, 16675739, 17273253, 13521413, 18061914, 17981677, 16822629
     16372203, 16845022, 8352043, 17174391, 17810688, 16977973, 16634384
     16672859, 16392068, 16863422, 18244962, 17037526, 17491753, 16682595
     16575931, 17260090, 18973907, 17490498, 17088068, 17330580, 19915271
     16195633, 16936008, 16181570, 17762256, 17721717, 16733884, 17534365
     18436307, 17983206, 16793174, 18092561, 17922172, 19121550, 17716565
     17446849, 16964686, 16617325, 17761775, 17461374, 16721594, 17179261
     18262334, 17610418, 18292893, 16902138, 17042658, 16483559, 15953721
     18229326, 16986421, 17305959, 16874123, 16769019, 17006570, 17032726
     16070351, 19197175, 16371304, 16964279, 16864864, 17249820, 19692901
     17446564, 17343514, 17325413, 17421502, 16170787, 17462687, 17362796
     17439871, 16730813, 17883081, 17579911, 12911115, 18082092, 16347068
     17946998, 16313881, 16227068, 17997255, 17394724, 17443596, 16836849
     16969016, 14852021, 17716305, 17051636, 17244462, 19289642, 17767676
     17786278, 18189497, 17572720, 17082983, 16444683, 16621274, 16524071
     16709437, 14123213, 14506328, 16943711, 17710315, 13866822, 16503473
     16590848, 16784143, 16057129, 18031528, 16619249, 16589507, 16674666
     13782826, 19769486, 16790307, 16675710, 17828499, 16864048, 16694728
     16910734, 17614134, 17263661, 16448848, 17050888, 16286774, 20128874
     17280117, 18362376, 16427054, 16992075, 17016479, 16784167, 16663303
     16674842, 17468141, 18436647, 16186165, 14536110, 16946990, 17570606
     17235750, 16703112, 16784901, 17068536, 16929165

Patch  17077442     : applied on Wed Sep 09 12:30:35 IST 2015
Unique Patch ID:  16881794
Patch description:  "Oracle Clusterware Patch Set Update 12.1.0.1.1"
   Created on 12 Oct 2013, 06:33:53 hrs US/Central
   Bugs fixed:
     16505840, 16505255, 16390989, 16399322, 16505617, 16505717, 17486244
     16168869, 16444109, 16505361, 13866165, 16505763, 16208257, 16904822
     17299876, 16246222, 16505214, 16505540, 15936039, 16580269, 16838292
     16505449, 16801843, 16309853, 16505395, 17507349, 17475155, 16493242
     17039197, 16196609, 17463260, 16505667, 15970176, 16488665, 16670327



Rac system comprising of multiple nodes
  Local node = rac131
  Remote node = rac132

--------------------------------------------------------------------------------

OPatch succeeded.

Checking the cluster health check.

[oracle@rac131 OPatch]$ /grid/app/12.1.0.1/grid/bin/crsctl check cluster -all
**************************************************************
rac131:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac132:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************




Hope this will help you.

1 comment: