- 28 Nov, 2023
- 0 Comments
- 2 Mins Read
Oracle RAC 12C to 19C ASM Upgradation
PREREQUISITE FOR UPGRADE:
- Apply required patches on grid home and oracle home. To apply patch on RAC Database , refer this blog : https://learnomate.org/rac-19c-patching/
STEP:1 Create 19C Directory on Both Node
mkdir -p /u02/app/grid/product/19C/dbhome chown -R grid:oinstall /u02 chmod -R 775 /u02
STEP 2: Copy the 19c grid software to the first node of RAC and unzip it:
cd u02/app/grid/product/19C/dbhome Unzip LINUX.X64_193000_grid_home.zip-------------------------on Node 1
Step 3. Run cluvfy utility to pre-check any errors
On 1st node only run the pre-upgrade script from the new home and generate a fix script if generated. as grid user.
su - grid cd /u02/app/grid/product/19C/dbhome -- 19c grid home ./runcluvfy.sh stage -pre crsinst -upgrade -rolling -src_crshome /u02/app/grid/product/12C/dbhome -dest_crshome p /u02/app/grid/product/19C/dbhome -dest_version 19.3.0.0.0 -fixup –verboseNote: Make sure the cluvfy is executed successfully. If any error occurs, take action before going to the GRID 12c upgrade.
Step 4. Using Dry-Run Upgrade Mode to Check System Upgrade Readiness
cd /u02/app/grid/product/19C/dbhome gridsetup.sh –dryRunForUpgrade
The dry run upgrade is successful. Let’s proceed with the actual upgrade.
Step 5: Actual Upgrade Grid Infrastructure
— Run as grid owner (oracle)unset ORACLE_BASE unset ORACLE_HOME unset ORACLE_SID
Run below script before actual upgradation from root user
Su root root# /u02/app/grid/product/12C/dbhome/crs/install/rootcrs.sh –unlock –crshome /u02/app/grid/product/19C/dbhome
Now , go to grid home & call gridSetup.sh
cd /u02/app/grid/product/19C/dbhome ./gridSetup.sh
We have successfully upgraded the grid to the 19c version.
Step 6: Post-check after upgrading the grid infrastructure
$ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] $ crsctl query crs softwareversion Oracle Clusterware version on node [dc-vt-testdb1] is [19.0.0.0.0] $ crsctl query crs activeversion Oracle Clusterware active version on the cluster is [19.0.0.0.0] $ crsctl query crs softwareversion Oracle Clusterware version on node [node2] is [19.0.0.0.0] $ crsctl check crs CRS-4638: Oracle High Availability Services is online CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online $ crsctl stat res -t -init $ crsctl stat res -t
Upgrade the grid bash profile with a new grid home
# vi .bash_profile export ORACLE_HOME=/u02/app/grid/product/19C/dbhome execute bash_profile from the grid user . .bash_profile