Upgrading to 19C GI from 12.2

Required Software:

Needed software 
GI:  LINUX.X64_193000_grid_home.zip
RDBMS:  LINUX.X64_193000_db_home.zip
30899722 for April 2020p30899722_190000_Linux-x86-64.zip
Opatch:p6880880_200000_Linux-x86-64.zip
Autonomous Health Framework (AHF) – Including TFA and ORAchk/EXAChkAHF-LINUX_v20.1.3.zip

The current installation has to be checked with 2 tools: orachk and cluvfy. Both are included in the 19c software, but it is good practice to download the actual version from MOS (note 1268927.1).

Note: the AHF has 2 requirements: app 5 – 10 GB of storage AND the hierarchy of directory where you will install it needs to be owned by root in full. Recommended to create a FS in such way root:root  in /var/SP/ahf and perform install there.

oracle@mysrvr:/app/oracle/stage [MYDB]# ls -al *

-rw-r–r–.  1 oracle dba  165 Jun 24 11:30 status.file

Patch 28553832 was needed on mysrvr since it was not patched since 2018:

total 433452

drwxr-xr-x. 3 oracle dba      4096 Jun 24 11:59 .

drwxr-xr-x. 9 oracle dba      4096 Jun 24 11:58 ..

drwxr-x—. 4 oracle dba      4096 Dec 25  2018 28553832

-rw-r–r–. 1 oracle dba 443838687 Jun 24 11:59 p28553832_12201190115OCWJAN2019RU_Linux-x86-64.zip

Patch 30899722 for april 2020:

total 12

drwxr-xr-x. 3 oracle dba 4096 Jun 19 11:43 .

drwxr-xr-x. 9 oracle dba 4096 Jun 24 11:58 ..

drwxr-x—. 4 oracle dba 4096 Jun 24 11:00 Patch_30899722_GI_RELEASE_UPDATE_19.7.0.0.0__14_Apr_2020

Patch CVU only needed on new cluster:

total 286872

-rwxr-x—.  1 oracle dba 293648959 Jun 24 10:19 cvupack_Linux_x86_64.zip

To install GI:

total 2821488

drwxr-xr-x. 3 oracle dba       4096 Jun 24 10:20 .

drwxr-xr-x. 9 oracle dba       4096 Jun 24 11:58 ..

drwxr-xr-x. 2 oracle dba       4096 Jun 24 10:22 DELETEME

-rwxr-x—. 1 oracle dba 2889184573 Jun 19 11:38 LINUX.X64_193000_grid_home.zip

Latest versions of Opatch:

total 231280

drwxr-xr-x. 2 oracle dba      4096 Jun 24 10:54 .

drwxr-xr-x. 9 oracle dba      4096 Jun 24 11:58 ..

-rwxr-x—. 1 oracle dba 118408624 Jun 24 10:54 p6880880_200000_Linux-x86-64.zip

Database software RDBMS:

total 2988008

drwxr-xr-x. 2 oracle dba       4096 Jun 19 11:40 .

drwxr-xr-x. 9 oracle dba       4096 Jun 24 11:58 ..

-rwxr-x—. 1 oracle dba 3059705302 Jun 19 11:43 LINUX.X64_193000_db_home.zip

Latest TFA:

total 258556

drwxr-xr-x. 2 oracle dba      4096 Jun 19 14:30 .

drwxr-xr-x. 9 oracle dba      4096 Jun 24 11:58 ..

-rw-r–r–. 1 oracle dba 264751391 Jun 19 14:30 TFA-LINUX_v19.2.1.zip

Running preparations:

./cluvfy stage -pre crsinst -n <Nodes>  -verbose > /tmp/results_cluvfy_001.txt

This showed below types of errors, which due to fact this is an existing box with clusterware running was ok ( after checking proceeded with the installation):

Failures were encountered during execution of CVU verification request “stage -pre crsinst”.

Verifying Group Existence: asmadmin …FAILED

mysrvr: PRVG-10461 : Group “asmadmin” selected for privileges “OSASM” does

          not exist on node “mysrvr”.

Verifying Group Existence: asmdba …FAILED

mysrvr: PRVG-10461 : Group “asmdba” selected for privileges “OSDBA” does not

          exist on node “mysrvr”.

Verifying Group Membership: asmadmin …FAILED

mysrvr: PRVG-10460 : User “oracle” does not belong to group “asmadmin”

          selected for privileges “OSASM” on node “mysrvr”.

Verifying Group Membership: asmdba …FAILED

mysrvr: PRVG-10460 : User “oracle” does not belong to group “asmdba” selected

          for privileges “OSDBA” on node “mysrvr”.

Verifying Node Connectivity …WARNING

mysrvr: PRVG-11069 : IP address “169.254.0.2” of network interface “idrac” on

          the node “mysrvr” would conflict with HAIP usage.

Verifying Domain Sockets …FAILED

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_monitor_ag_mysrvr_”

          exists on node “mysrvr”.

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_css_ctrllcl_mysrvr_”

          exists on node “mysrvr”.

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_mysrvr_EVMD” exists on

          node “mysrvr”.

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_mysrvr_CSSD” exists on

          node “mysrvr”.

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_agent_ag_mysrvr_”

          exists on node “mysrvr”.

mysrvr: PRVG-11750 : File “/var/tmp/.oracle/ora_gipc_mysrvr_INIT” exists on

          node “mysrvr”.

Verifying ASM Filter Driver configuration …WARNING

mysrvr: PRVE-10237 : Existence of files

          “/lib/modules/3.10.0-693.el7.x86_64/extra/oracle/oracleafd.ko,/lib/mod

          ules/3.10.0-862.9.1.el7.x86_64/weak-updates/oracle/oracleafd.ko,/opt/o

          racle/extapi/64/asm/orcl/1/libafd12.so” is not expected on node

          “mysrvr” before Clusterware installation or upgrade.

mysrvr: PRVE-10239 : ASM Filter Driver “oracleafd” is not expected to be

          loaded on node “mysrvr” before Clusterware installation or upgrade.

Grid Infrastructure installation:

Before really starting the Gui follow these steps:

– GRID_HOME:

mkdir -p /app/grid/product/19c/grid

cd /app/grid/product/19c/grid

ls -la

If not empty:

rm -rf *

rm -rf .patch_storage

## Unzip the file in /app/grid/product/19c/grid

unzip /app/oracle/stage/GI/LINUX.X64_193000_grid_home.zip

Opatch version.

For the installation get yourself the latest version of opatch from Metalink and add it to stage directory.

cd /app/grid/product/19c/grid

mkdir OPatch_old_20200513

cp -pir OPatch/* OPatch_old_20200513/

unzip /app/oracle/stage/Opstch/p6880880_200000_Linux-x86-64.zip

-> respond with “A”

Below will patch the GI software with April 2020 And will start the Gui after.

cd /app/grid/product/19c/grid/

unset ORACLE_HOME

unset ORACLE_BASE

export ORACLE_BASE=/app/oracle

./gridSetup.sh -applyPSU /app/oracle/stage/30899722/Patch_30899722_GI_RELEASE_UPDATE_19.7.0.0.0__14_Apr_2020/30899722

##After patching, the Installer started which requested me to stop the databases that were using the current ASM.

##Stopping the instances that are all using the same Oracle home:

srvctl stop home -o /app/oracle/product/12201/db -s /app/oracle/stage/status.file -n $(uname -n) -stopoption immediate

## after that I restarted:

/app/grid/product/19c/grid/gridSetup.sh &

In the next screens, select next till the pre-requisite Checks are running. There I ended up with this:

This message made it all to clear to me that Patching was needed.  After completing that I should do a retry.

Patch 28553832  :

Oracle Clusterware 12C Release 2 (12.2.0.1.0OCWJAN2019RU)

Patch for Bug# 28553832 for Linux-x86-64 platform

This patch is RAC Rolling Installable.

Released: 25 December , 2018

6 Bugs Fixed by This Patch

This patch includes the following bug fixes:

13852018 DB12; NEED TEST PATCH FOR DB12 FROM SE FOR EVERY CANDIDATE DB LABEL

The log of current session can be found at:

  /app/oracle/crsdata/mysrvr/crsconfig/roothas_2020-06-24_01-03-35PM.log

2020/06/24 13:03:36 CLSRSC-595: Executing upgrade step 1 of 12: ‘UpgPrechecks’.

2020/06/24 13:03:39 CLSRSC-595: Executing upgrade step 2 of 12: ‘GetOldConfig’.

2020/06/24 13:03:41 CLSRSC-595: Executing upgrade step 3 of 12: ‘GenSiteGUIDs’.

2020/06/24 13:03:41 CLSRSC-595: Executing upgrade step 4 of 12: ‘SetupOSD’.

2020/06/24 13:03:41 CLSRSC-595: Executing upgrade step 5 of 12: ‘PreUpgrade’.

ASM has been upgraded and started successfully.

2020/06/24 13:04:38 CLSRSC-595: Executing upgrade step 6 of 12: ‘UpgradeAFD’.

2020/06/24 13:06:43 CLSRSC-595: Executing upgrade step 7 of 12: ‘UpgradeOLR’.

clscfg: EXISTING configuration version 0 detected.

Creating OCR keys for user ‘oracle’, privgrp ‘dba’..

Operation successful.

2020/06/24 13:06:47 CLSRSC-595: Executing upgrade step 8 of 12: ‘UpgradeOCR’.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user ‘root’, privgrp ‘root’..

Operation successful.

CRS-4664: Node mysrvr successfully pinned.

2020/06/24 13:06:50 CLSRSC-595: Executing upgrade step 9 of 12: ‘CreateOHASD’.

2020/06/24 13:06:51 CLSRSC-595: Executing upgrade step 10 of 12: ‘ConfigOHASD’.

2020/06/24 13:06:51 CLSRSC-329: Replacing Clusterware entries in file ‘oracle-ohasd.service’

2020/06/24 13:07:34 CLSRSC-595: Executing upgrade step 11 of 12: ‘UpgradeSIHA’.

mysrvr     2020/06/24 13:08:33     /app/oracle/crsdata/mysrvr/olr/backup_20200624_130833.olr     3633918477

mysrvr     2018/11/05 21:55:51     /app/grid/product/12201/grid/cdata/mysrvr/backup_20181105_215551.olr     2960767134

2020/06/24 13:08:34 CLSRSC-595: Executing upgrade step 12 of 12: ‘InstallACFS’.

2020/06/24 13:10:03 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

## Clicked ok

Photo by Pixabay on Pexels.com

srvctl start home -o /app/oracle/product/12201/db -s /app/oracle/stage/status.file

Checks:

oracle@mysrvr:/opt/oracle/diag/asm/+asm/+ASM/trace [+ASM]#  crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [19.0.0.0.0]

oracle@mysrvr:/opt/oracle/diag/asm/+asm/+ASM/trace [+ASM]# crsctl query has releasepatch

Oracle Clusterware release patch level is [3633918477] and the complete list of patches [30869156 30869304 30894985 30898856 ] have been applied on the local node. The release patch string is [19.7.0.0.0].

oracle@mysrvr:/opt/oracle/diag/asm/+asm/+ASM/trace [+ASM]#  crsctl query has softwarepatch

Oracle Clusterware patch level on node mysrvr is [3633918477].

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s