Patching Grid Infrastructure - 6880880 / 28714316



Quick notes on patch 6880880 (latest OPatch) and the October CPU (patch 28714316) for grid.

You could patch grid and the database together but this for Grid only.

Just did a quick cut & paste of the output with some redaction (server names etc).




Patch 28714316 - GI Oct 2018 Release Update 12.2.0.1.181016



oracle@serveroem grid]$ pwd
/u01/app/12.2.0/grid


[oracle@serveroem grid]$ unzip p6880880_122010_LINUX.zip
Archive:  p6880880_122010_LINUX.zip

replace OPatch/opatchprereqs/oui/knowledgesrc.xml? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
  inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
  inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
  inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
  inflating: OPatch/opatchprereqs/opatch/rulemap.xml
  ,,,,,,
  inflating: OPatch/scripts/opatch_jvm_discovery.bat
  inflating: OPatch/scripts/viewAliasInfo.sh

[oracle@serveroem grid]$ cd OPatch

[oracle@serveroem OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.16

OPatch succeeded.

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:00:17 2018
OPATCHAUTO-72083: Performing bootstrap operations failed.
OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..
OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:00:17 2018
Time taken to complete the session 0 minute, 0 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ grep -i crs= /u01/app/oraInventory/ContentsXML/inventory.xml
[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch
[oracle@serveroem OPatch]$ cd ..
[oracle@serveroem grid]$ oui/bin/runInstaller -updateNodeList -silent CRS=false ORACLE_HOME="/u01/app/12.2.0/grid"
Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB.   Actual 4087 MB    Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' failed.

[oracle@serveroem grid]$ pwd
/u01/app/12.2.0/grid
[oracle@serveroem grid]$ cd OPatch
[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:03:52 2018
OPATCHAUTO-72083: Performing bootstrap operations failed.
OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..
OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:03:53 2018
Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.
[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:38:21 2018
OPATCHAUTO-72083: Performing bootstrap operations failed.
OPATCHAUTO-72083: The bootstrap execution failed because Cannot detect any valid Grid Infrastructure setup..
OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov 26 07:38:22 2018
Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch


[oracle@serveroem OPatch]$ cd ..


Software only install of grid –

 [oracle@serveroem grid]$ ./gridSetup.sh
Launching Oracle Grid Infrastructure Setup Wizard...

--- Once grid installed then try patch again.



[oracle@serveroem grid]$ pwd
/u01/app/12.2.0/grid
[oracle@serveroem grid]$ cd OP*

 [oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch
[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:43:57 2018
Error: This Java instance does not support a 64-bit JVM.
Please install the desired version.

OPatchauto session completed at Mon Nov 26 07:43:57 2018
Time taken to complete the session 0 minute, 0 second

opatchauto bootstrapping failed with error code 1.
[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch
[oracle@serveroem OPatch]$ ls -la
total 220
drwxr-xr-x 14 oracle oinstall  4096 Nov 26 06:54 .
drwxr-xr-x 68 oracle oinstall  4096 Nov 26 07:41 ..
drwxr-xr-x  6 oracle oinstall  4096 Nov 26 06:54 auto
drwxr-x---  2 oracle oinstall  4096 Oct 23 06:27 config
-rwxr-x---  1 oracle oinstall   589 Oct 23 06:27 datapatch
-rwxr-x---  1 oracle oinstall   627 Oct 23 06:27 datapatch.bat
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 docs
-rwxr-x---  1 oracle oinstall 23550 Oct 23 06:27 emdpatch.pl
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 jlib
drwxr-x---  5 oracle oinstall  4096 May 13  2018 jre
drwxr-xr-x 11 oracle oinstall  4096 Nov 26 06:54 modules
drwxr-xr-x  5 oracle oinstall  4096 Nov 26 06:54 ocm
-rwxr-x---  1 oracle oinstall 48433 Oct 23 06:27 opatch
-rwxr-x---  1 oracle oinstall  1442 Oct 23 06:32 opatchauto
-rwxr-x---  1 oracle oinstall   393 Oct 23 06:32 opatchauto.cmd
-rwxr-x---  1 oracle oinstall 16326 Oct 23 06:27 opatch.bat
-rwxr-x---  1 oracle oinstall 10122 Jun 15  2016 opatchdiag
-rwxr-x---  1 oracle oinstall  9422 Jun 15  2016 opatchdiag.bat
-rwxr-x---  1 oracle oinstall  4290 Oct 23 06:27 opatch_env.sh
-rwxr-x---  1 oracle oinstall  2551 Oct 23 06:27 opatch.pl
drwxr-xr-x  4 oracle oinstall  4096 Nov 26 06:54 opatchprereqs
-rwxr-x---  1 oracle oinstall  3159 Oct 23 06:27 operr
-rwxr-x---  1 oracle oinstall  4218 Oct 23 06:27 operr.bat
-rw-r-----  1 oracle oinstall  3177 Oct 23 06:27 operr_readme.txt
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 oplan
drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 oracle_common
drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 plugins
-rw-r-----  1 oracle oinstall  2980 Oct 23 06:27 README.txt
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 scripts
-rw-r-----  1 oracle oinstall    27 Oct 23 06:27 version.txt

[oracle@serveroem OPatch]$ cd jre

[oracle@serveroem jre]$ cd bin

[oracle@serveroem bin]$ ls

ControlPanel  java  javaws  jcontrol  jjs  keytool  orbd  pack200  policytool  rmid  rmiregistry  servertool  tnameserv  unpack200

[oracle@serveroem bin]$ ls -la
total 436
drwxr-xr-x 2 oracle oinstall   4096 May 13  2018 .
drwxr-x--- 5 oracle oinstall   4096 May 13  2018 ..
-r-xr-xr-x 1 oracle oinstall   6264 May 13  2018 ControlPanel
-r-xr-xr-x 1 oracle oinstall   5730 May 13  2018 java
-r-xr-xr-x 1 oracle oinstall 104523 May 13  2018 javaws
-r-xr-xr-x 1 oracle oinstall   6264 May 13  2018 jcontrol
-r-xr-xr-x 1 oracle oinstall   5881 May 13  2018 jjs
-r-xr-xr-x 1 oracle oinstall   5893 May 13  2018 keytool
-r-xr-xr-x 1 oracle oinstall   6029 May 13  2018 orbd
-r-xr-xr-x 1 oracle oinstall   5897 May 13  2018 pack200
-r-xr-xr-x 1 oracle oinstall   5997 May 13  2018 policytool
-r-xr-xr-x 1 oracle oinstall   5881 May 13  2018 rmid
-r-xr-xr-x 1 oracle oinstall   5893 May 13  2018 rmiregistry
-r-xr-xr-x 1 oracle oinstall   5909 May 13  2018 servertool
-r-xr-xr-x 1 oracle oinstall   6061 May 13  2018 tnameserv
-r-xr-xr-x 1 oracle oinstall 230044 May 13  2018 unpack200

[oracle@serveroem bin]$ mv java java_orig

[oracle@serveroem bin]$ pwd
/u01/app/12.2.0/grid/OPatch/jre/bin

[oracle@serveroem bin]$ ln -s /u01/app/12.2.0/grid/jdk/bin/java java

[oracle@serveroem bin]$ ./java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)

[oracle@serveroem bin]$ pwd
/u01/app/12.2.0/grid/OPatch/jre/bin

n  This worked but need to confirm whether supported, the java with the supplied patch should work

[oracle@serveroem jre]$ cd ..

[oracle@serveroem OPatch]$ ls -la
total 220
drwxr-xr-x 14 oracle oinstall  4096 Nov 26 06:54 .
drwxr-xr-x 68 oracle oinstall  4096 Nov 26 07:41 ..
drwxr-xr-x  6 oracle oinstall  4096 Nov 26 06:54 auto
drwxr-x---  2 oracle oinstall  4096 Oct 23 06:27 config
-rwxr-x---  1 oracle oinstall   589 Oct 23 06:27 datapatch
-rwxr-x---  1 oracle oinstall   627 Oct 23 06:27 datapatch.bat
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 docs
-rwxr-x---  1 oracle oinstall 23550 Oct 23 06:27 emdpatch.pl
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 jlib
drwxr-x---  5 oracle oinstall  4096 May 13  2018 jre
drwxr-xr-x 11 oracle oinstall  4096 Nov 26 06:54 modules
drwxr-xr-x  5 oracle oinstall  4096 Nov 26 06:54 ocm
-rwxr-x---  1 oracle oinstall 48433 Oct 23 06:27 opatch
-rwxr-x---  1 oracle oinstall  1442 Oct 23 06:32 opatchauto
-rwxr-x---  1 oracle oinstall   393 Oct 23 06:32 opatchauto.cmd
-rwxr-x---  1 oracle oinstall 16326 Oct 23 06:27 opatch.bat
-rwxr-x---  1 oracle oinstall 10122 Jun 15  2016 opatchdiag
-rwxr-x---  1 oracle oinstall  9422 Jun 15  2016 opatchdiag.bat
-rwxr-x---  1 oracle oinstall  4290 Oct 23 06:27 opatch_env.sh
-rwxr-x---  1 oracle oinstall  2551 Oct 23 06:27 opatch.pl
drwxr-xr-x  4 oracle oinstall  4096 Nov 26 06:54 opatchprereqs
-rwxr-x---  1 oracle oinstall  3159 Oct 23 06:27 operr
-rwxr-x---  1 oracle oinstall  4218 Oct 23 06:27 operr.bat
-rw-r-----  1 oracle oinstall  3177 Oct 23 06:27 operr_readme.txt
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 oplan
drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 oracle_common
drwxr-xr-x  3 oracle oinstall  4096 Jan 26  2017 plugins
-rw-r-----  1 oracle oinstall  2980 Oct 23 06:27 README.txt
drwxr-xr-x  2 oracle oinstall  4096 Nov 26 06:54 scripts
-rw-r-----  1 oracle oinstall    27 Oct 23 06:27 version.txt

[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:45:20 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 Mon Nov 26 07:45:21 2018
Time taken to complete the session 0 minute, 1 second

opatchauto bootstrapping failed with error code 255.

[oracle@serveroem OPatch]$ sudo su -
[sudo] password for oracle:
Last login: Mon Nov 26 06:03:23 EST 2018 on pts/0

[root@serveroem ~]# cd /u01/app/12.2.0/grid/OPatch

[root@serveroem OPatch]# ./opatchauto apply /media/28714316 -oh /u01/app/12.2.0/grid

OPatchauto session is initiated at Mon Nov 26 07:45:58 2018

System initialization log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-11-26_07-46-01AM.log.

Session log file is /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/opatchauto2018-11-26_07-46-03AM.log
The id for this session is L7NR

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


Bringing down CRS service on home /u01/app/12.2.0/grid
Prepatch operation log file location: /u01/app/oracle/crsdata/serveroem/crsconfig/crspatch_serveroem_2018-11-26_07-46-14AM.log
CRS service brought down successfully on home /u01/app/12.2.0/grid


Start applying binary patch on home /u01/app/12.2.0/grid
Binary patch applied successfully on home /u01/app/12.2.0/grid


Starting CRS service on home /u01/app/12.2.0/grid
Postpatch operation log file location: /u01/app/oracle/crsdata/serveroem/crsconfig/crspatch_serveroem_2018-11-26_07-48-59AM.log
CRS service started successfully on home /u01/app/12.2.0/grid

OPatchAuto successful.

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

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

Host:serveroem
CRS Home:/u01/app/12.2.0/grid
Version:12.2.0.1.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /media/28714316/26839277
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28566910
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662603
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662626
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log

Patch: /media/28714316/28662640
Log: /u01/app/12.2.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-26_07-46-16AM_1.log



OPatchauto session completed at Mon Nov 26 07:49:00 2018
Time taken to complete the session 3 minutes, 2 seconds

[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch

[oracle@serveroem OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.16
Copyright (c) 2018, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/12.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.2.0/grid/oraInst.loc
OPatch version    : 12.2.0.1.16
OUI version       : 12.2.0.1.4
Log file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/opatch2018-11-26_07-51-14AM_1.log

Lsinventory Output file location : /u01/app/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-11-26_07-51-14AM.txt

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

Installed Top-level Products (1):

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


Interim patches (5) :

Patch  28662640     : applied on Mon Nov 26 07:48:57 EST 2018
Unique Patch ID:  22450089
Patch description:  "ACFS OCT 2018 RELEASE UPDATE 12.2.0.1.181016 (28662640)"
   Created on 18 Sep 2018, 03:56:19 hrs PST8PDT
   Bugs fixed:
     21129279, 22591010, 23152694, 23181299, 23625427, 24285969, 24346777
.....
      28633255

Patch  28662626     : applied on Mon Nov 26 07:47:59 EST 2018
Unique Patch ID:  22461084
Patch description:  "OCW OCT 2018 RELEASE UPDATE 12.2.0.1.181016 (28662626)"
   Created on 23 Sep 2018, 10:10:55 hrs PST8PDT
   Bugs fixed:
     12816839....


Patch  28662603     : applied on Mon Nov 26 07:47:03 EST 2018
Unique Patch ID:  22485591
Patch description:  "Database Oct 2018 Release Update : 12.2.0.1.181016 (28662603)"
   Created on 5 Oct 2018, 03:26:32 hrs PST8PDT
   Bugs fixed:
     28390273......
      

Patch  28566910     : applied on Mon Nov 26 07:46:30 EST 2018
Unique Patch ID:  22413436
Patch description:  "TOMCAT RELEASE UPDATE 12.2.0.1.0(ID:180802.1448.S) (28566910)"
   Created on 28 Aug 2018, 23:01:25 hrs PST8PDT
   Bugs fixed:
     25728967.......

Patch  26839277     : applied on Mon Nov 26 07:46:23 EST 2018
Unique Patch ID:  21578760
Patch description:  "DBWLM RELEASE UPDATE 12.2.0.1.0(ID:170913) (26839277)"
   Created on 21 Sep 2017, 03:13:10 hrs PST8PDT
   Bugs fixed:
     26584906,,,,,,


Bugs list removed for brevity..

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

OPatch succeeded.
[oracle@serveroem OPatch]$ pwd
/u01/app/12.2.0/grid/OPatch

Setup grid

[oracle@serveroem grid]$ ./gridSetup.sh
Launching Oracle Grid Infrastructure Setup Wizard...



----running root.sh

[root@serveroem grid]# ./root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/12.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.

To configure Grid Infrastructure for a Cluster or Grid Infrastructure for a Stand-Alone Server execute the following command as oracle user:
/u01/app/12.2.0/grid/gridSetup.sh
This command launches the Grid Infrastructure Setup Wizard. The wizard also supports silent operation, and the parameters can be passed through the response file that is available in the installation media.

[root@serveroem grid]# pwd
/u01/app/12.2.0/grid
[root@serveroem grid]# ./root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/12.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/12.2.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/crsdata/serveroem/crsconfig/roothas_2018-11-26_07-58-06AM.log
2018/11/26 07:58:07 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node serveroem successfully pinned.
2018/11/26 07:58:14 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'serveroem'
CRS-2673: Attempting to stop 'ora.evmd' on 'serveroem'
CRS-2677: Stop of 'ora.evmd' on 'serveroem' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'serveroem' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.

serveroem     2018/11/26 08:00:38     /u01/app/12.2.0/grid/cdata/serveroem/backup_20181126_080038.olr     476343201
2018/11/26 08:00:38 CLSRSC-327: Successfully configured Oracle Restart for a standalone server