oracle_grid_sa_upgrade_scndnode

Overview

Upgrading the 2nd node took me significantly less time, since the Second Node had to just connect to the already existing cluster. Therefore, no GUI was needed here and only the rootupgrade.sh was needed:

[root@lparacb grid_12201]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.DATA.dg    ora....up.type ONLINE    ONLINE    lparaca
ora....ER.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N1.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N2.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora....N3.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    lparacb
ora.asm        ora.asm.type   ONLINE    ONLINE    lparaca
ora....SM1.asm application    ONLINE    ONLINE    lparaca
ora....CA.lsnr application    ONLINE    ONLINE    lparaca
ora....aca.ons application    ONLINE    ONLINE    lparaca
ora....aca.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....SM2.asm application    ONLINE    ONLINE    lparacb
ora....CB.lsnr application    ONLINE    ONLINE    lparacb
ora....acb.ons application    ONLINE    ONLINE    lparacb
ora....acb.vip ora....t1.type ONLINE    ONLINE    lparacb
ora.mgmtdb     ora....db.type ONLINE    ONLINE    lparacb
ora....network ora....rk.type ONLINE    ONLINE    lparaca
ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE
ora.ons        ora.ons.type   ONLINE    ONLINE    lparaca
ora....est.svc ora....ce.type ONLINE    ONLINE    lparacb
ora.orcl.db    ora....se.type ONLINE    ONLINE    lparaca
ora.qosmserver ora....er.type OFFLINE   OFFLINE
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    lparacb
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    lparacb
[root@lparacb grid_12201]# ./rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/grid_12201

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]:
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/oracle/grid_12201/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/oracle/product/crsdata/lparacb/crsconfig/rootcrs_lparacb_2018-01-21_01-48-29PM.log
2018/01/21 13:49:20 CLSRSC-595: Executing upgrade step 1 of 19: 'UpgradeTFA'.
2018/01/21 13:49:21 CLSRSC-4015: Performing install or upgrade action for Oracle Trace File Analyzer (TFA) Collector.
2018/01/21 13:50:26 CLSRSC-4003: Successfully patched Oracle Trace File Analyzer (TFA) Collector.
2018/01/21 13:50:26 CLSRSC-595: Executing upgrade step 2 of 19: 'ValidateEnv'.
2018/01/21 13:50:32 CLSRSC-595: Executing upgrade step 3 of 19: 'GenSiteGUIDs'.
2018/01/21 13:50:33 CLSRSC-595: Executing upgrade step 4 of 19: 'GetOldConfig'.
2018/01/21 13:50:33 CLSRSC-464: Starting retrieval of the cluster configuration data
2018/01/21 13:50:44 CLSRSC-465: Retrieval of the cluster configuration data has successfully completed.
2018/01/21 13:50:44 CLSRSC-595: Executing upgrade step 5 of 19: 'UpgPrechecks'.
2018/01/21 13:50:44 CLSRSC-363: User ignored prerequisites during installation
2018/01/21 13:50:45 CLSRSC-595: Executing upgrade step 6 of 19: 'SaveParamFile'.
2018/01/21 13:50:47 CLSRSC-595: Executing upgrade step 7 of 19: 'SetupOSD'.
2018/01/21 13:50:48 CLSRSC-595: Executing upgrade step 8 of 19: 'PreUpgrade'.

ASM configuration upgraded in local node successfully.

2018/01/21 13:50:56 CLSRSC-466: Starting shutdown of the current Oracle Grid Infrastructure stack
2018/01/21 13:52:13 CLSRSC-467: Shutdown of the current Oracle Grid Infrastructure stack has successfully completed.
2018/01/21 13:52:20 CLSRSC-595: Executing upgrade step 9 of 19: 'CheckCRSConfig'.
2018/01/21 13:52:22 CLSRSC-595: Executing upgrade step 10 of 19: 'UpgradeOLR'.
2018/01/21 13:52:25 CLSRSC-595: Executing upgrade step 11 of 19: 'ConfigCHMOS'.
2018/01/21 13:52:25 CLSRSC-595: Executing upgrade step 12 of 19: 'InstallAFD'.
2018/01/21 13:52:26 CLSRSC-595: Executing upgrade step 13 of 19: 'createOHASD'.
2018/01/21 13:52:27 CLSRSC-595: Executing upgrade step 14 of 19: 'ConfigOHASD'.
2018/01/21 13:52:42 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2018/01/21 13:53:01 CLSRSC-595: Executing upgrade step 15 of 19: 'InstallACFS'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'lparacb'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'lparacb' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Oracle High Availability Services has been started.
2018/01/21 13:53:27 CLSRSC-595: Executing upgrade step 16 of 19: 'InstallKA'.
2018/01/21 13:53:28 CLSRSC-595: Executing upgrade step 17 of 19: 'UpgradeCluster'.
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'lparacb'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'lparacb' has completed
CRS-4133: Oracle High Availability Services has been stopped.
CRS-4123: Starting Oracle High Availability Services-managed resources
CRS-2672: Attempting to start 'ora.mdnsd' on 'lparacb'
CRS-2672: Attempting to start 'ora.evmd' on 'lparacb'
CRS-2676: Start of 'ora.evmd' on 'lparacb' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'lparacb'
CRS-2676: Start of 'ora.gpnpd' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'lparacb'
CRS-2676: Start of 'ora.gipcd' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'lparacb'
CRS-2676: Start of 'ora.cssdmonitor' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'lparacb'
CRS-2672: Attempting to start 'ora.diskmon' on 'lparacb'
CRS-2676: Start of 'ora.diskmon' on 'lparacb' succeeded
CRS-2676: Start of 'ora.cssd' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'lparacb'
CRS-2672: Attempting to start 'ora.ctssd' on 'lparacb'
CRS-2676: Start of 'ora.ctssd' on 'lparacb' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'lparacb'
CRS-2676: Start of 'ora.asm' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.storage' on 'lparacb'
CRS-2676: Start of 'ora.storage' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.crf' on 'lparacb'
CRS-2676: Start of 'ora.crf' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'lparacb'
CRS-2676: Start of 'ora.crsd' on 'lparacb' succeeded
CRS-6023: Starting Oracle Cluster Ready Services-managed resources
CRS-6017: Processing resource auto-start for servers: lparacb
CRS-2672: Attempting to start 'ora.ons' on 'lparacb'
CRS-2673: Attempting to stop 'ora.lparacb.vip' on 'lparaca'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'lparaca'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'lparaca' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'lparaca'
CRS-2677: Stop of 'ora.lparacb.vip' on 'lparaca' succeeded
CRS-2672: Attempting to start 'ora.lparacb.vip' on 'lparacb'
CRS-2677: Stop of 'ora.scan1.vip' on 'lparaca' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'lparacb'
CRS-2676: Start of 'ora.lparacb.vip' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'lparacb'
CRS-2676: Start of 'ora.scan1.vip' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'lparacb'
CRS-2676: Start of 'ora.ons' on 'lparacb' succeeded
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'lparacb'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'lparacb' succeeded
CRS-2676: Start of 'ora.asm' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'lparacb'
CRS-2676: Start of 'ora.DATA.dg' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.orcl.db' on 'lparacb'
CRS-2676: Start of 'ora.orcl.db' on 'lparacb' succeeded
CRS-2672: Attempting to start 'ora.orcl.actest.svc' on 'lparacb'
CRS-2676: Start of 'ora.orcl.actest.svc' on 'lparacb' succeeded
CRS-6016: Resource auto-start has completed for server lparacb
CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources
CRS-4123: Oracle High Availability Services has been started.
2018/01/21 13:56:29 CLSRSC-343: Successfully started Oracle Clusterware stack
clscfg: EXISTING configuration version 5 detected.
clscfg: version 5 is 12c Release 2.
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.
2018/01/21 13:57:56 CLSRSC-595: Executing upgrade step 18 of 19: 'UpgradeNode'.
Start upgrade invoked..
2018/01/21 13:58:18 CLSRSC-478: Setting Oracle Clusterware active version on the last node to be upgraded
2018/01/21 13:58:18 CLSRSC-482: Running command: '/u01/app/oracle/grid_12201/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.
Successfully upgraded the active version of Oracle Clusterware.
Oracle Clusterware active version was successfully set to 12.2.0.1.0.
2018/01/21 14:00:00 CLSRSC-479: Successfully set Oracle Clusterware active version
2018/01/21 14:00:15 CLSRSC-476: Finishing upgrade of resource types
2018/01/21 14:01:02 CLSRSC-482: Running command: 'srvctl upgrade model -s 12.1.0.2.0 -d 12.2.0.1.0 -p last'
2018/01/21 14:01:02 CLSRSC-477: Successfully completed upgrade of resource types
2018/01/21 14:01:48 CLSRSC-595: Executing upgrade step 19 of 19: 'PostUpgrade'.
2018/01/21 14:02:13 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@lparacb grid_12201]#
[root@lparacb grid_12201]#
[root@lparacb grid_12201]# crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.DATA.dg    ora....up.type ONLINE    ONLINE    lparaca
ora....ER.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N1.lsnr ora....er.type ONLINE    ONLINE    lparacb
ora....N2.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora....N3.lsnr ora....er.type ONLINE    ONLINE    lparaca
ora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    lparaca
ora.asm        ora.asm.type   ONLINE    ONLINE    lparaca
ora.cvu        ora.cvu.type   ONLINE    ONLINE    lparacb
ora....SM1.asm application    ONLINE    ONLINE    lparaca
ora....CA.lsnr application    ONLINE    ONLINE    lparaca
ora....aca.ons application    ONLINE    ONLINE    lparaca
ora....aca.vip ora....t1.type ONLINE    ONLINE    lparaca
ora....SM2.asm application    ONLINE    OFFLINE
ora....CB.lsnr application    ONLINE    ONLINE    lparacb
ora....acb.ons application    ONLINE    ONLINE    lparacb
ora....acb.vip ora....t1.type ONLINE    ONLINE    lparacb
ora.mgmtdb     ora....db.type ONLINE    OFFLINE
ora....network ora....rk.type ONLINE    ONLINE    lparaca
ora.ons        ora.ons.type   ONLINE    ONLINE    lparaca
ora....est.svc ora....ce.type ONLINE    ONLINE    lparacb
ora.orcl.db    ora....se.type ONLINE    ONLINE    lparaca
ora.qosmserver ora....er.type ONLINE    ONLINE    lparacb
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    lparacb
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    lparaca
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    lparaca

Don't forget to remove the MGMTDB (for 12.2.0.1) and onwards:

[root@lparacb grid_12201]#srvctl remove mgmtdb
Remove the database _mgmtdb? (y/[n]) y
[root@lparacb grid_12201]# srvctl remove mgmtlsnr
[root@lparacb grid_12201]#

  • oracle_grid_sa_upgrade_scndnode.txt
  • Last modified: 2019/10/18 20:04
  • by 127.0.0.1