Oracle Database - 18c - RAC (DB) 18c Patching (Apply RU 18.4.0.0.0)

This is in continuation with my previous blog on patching of RAC - GI and in this blog we will patch RAC - DB.



[As oracle on All nodes]
# cd /u01/app/oracle/product/180/db
# mv OPatch OPatch.20190116
# unzip -qq /tmp/p6880880_122010_Linux-x86-64.zip
# chown -R oracle:oinstall OPatch


Verify OPatch version
# /u01/app/oracle/product/180/db/OPatch/opatch version
OPatch Version: 12.2.0.1.14 

[As root - on all nodes (rolling)]

Patch the Database

# export ORACLE_HOME=/u01/app/oracle/product/180/db/

# export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH

# opatchauto apply /tmp/install/28659165 -oh /u01/app/oracle/product/180/db/

Node 1 - Logs

[root@rac18c01 ~]# opatchauto apply /tmp/install/28659165 -oh /u01/app/oracle/product/180/db/

OPatchauto session is initiated at Wed Jan 16 01:29:23 2019

System initialization log file is /u01/app/oracle/product/180/db/cfgtoollogs/opatchautodb/systemconfig2019-01-16_01-29-26AM.log.


Session log file is /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/opatchauto2019-01-16_01-30-17AM.log
The id for this session is GVQH

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/180/db
Patch applicability verified successfully on home /u01/app/oracle/product/180/db


Verifying SQL patch applicability on home /u01/app/oracle/product/180/db
SQL patch applicability verified successfully on home /u01/app/oracle/product/180/db


Preparing to bring down database service on home /u01/app/oracle/product/180/db
Successfully prepared home /u01/app/oracle/product/180/db to bring down database service


Bringing down database service on home /u01/app/oracle/product/180/db
Following database(s) and/or service(s) are stopped and will be restarted later during the session: orpl
Database service successfully brought down on home /u01/app/oracle/product/180/db


Performing prepatch operation on home /u01/app/oracle/product/180/db
Perpatch operation completed successfully on home /u01/app/oracle/product/180/db


Start applying binary patch on home /u01/app/oracle/product/180/db
Binary patch applied successfully on home /u01/app/oracle/product/180/db


Performing postpatch operation on home /u01/app/oracle/product/180/db
Postpatch operation completed successfully on home /u01/app/oracle/product/180/db


Starting database service on home /u01/app/oracle/product/180/db
Database service successfully started on home /u01/app/oracle/product/180/db


Preparing home /u01/app/oracle/product/180/db after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/180/db
SQL patch applied successfully on home /u01/app/oracle/product/180/db

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac18c01
RAC Home:/u01/app/oracle/product/180/db
Version:18.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /tmp/install/28659165/28655916
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /tmp/install/28659165/28655963
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /tmp/install/28659165/28547619
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /tmp/install/28659165/28655784
Log: /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-16_01-31-29AM_1.log

Patch: /tmp/install/28659165/28656071
Log: /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-16_01-31-29AM_1.log



OPatchauto session completed at Wed Jan 16 01:35:43 2019
Time taken to complete the session 6 minutes, 21 seconds

Node 2 - Logs

[root@rac18c02 ~]# opatchauto apply /tmp/install/28659165 -oh /u01/app/oracle/product/180/db/

OPatchauto session is initiated at Wed Jan 16 01:39:13 2019

System initialization log file is /u01/app/oracle/product/180/db/cfgtoollogs/opatchautodb/systemconfig2019-01-16_01-39-15AM.log.

Following home(s) will not be included as part of current opatchauto session as it's software only RAC home:
Home path:/u01/app/oracle/product/180/db, Host:rac18c03


Session log file is /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/opatchauto2019-01-16_01-39-47AM.log
The id for this session is AMR5

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/180/db
Patch applicability verified successfully on home /u01/app/oracle/product/180/db


Verifying SQL patch applicability on home /u01/app/oracle/product/180/db
SQL patch applicability verified successfully on home /u01/app/oracle/product/180/db


Preparing to bring down database service on home /u01/app/oracle/product/180/db
Successfully prepared home /u01/app/oracle/product/180/db to bring down database service


Bringing down database service on home /u01/app/oracle/product/180/db
Following database(s) and/or service(s) are stopped and will be restarted later during the session: orpl
Database service successfully brought down on home /u01/app/oracle/product/180/db


Performing prepatch operation on home /u01/app/oracle/product/180/db
Perpatch operation completed successfully on home /u01/app/oracle/product/180/db


Start applying binary patch on home /u01/app/oracle/product/180/db
Binary patch applied successfully on home /u01/app/oracle/product/180/db


Performing postpatch operation on home /u01/app/oracle/product/180/db
Postpatch operation completed successfully on home /u01/app/oracle/product/180/db


Starting database service on home /u01/app/oracle/product/180/db
Database service successfully started on home /u01/app/oracle/product/180/db


Preparing home /u01/app/oracle/product/180/db after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/180/db
SQL patch applied successfully on home /u01/app/oracle/product/180/db

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:rac18c02
RAC Home:/u01/app/oracle/product/180/db
Version:18.0.0.0.0
Summary:

==Following patches were SKIPPED:

Patch: /tmp/install/28659165/28655916
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /tmp/install/28659165/28655963
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /tmp/install/28659165/28547619
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /tmp/install/28659165/28655784
Log: /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-16_01-41-37AM_1.log

Patch: /tmp/install/28659165/28656071
Log: /u01/app/oracle/product/180/db/cfgtoollogs/opatchauto/core/opatch/opatch2019-01-16_01-41-37AM_1.log



OPatchauto session completed at Wed Jan 16 01:46:15 2019
Time taken to complete the session 7 minutes, 3 seconds

Verify the Patching 
#  /u01/app/oracle/product/180/db/OPatch/opatch lspatches
28656071;OCW RELEASE UPDATE 18.4.0.0.0 (28656071)
28655784;Database Release Update : 18.4.0.0.181016 (28655784)
27908644;UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U171