Advertisement

Wednesday, February 27, 2019

Oracle Database 19c : GI Upgrade (from 18c) - 2 Nodes Cluster - Part 2/2

In this blog, I pickup from my last blog where I had done all the pre-reqs successfully. 

In this blog we will be doing the real upgrade. 

Connect using user - grid (make sure 'X' is enabled and you use 'X' server - I prefer MobaXterm)



$ cd /u01/app/190/grid
$ ./gridSetup.sh
Launching Oracle Grid Infrastructure Setup Wizard...

Step 1  - Select "Upgrade Oracle Grid Infrastructure" and Click "Next"



Step 2 - Select Nodes "Do not select - Skip upgrade on unreachable nodes and " Click "Next"


Step 3 - Skip EM Registeration Check - Do this after installation and Click "Next"

Step 4 - Select oracle base - generally it is populated correctly


Step 5 - Un-check Root Script Execution - We will do this manually. Click "Next"



Step  6 - RPM DB checks can be ignored (this is probably due to this GI version is specific to Exadata - I am still not sure but a confirmation will come when official normal Linux release will be done. by Oracle). Click "Next" and "Yes" when Prompted



Step 7 -  Click Submit to continue


Step 8 - Wait for the operations to complete






Step 8.1 - Execute the Root Scripts (1 by 1 on both nodes)
First on Node 1 (where Installer is running and then on node 2)
Node 1 - 
$ /u01/app/190/grid/rootupgrade.sh

Node 2 
$ /u01/app/190/grid/rootupgrade.sh

Step 8.2 - Click "OK" after root script execution is complete
The Complete output of the root scripts is in the last. 


Step 9 - Wait for the Config tools and post upgrade to complete. 



Step 10 - Click Close to Complete the installation. 




Verify the Cluster Version
[As root]
$ /u01/app/190/grid/bin/crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [19.0.0.0.0]


Note - if you had made any entries in /etc/oratab - Correct them to point to new homes respectively for ASM,APX and MGMT DB. 


Root Scripts Output
Node 1 

$ /u01/app/190/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/190/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/190/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/rac18c01/crsconfig/rootcrs_rac18c01_2019-02-27_09-28-36PM.log
2019/02/27 21:28:53 CLSRSC-595: Executing upgrade step 1 of 18: 'UpgradeTFA'.
2019/02/27 21:28:53 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2019/02/27 21:28:53 CLSRSC-595: Executing upgrade step 2 of 18: 'ValidateEnv'.
2019/02/27 21:28:58 CLSRSC-595: Executing upgrade step 3 of 18: 'GetOldConfig'.
2019/02/27 21:28:58 CLSRSC-464: Starting retrieval of the cluster configuration data
2019/02/27 21:29:04 CLSRSC-692: Checking whether CRS entities are ready for upgrade. This operation may take a few minutes.
2019/02/27 21:30:38 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2019/02/27 21:30:45 CLSRSC-693: CRS entities validation completed successfully.
2019/02/27 21:30:50 CLSRSC-515: Starting OCR manual backup.
2019/02/27 21:31:06 CLSRSC-516: OCR manual backup successful.
2019/02/27 21:33:08 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.
2019/02/27 21:33:08 CLSRSC-541:
 To downgrade the cluster:
 1. All nodes that have been upgraded must be downgraded.
2019/02/27 21:33:08 CLSRSC-542:
 2. Before downgrading the last node, the Grid Infrastructure stack on all other cluster nodes must be down.
2019/02/27 21:33:16 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2019/02/27 21:33:16 CLSRSC-595: Executing upgrade step 4 of 18: 'GenSiteGUIDs'.
2019/02/27 21:33:18 CLSRSC-595: Executing upgrade step 5 of 18: 'UpgPrechecks'.
2019/02/27 21:33:21 CLSRSC-363: User ignored prerequisites during installation
2019/02/27 21:33:34 CLSRSC-595: Executing upgrade step 6 of 18: 'SetupOSD'.
2019/02/27 21:33:34 CLSRSC-595: Executing upgrade step 7 of 18: 'PreUpgrade'.
2019/02/27 21:36:32 CLSRSC-468: Setting Oracle Clusterware and ASM to rolling migration mode
2019/02/27 21:36:32 CLSRSC-482: Running command: '/u01/app/180/grid/bin/crsctl start rollingupgrade 19.0.0.0.0'
CRS-1131: The cluster was successfully set to rolling upgrade mode.
2019/02/27 21:36:37 CLSRSC-482: Running command: '/u01/app/190/grid/bin/asmca -silent -upgradeNodeASM -nonRolling false -oldCRSHome /u01/app/180/grid -oldCRSVersion 18.0.0.0.0 -firstNode true -startRolling false '

ASM configuration upgraded in local node successfully.

2019/02/27 21:36:41 CLSRSC-469: Successfully set Oracle Clusterware and ASM to rolling migration mode
2019/02/27 21:36:46 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2019/02/27 21:37:08 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2019/02/27 21:37:09 CLSRSC-595: Executing upgrade step 8 of 18: 'CheckCRSConfig'.
2019/02/27 21:37:11 CLSRSC-595: Executing upgrade step 9 of 18: 'UpgradeOLR'.
2019/02/27 21:37:20 CLSRSC-595: Executing upgrade step 10 of 18: 'ConfigCHMOS'.
2019/02/27 21:37:20 CLSRSC-595: Executing upgrade step 11 of 18: 'UpgradeAFD'.
2019/02/27 21:37:27 CLSRSC-595: Executing upgrade step 12 of 18: 'createOHASD'.
2019/02/27 21:37:34 CLSRSC-595: Executing upgrade step 13 of 18: 'ConfigOHASD'.
2019/02/27 21:37:34 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2019/02/27 21:39:34 CLSRSC-595: Executing upgrade step 14 of 18: 'InstallACFS'.
2019/02/27 21:42:03 CLSRSC-595: Executing upgrade step 15 of 18: 'InstallKA'.
2019/02/27 21:42:09 CLSRSC-595: Executing upgrade step 16 of 18: 'UpgradeCluster'.
2019/02/27 21:43:30 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.
2019/02/27 21:43:50 CLSRSC-595: Executing upgrade step 17 of 18: 'UpgradeNode'.
2019/02/27 21:43:54 CLSRSC-474: Initiating upgrade of resource types
2019/02/27 21:44:47 CLSRSC-475: Upgrade of resource types successfully initiated.
2019/02/27 21:44:57 CLSRSC-595: Executing upgrade step 18 of 18: 'PostUpgrade'.
2019/02/27 21:45:05 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded


Node 2 
$ /u01/app/190/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/190/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/190/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/grid/crsdata/rac18c02/crsconfig/rootcrs_rac18c02_2019-02-27_09-46-43PM.log
2019/02/27 21:46:52 CLSRSC-595: Executing upgrade step 1 of 18: 'UpgradeTFA'.
2019/02/27 21:46:52 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2019/02/27 21:46:52 CLSRSC-595: Executing upgrade step 2 of 18: 'ValidateEnv'.
2019/02/27 21:46:53 CLSRSC-595: Executing upgrade step 3 of 18: 'GetOldConfig'.
2019/02/27 21:46:53 CLSRSC-464: Starting retrieval of the cluster configuration data
2019/02/27 21:48:23 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2019/02/27 21:48:23 CLSRSC-595: Executing upgrade step 4 of 18: 'GenSiteGUIDs'.
2019/02/27 21:48:23 CLSRSC-595: Executing upgrade step 5 of 18: 'UpgPrechecks'.
2019/02/27 21:48:24 CLSRSC-363: User ignored prerequisites during installation
2019/02/27 21:48:26 CLSRSC-595: Executing upgrade step 6 of 18: 'SetupOSD'.
2019/02/27 21:48:26 CLSRSC-595: Executing upgrade step 7 of 18: 'PreUpgrade'.
2019/02/27 21:48:49 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.

ASM configuration upgraded in local node successfully.

2019/02/27 21:49:56 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2019/02/27 21:50:27 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2019/02/27 21:51:48 CLSRSC-595: Executing upgrade step 8 of 18: 'CheckCRSConfig'.
2019/02/27 21:51:49 CLSRSC-595: Executing upgrade step 9 of 18: 'UpgradeOLR'.
2019/02/27 21:51:54 CLSRSC-595: Executing upgrade step 10 of 18: 'ConfigCHMOS'.
2019/02/27 21:51:54 CLSRSC-595: Executing upgrade step 11 of 18: 'UpgradeAFD'.
2019/02/27 21:51:56 CLSRSC-595: Executing upgrade step 12 of 18: 'createOHASD'.
2019/02/27 21:51:57 CLSRSC-595: Executing upgrade step 13 of 18: 'ConfigOHASD'.
2019/02/27 21:51:57 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2019/02/27 21:53:39 CLSRSC-595: Executing upgrade step 14 of 18: 'InstallACFS'.
2019/02/27 21:55:52 CLSRSC-595: Executing upgrade step 15 of 18: 'InstallKA'.
2019/02/27 21:55:53 CLSRSC-595: Executing upgrade step 16 of 18: 'UpgradeCluster'.
2019/02/27 21:57:17 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.
2019/02/27 21:58:52 CLSRSC-595: Executing upgrade step 17 of 18: 'UpgradeNode'.
Start upgrade invoked..
2019/02/27 21:58:57 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2019/02/27 21:58:57 CLSRSC-482: Running command: '/u01/app/190/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.
2019/02/27 22:00:09 CLSRSC-479: Successfully set Oracle Clusterware active version
2019/02/27 22:00:12 CLSRSC-476: Finishing upgrade of resource types
2019/02/27 22:00:41 CLSRSC-477: Successfully completed upgrade of resource types
2019/02/27 22:01:04 CLSRSC-595: Executing upgrade step 18 of 18: 'PostUpgrade'.
Successfully updated XAG resources.
2019/02/27 22:01:26 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

No comments:
Write comments