Table of Contents

Patch of the Second Node

Patching the 2nd node was way easier than the first, since I already know, where I could fall :D

Prepare

Check the current Settings


[oracle@lparacb patch]$
[oracle@lparacb patch]$ df -h .
Filesystem               Size  Used Avail Use% Mounted on
/dev/mapper/centos-root   17G  9.7G  7.4G  57% /
[oracle@lparacb patch]$ ls -lart
total 1770216
drwxr-xr-x  7 oracle oinstall        143 Jan  5 15:55 27010872
-rw-r--r--  1 oracle oinstall 1812700471 Jan 17 16:55 p27010872_121020_Linux-x86-64.zip
drwx------. 5 oracle oinstall        147 Jan 18 11:31 ..
drwxr-xr-x  3 oracle oinstall         63 Jan 18 11:31 .
[oracle@lparacb patch]$ . oraenv
ORACLE_SID = [oracle] ? +ASM2
The Oracle base has been set to /u01/app/oracle/product
[oracle@lparacb patch]$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    lparaca
ora....ER.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N1.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N2.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora....N3.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    lparaca
ora.asm        ora.asm.type   ONLINE    ONLINE    lparaca
ora.cvu        ora.cvu.type   ONLINE    ONLINE    lparacb
ora....SM1.asm application    ONLINE    ONLINE    lparaca
ora....CA.lsnr application    ONLINE    ONLINE    lparaca
ora....aca.ons application    ONLINE    ONLINE    lparaca
ora....aca.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....SM2.asm application    ONLINE    ONLINE    lparacb
ora....CB.lsnr application    ONLINE    ONLINE    lparacb
ora....acb.ons application    ONLINE    ONLINE    lparacb
ora....acb.vip ora....t1.type ONLINE    ONLINE    lparacb
ora.mgmtdb     ora....db.type ONLINE    ONLINE    lparaca
ora....network ora....rk.type ONLINE    ONLINE    lparaca
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    lparacb
ora.ons        ora.ons.type   ONLINE    ONLINE    lparaca
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    lparacb
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    lparacb
[oracle@lparacb patch]$ pwd
/home/oracle/patch
[oracle@lparacb patch]$ ls -lart
total 1770216
drwxr-xr-x  7 oracle oinstall        143 Jan  5 15:55 27010872
-rw-r--r--  1 oracle oinstall 1812700471 Jan 17 16:55 p27010872_121020_Linux-x86-64.zip
drwx------. 5 oracle oinstall        147 Jan 18 11:31 ..
drwxr-xr-x  3 oracle oinstall         63 Jan 18 11:31 .
[oracle@lparacb patch]$ cd 27010872/
[oracle@lparacb 27010872]$ pwd
/home/oracle/patch/27010872
[oracle@lparacb 27010872]$ ls -lart
total 92
drwxr-xr-x  5 oracle oinstall    62 Jan  5 15:50 26925218
drwxr-xr-x  4 oracle oinstall    48 Jan  5 15:50 26983807
drwxr-xr-x  5 oracle oinstall    62 Jan  5 15:52 26910974
drwxrwxr-x 16 oracle oinstall   267 Jan  5 15:54 26925311
drwxr-xr-x  2 oracle oinstall  4096 Jan  5 15:54 automation
-rw-r--r--  1 oracle oinstall     0 Jan  5 15:55 README.txt
drwxr-xr-x  7 oracle oinstall   143 Jan  5 15:55 .
-rw-rw-r--  1 oracle oinstall  4991 Jan  5 16:31 bundle.xml
-rw-rw-r--  1 oracle oinstall 78371 Jan 16 09:00 README.html
drwxr-xr-x  3 oracle oinstall    63 Jan 18 11:31 ..
[oracle@lparacb 27010872]$ /home/oracle/patch/27010872^C
[oracle@lparacb 27010872]$
[oracle@lparacb 27010872]$ opatch lsinventory
-bash: opatch: command not found
[oracle@lparacb 27010872]$ cd $ORACLE_HOME
[oracle@lparacb grid]$ cd OPatch
[oracle@lparacb OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.11
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/grid
Central Inventory : /u01/app/oracle/oraInventory
   from           : /u01/app/oracle/grid/oraInst.loc
OPatch version    : 12.2.0.1.11
OUI version       : 12.1.0.2.0
Log file location : /u01/app/oracle/grid/cfgtoollogs/opatch/opatch2018-01-18_11-39-16AM_1.log

Lsinventory Output file location : /u01/app/oracle/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-01-18_11-39-16AM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: lparacb
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

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


There are no Interim patches installed in this Oracle Home.


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

OPatch succeeded.

Here again I did the same idiocracy® :)

[oracle@lparacb OPatch]$
[oracle@lparacb OPatch]$
[oracle@lparacb OPatch]$
[oracle@lparacb OPatch]$ /u01/app/oracle/grid/OPatch/opatchauto apply /home/oracle/patch/27010872 -analyze -ocmrf /home/oracle/ocmcheck.ocm

OPatchauto session is initiated at Thu Jan 18 11:39:43 2018
OPATCHAUTO-72046: Wallet option is not provided.
OPATCHAUTO-72046: Wallet option is required during patching as non-root user.
OPATCHAUTO-72046: Please provide a wallet option or execute as root user.

OPatchauto session completed at Thu Jan 18 11:39:45 2018
Time taken to complete the session 0 minute, 2 seconds

opatchauto bootstrapping failed with error code 46.
[oracle@lparacb OPatch]$ /u01/app/oracle/grid/OPatch/opatchauto apply /home/oracle/patch/27010872 -analyze

OPatchauto session is initiated at Thu Jan 18 11:39:55 2018
OPATCHAUTO-72046: Wallet option is not provided.
OPATCHAUTO-72046: Wallet option is required during patching as non-root user.
OPATCHAUTO-72046: Please provide a wallet option or execute as root user.

OPatchauto session completed at Thu Jan 18 11:39:56 2018
Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 46.

Patching

Check for consistency

[oracle@lparacb OPatch]$ logout
[root@lparacb oracle]# . oraenv
ORACLE_SID = [+ASM2] ?
The Oracle base remains unchanged with value /u01/app/oracle/product
[root@lparacb oracle]# /u01/app/oracle/grid/OPatch/opatchauto apply /home/oracle/patch/27010872 -analyze -ocmrf /home/oracle/ocmcheck.ocm

OPatchauto session is initiated at Thu Jan 18 11:40:50 2018

System initialization log file is /u01/app/oracle/grid/cfgtoollogs/opatchautodb/systemconfig2018-01-18_11-40-53AM.log.

Session log file is /u01/app/oracle/grid/cfgtoollogs/opatchauto/opatchauto2018-01-18_11-41-07AM.log

WARNING: the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration.

The id for this session is NRHR

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/grid

Patch applicability verified successfully on home /u01/app/oracle/grid

OPatchAuto successful.

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

Analysis for applying patches has completed successfully:

Host:lparacb
CRS Home:/u01/app/oracle/grid


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /home/oracle/patch/27010872/26910974
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-41-16AM_1.log

Patch: /home/oracle/patch/27010872/26925218
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-41-16AM_1.log

Patch: /home/oracle/patch/27010872/26925311
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-41-16AM_1.log

Patch: /home/oracle/patch/27010872/26983807
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-41-16AM_1.log


OPatchauto session completed at Thu Jan 18 11:44:22 2018
Time taken to complete the session 3 minutes, 32 seconds

Perform the Patch

[root@lparacb grid]# /u01/app/oracle/grid/OPatch/opatchauto apply /home/oracle/patch/27010872/ -oh /u01/app/oracle/grid/

OPatchauto session is initiated at Thu Jan 18 11:49:39 2018

System initialization log file is /u01/app/oracle/grid/cfgtoollogs/opatchautodb/systemconfig2018-01-18_11-49-42AM.log.

Session log file is /u01/app/oracle/grid/cfgtoollogs/opatchauto/opatchauto2018-01-18_11-49-51AM.log
The id for this session is 6E39

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


Bringing down CRS service on home /u01/app/oracle/grid
Prepatch operation log file location: /u01/app/oracle/grid/cfgtoollogs/crsconfig/crspatch_lparacb_2018-01-18_11-53-01AM.log
CRS service brought down successfully on home /u01/app/oracle/grid


Start applying binary patch on home /u01/app/oracle/grid



Binary patch applied successfully on home /u01/app/oracle/grid


Starting CRS service on home /u01/app/oracle/grid
Postpatch operation log file location: /u01/app/oracle/grid/cfgtoollogs/crsconfig/crspatch_lparacb_2018-01-18_12-58-02AM.log
CRS service started successfully on home /u01/app/oracle/grid

OPatchAuto successful.

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

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

Host:lparacb
CRS Home:/u01/app/oracle/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /home/oracle/patch/27010872/26910974
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-55-44AM_1.log

Patch: /home/oracle/patch/27010872/26925218
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-55-44AM_1.log

Patch: /home/oracle/patch/27010872/26925311
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-55-44AM_1.log

Patch: /home/oracle/patch/27010872/26983807
Log: /u01/app/oracle/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-01-18_11-55-44AM_1.log

Check the patch mode

Check if the OPatch put the cluster into a NORMAL Mode:

OPatchauto session completed at Thu Jan 18 13:01:14 2018
Time taken to complete the session 71 minutes, 36 seconds
[root@lparacb grid]#
[root@lparacb grid]#
[root@lparacb grid]#
[root@lparacb grid]# crsctl query crs activeversion -f
Oracle Clusterware active version on the cluster is [12.1.0.2.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [37976992].
[root@lparacb grid]#