Oracle 19c Grid Infrastructure Upgrade from Oracle 18c on Exadata X7

Mehmet Salih Deveci August 13, 2020 Leave a comment

Hi,

I will explain Oracle 19c Grid Infrastructure Upgrade from Oracle 18c on Exadata X7 in this post.

 

 

If you don’t know what is the Oracle RAC and Exadata, you can read following articles.

You can download Oracle 19c installation file from Metalink and following link.

https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

 

 

Download Grid Infrastructure software and upload into Exadata. Unzip files and run sh gridSetup.sh file to start Upgrade.

Upgrade Oracle Grid Infrastructure is selected automatically. Click Next.

 

 

Select the Cluster nodes in this step. We have 8 nodes, so I have chosen them as following.

Click SSH Connectivity and do manual SSH Connectivity between nodes if it doesn’t exist.

 

 

 

You can register Oracle GI 19c with Enterprise manager Cloud Control.

 

 

Type Oracle base in this step.

 

You can select Automatically run configuration scripts.

 

 

There is no important error in this step, you can ignore these errors. Click submit and start Upgrade.

 

 

 

 

Upgrade is started.

 

 

 

 

In this step, you should run rootupgrade.sh on all nodes.

 

 

Firstly run rootupgrade.sh on first node, then you can perform other nodes same time. Finally Run the last node as follows.

 

[root@msdbadmdb01 tmp]# /u01/app/19.0.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.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.
Relinking oracle with rac_on option
Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/msdbadmdb01/crsconfig/rootcrs_msdbadmdb01_2020-08-09_08-39-19PM.log
2020/08/09 20:40:00 CLSRSC-595: Executing upgrade step 1 of 18: 'UpgradeTFA'.
2020/08/09 20:40:00 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2020/08/09 20:40:00 CLSRSC-595: Executing upgrade step 2 of 18: 'ValidateEnv'.
2020/08/09 20:40:04 CLSRSC-595: Executing upgrade step 3 of 18: 'GetOldConfig'.
2020/08/09 20:40:04 CLSRSC-464: Starting retrieval of the cluster configuration data
2020/08/09 20:40:38 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2020/08/09 20:41:58 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2020/08/09 20:43:32 CLSRSC-693: CRS entities validation completed successfully.
2020/08/09 20:43:42 CLSRSC-515: Starting OCR manual backup.
2020/08/09 20:43:54 CLSRSC-516: OCR manual backup successful.
2020/08/09 20:44:00 CLSRSC-486: 
At this stage of upgrade, the OCR has changed.
Any attempt to downgrade the cluster after this point will require a complete cluster outage to restore the OCR.
2020/08/09 20:44:00 CLSRSC-541: 
To downgrade the cluster: 
1. All nodes that have been upgraded must be downgraded.
2020/08/09 20:44:00 CLSRSC-542: 
2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2020/08/09 20:44:07 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2020/08/09 20:44:07 CLSRSC-595: Executing upgrade step 4 of 18: 'GenSiteGUIDs'.
-2020/08/09 20:44:10 CLSRSC-595: Executing upgrade step 5 of 18: 'UpgPrechecks'.
2020/08/09 20:44:14 CLSRSC-363: User ignored prerequisites during installation
2020/08/09 20:44:24 CLSRSC-595: Executing upgrade step 6 of 18: 'SetupOSD'.
2020/08/09 20:44:24 CLSRSC-595: Executing upgrade step 7 of 18: 'PreUpgrade'.
2020/08/09 20:44:59 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode
2020/08/09 20:44:59 CLSRSC-482: Running command: '/u01/app/18.0/grid/bin/crsctl start rollingupgrade 19.0.0.0.0'
CRS-1131: The cluster was successfully set to rolling upgrade mode.
2020/08/09 20:45:06 CLSRSC-482: Running command: '/u01/app/19.0.0/grid/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u01/app/18.0/grid -oldCRSVersion 18.0.0.0.0 -firstNode true -startRolling false '

ASM configuration upgraded in local node successfully.

2020/08/09 20:45:23 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode
2020/08/09 20:45:27 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2020/08/09 20:46:16 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2020/08/09 20:46:27 CLSRSC-595: Executing upgrade step 8 of 18: 'CheckCRSConfig'.
2020/08/09 20:46:28 CLSRSC-595: Executing upgrade step 9 of 18: 'UpgradeOLR'.
2020/08/09 20:46:54 CLSRSC-595: Executing upgrade step 10 of 18: 'ConfigCHMOS'.
2020/08/09 20:46:54 CLSRSC-595: Executing upgrade step 11 of 18: 'UpgradeAFD'.
2020/08/09 20:47:01 CLSRSC-595: Executing upgrade step 12 of 18: 'createOHASD'.
2020/08/09 20:47:07 CLSRSC-595: Executing upgrade step 13 of 18: 'ConfigOHASD'.
2020/08/09 20:47:07 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2020/08/09 20:47:37 CLSRSC-595: Executing upgrade step 14 of 18: 'InstallACFS'.
2020/08/09 20:48:10 CLSRSC-595: Executing upgrade step 15 of 18: 'InstallKA'.
2020/08/09 20:48:17 CLSRSC-595: Executing upgrade step 16 of 18: 'UpgradeCluster'.
-2020/08/09 20:49:19 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 5 detected.
Successfully taken the backup of node specific configuration in OCR. 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2020/08/09 20:49:38 CLSRSC-595: Executing upgrade step 17 of 18: 'UpgradeNode'.
2020/08/09 20:49:41 CLSRSC-474: Initiating upgrade of resource types
2020/08/09 20:50:18 CLSRSC-475: Upgrade of resource types successfully initiated.
2020/08/09 20:50:27 CLSRSC-595: Executing upgrade step 18 of 18: 'PostUpgrade'.
2020/08/09 20:50:34 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@msdbadmdb01 tmp]# --

[root@msdbadmdb08 ~]# cd /tmp
[root@msdbadmdb08 tmp]# /u01/app/19.0.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/19.0.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.
Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/grid/crsdata/msdbadmdb08/crsconfig/rootcrs_msdbadmdb08_2020-08-09_08-57-57PM.log
2020/08/09 20:58:03 CLSRSC-595: Executing upgrade step 1 of 18: 'UpgradeTFA'.
2020/08/09 20:58:03 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2020/08/09 20:58:03 CLSRSC-595: Executing upgrade step 2 of 18: 'ValidateEnv'.
2020/08/09 20:58:04 CLSRSC-595: Executing upgrade step 3 of 18: 'GetOldConfig'.
2020/08/09 20:58:04 CLSRSC-464: Starting retrieval of the cluster configuration data
2020/08/09 20:58:35 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2020/08/09 20:58:35 CLSRSC-595: Executing upgrade step 4 of 18: 'GenSiteGUIDs'.
2020/08/09 20:58:35 CLSRSC-595: Executing upgrade step 5 of 18: 'UpgPrechecks'.
2020/08/09 20:58:36 CLSRSC-363: User ignored prerequisites during installation
2020/08/09 20:58:37 CLSRSC-595: Executing upgrade step 6 of 18: 'SetupOSD'.
2020/08/09 20:58:37 CLSRSC-595: Executing upgrade step 7 of 18: 'PreUpgrade'.
2020/08/09 20:58:47 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

ASM configuration upgraded in local node successfully.

2020/08/09 20:58:57 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2020/08/09 20:59:44 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2020/08/09 21:00:04 CLSRSC-595: Executing upgrade step 8 of 18: 'CheckCRSConfig'.
2020/08/09 21:00:05 CLSRSC-595: Executing upgrade step 9 of 18: 'UpgradeOLR'.
2020/08/09 21:00:26 CLSRSC-595: Executing upgrade step 10 of 18: 'ConfigCHMOS'.
2020/08/09 21:00:26 CLSRSC-595: Executing upgrade step 11 of 18: 'UpgradeAFD'.
2020/08/09 21:00:27 CLSRSC-595: Executing upgrade step 12 of 18: 'createOHASD'.
2020/08/09 21:00:28 CLSRSC-595: Executing upgrade step 13 of 18: 'ConfigOHASD'.
2020/08/09 21:00:28 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2020/08/09 21:00:48 CLSRSC-595: Executing upgrade step 14 of 18: 'InstallACFS'.
2020/08/09 21:01:16 CLSRSC-595: Executing upgrade step 15 of 18: 'InstallKA'.
2020/08/09 21:01:17 CLSRSC-595: Executing upgrade step 16 of 18: 'UpgradeCluster'.
2020/08/09 21:02:29 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 19 detected.
Successfully taken the backup of node specific configuration in OCR. 
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
2020/08/09 21:02:43 CLSRSC-595: Executing upgrade step 17 of 18: 'UpgradeNode'.
-Start upgrade invoked..
2020/08/09 21:02:50 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2020/08/09 21:02:50 CLSRSC-482: Running command: '/u01/app/19.0.0/grid/bin/crsctl set crs activeversion'
Started to upgrade the active version of Oracle Clusterware. This operation may take a few minutes.
Started to upgrade CSS.
CSS was successfully upgraded.
Started to upgrade Oracle ASM.
Started to upgrade CRS.
CRS was successfully upgraded.
Started to upgrade Oracle ACFS.
Oracle ACFS was successfully upgraded.
Successfully upgraded the active version of Oracle Clusterware.
Oracle Clusterware active version was successfully set to 19.0.0.0.0.
2020/08/09 21:03:58 CLSRSC-479: Successfully set Oracle Clusterware active version
2020/08/09 21:03:59 CLSRSC-476: Finishing upgrade of resource types
2020/08/09 21:04:03 CLSRSC-477: Successfully completed upgrade of resource types
2020/08/09 21:04:20 CLSRSC-595: Executing upgrade step 18 of 18: 'PostUpgrade'.
Successfully updated XAG resources.
2020/08/09 21:04:34 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
You have new mail in /var/spool/mail/root
[root@msdbadmdb08 tmp]# 

 

 

Oracle 19c Grid Infrastructure Upgrade is completed like following.

 

 

 

 

 

 

You can read the following post to learn Oracle 18c Grid Infrastructure Upgrade.

Oracle Grid Infrastructure & RAC Upgrade from Oracle 12c to Oracle 18c in Full Rack Exadata X7 Step by Step -1 Patch 27006180 Apply and 24600431 Patch Rollback 

 

 

You can read the following post to learn how to upgrade Oracle database.

Oracle Database Upgrade Guide and How to Upgrade Oracle Database

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *

Powered by IT Tutorial | Designed by SysDBASoft IT
IT Tutorial © Copyright 2024, All Rights Reserved