PSU patch in online mode

PSU patch in online mode

current status

[HPSM1]-->srvctl status database -d hpsm -v

Instance HPSM1 is running on node amxd1dbadm01 with online services HPSMQC_TO_OUS,HPSMQC_TO_US,HPSM_APPS. Instance status: Open.

Instance HPSM2 is running on node amxd1dbadm02 with online services HPSM_APPS. Instance status: Open.

[oracle@amxd1dbadm01:/HPSM/ora01/product/12.1.0.2/.patch_storage]

[HPSM1]-->

1)srvctl stop service -d HPSM -s HPSM_APPS -i HPSM1

  srvctl stop service -d HPSM -s HPSMQC_TO_OUS -i HPSM1

  srvctl stop service -d HPSM -s HPSMQC_TO_US -i HPSM1

  srvctl stop service -d HPSM -s HPSM_APPS -i HPSM2

  

2) Node 1

   srvctl stop instance –d HPSM –i HPSM1

   srvctl stop listener –l HPSM

    Check the conflict on Node 1 :--

[HPSM2]-->$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/BP/24968615/24732088

Oracle Interim Patch Installer version 12.2.0.1.8

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /HPSM/ora01/product/12.1.0.2

Central Inventory : /u01/app/oraInventory

   from           : /HPSM/ora01/product/12.1.0.2/oraInst.loc

OPatch version    : 12.2.0.1.8

OUI version       : 12.1.0.2.0

Log file location : /HPSM/ora01/product/12.1.0.2/cfgtoollogs/opatch/opatch2017-04-02_05-05-39AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@amxd1dbadm02:/F12TRN1/ora01/product/12.1.0.2/network/admin]

[HPSM2]-->

3)Node 2

      srvctl stop instance –d HPSM –i HPSM2

    srvctl stop listener –l HPSM

Check the conflict on Node 2 :--

[HPSM2]-->$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/patches/BP/24968615/24732088

Oracle Interim Patch Installer version 12.2.0.1.8

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /HPSM/ora01/product/12.1.0.2

Central Inventory : /u01/app/oraInventory

   from           : /HPSM/ora01/product/12.1.0.2/oraInst.loc

OPatch version    : 12.2.0.1.8

OUI version       : 12.1.0.2.0

Log file location : /HPSM/ora01/product/12.1.0.2/cfgtoollogs/opatch/opatch2017-04-02_05-06-08AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

4.)Node1 apply patch

sudo su - root

cd /u01/patches

./dbhomeupdate.sh -h1 /HPSM/ora01/product/12.1.0.2 -h1r 19475484, 21923026   -h1b 24968615 -h1p 25154848, 21923026 -rolling

 (Two times It will prompt  for oracle home confirmation )

5._ Apply patch Node2

sudo su - root

cd /u01/patches

./dbhomeupdate.sh -h1 /HPSM/ora01/product/12.1.0.2 -h1r 19475484, 21923026   -h1b 24968615 -h1p 25154848, 21923026 -rolling

(Two times It will prompt  for oracle home confirmation )

Once patch applied 

6)Node 1  >> start node 1 instance

srvctl start instance -i HPSM1 –d HPSM

cd $ORACLE_HOME/OPatch

./datapatch – apply 24732088

5)Start all the service backup of database and service

  srvctl start service -d HPSM -s HPSM_APPS -i HPSM1

  srvctl start service -d HPSM -s HPSMQC_TO_OUS -i HPSM1

  srvctl start service -d HPSM -s HPSMQC_TO_US -i HPSM1

  srvctl start service -d HPSM -s HPSM_APPS -i HPSM2

  srvctl start instance -i HPSM2 –d HPSM

 make sure all service are up as below

[HPSM1]-->srvctl status database -d hpsm -v

Instance HPSM1 is running on node amxd1dbadm01 with online services HPSMQC_TO_OUS,HPSMQC_TO_US,HPSM_APPS. Instance status: Open.

Instance HPSM2 is running on node amxd1dbadm02 with online services HPSM_APPS. Instance status: Open.

[oracle@amxd1dbadm01:/HPSM/ora01/product/12.1.0.2/.patch_storage]

[HPSM1]-->

Below is the SQL statement which we can use to check the patch in DBA_REGISTRY_SQLPATCH

select  PATCH_ID, PATCH_UID, VERSION, STATUS, DESCRIPTION from DBA_REGISTRY_SQLPATCH order by BUNDLE_SERIES;