Grid Upgradation from 12cR2 to 19c ~ Blog for oracle RAC Goldengate Dataguard ASM database

Hello Friends ,

In this post we will see the upgradation steps from 12.2 to 19c

Note : Before starting the upgrade a patch needs to be applied on 12R2 Grid [ 28553832 ]

Steps to apply Patch 28553832

Current ORACLE_HOME=/oracle/app/grid/gr_home

Target ORACLE_HOME=/oracle/app/grid/19c_grid

Software : V982068-01.zip

Unzip the software to location :

unzip --q V982068-01.zip -d /oracle/app/grid/19c_grid

Down the database before starting the Grid upgrade, or else will receive error in first step

now move the location and run ./gridsetup.sh

Step 1 :

Step 2 :

Step 3 :

Step 4 :

Step 5 :

Step 6 :

Step 7 :

Step 8 :

Step 9 :

Step 10 :

Step 10.1 :

[root@dm10db11 ~]# /oracle/app/grid/19c_grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /oracle/app/grid/19c_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 file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]: y
   Copying coraenv to /usr/local/bin ...

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: /oracle/app/grid/19c_grid/crs/install/crsconfig_params
The log of current session can be found at:
  /oracle/app/grid/crsdata/dm10db11/crsconfig/roothas_2020-05-30_01-06-08AM.log
2020/05/30 01:06:12 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.
2020/05/30 01:06:17 CLSRSC-363: User ignored prerequisites during installation
2020/05/30 01:06:18 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.
2020/05/30 01:06:23 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.
2020/05/30 01:06:23 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.
2020/05/30 01:06:23 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.

ASM has been upgraded and started successfully.

2020/05/30 01:07:21 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.
2020/05/30 01:07:21 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'.
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
2020/05/30 01:07:26 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 dm10db11 successfully pinned.
2020/05/30 01:07:30 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.
2020/05/30 01:07:31 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.
2020/05/30 01:07:31 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2020/05/30 01:07:52 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

dm10db11     2020/05/30 01:08:34     /oracle/app/grid/crsdata/dm10db11/olr/backup_20200530_010834.olr     724960844

dm10db11     2020/05/23 01:09:59     /oracle/app/grid/gr_home/cdata/dm10db11/backup_20200523_010959.olr     0
2020/05/30 01:08:35 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.
2020/05/30 01:10:32 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

Step 11 :

Step 12 :

Upgrade completed for ASM ----
Follow the below link for database upgradation from 12c to 19c

Upgrade Database from 12cR2 to 19c

Grid Upgradation from 12cR2 to 19c

Related Post