Upgrading Oracle Restart from 19c to 21c on centos 8.5

Upgrading Oracle Restart from 19c to 21c on centos 8.5  ======================================== To check resource crsctl status res | awk -F= '/NAME=/{n=$2}/TYPE=/{t=$2}/TARGET=/{g=$2}/STATE=/{s=$2; printf("%-60s%-30s%-10s%-30s\n", n,t,g,s)}'   ora.DATA.dg                                                 ora.diskgroup.type            ONLINE    ONLINE on oragrid ora.LISTENER.lsnr                                           ora.listener.type             ONLINE    ONLINE on oragrid ora.asm                                                     ora.asm.type                  ONLINE    ONLINE on oragrid ora.cssd                                                    ora.cssd.type                 ONLINE    ONLINE on oragrid ora.diskmon                                                 ora.diskmon.type              OFFLINE   OFFLINE ora.evmd                                                    ora.evm.type                  ONLINE    ONLINE on oragrid ora.ons                                                     ora.ons.type                  OFFLINE   OFFLINE   [grid@oragrid ~]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [19.0.0.0.0]   [grid@oragrid ~]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [19.0.0.0.0] [grid@oragrid ~]$   Download   LINUX.X64_213000_grid_home.zip   mkdir -p /u01/app/21.3.0/grid   [grid@oragrid ~]$ cd /u01/app/21.3.0/grid/ [grid@oragrid grid]$ pwd /u01/app/21.3.0/grid [grid@oragrid grid]$ unzip -oq /home/grid/LINUX.X64_213000_grid_home.zip    ./runcluvfy.sh stage -pre hacfg   This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Physical Memory ...FAILED (PRVF-7530)   Available Physical Memory ...PASSED   Swap Size ...PASSED   Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED   User Existence: grid ...     Users With Same UID: 1100 ...PASSED   User Existence: grid ...PASSED   Group Existence: dba ...PASSED   Group Existence: oinstall ...PASSED   Group Membership: dba ...FAILED (PRVG-10460)   Group Membership: oinstall(Primary) ...PASSED   Run Level ...PASSED   Architecture ...PASSED   OS Kernel Version ...PASSED   OS Kernel Parameter: semmsl ...PASSED   OS Kernel Parameter: semmns ...PASSED   OS Kernel Parameter: semopm ...PASSED   OS Kernel Parameter: semmni ...PASSED   OS Kernel Parameter: shmmax ...PASSED   OS Kernel Parameter: shmmni ...PASSED   OS Kernel Parameter: shmall ...PASSED   OS Kernel Parameter: file-max ...PASSED   OS Kernel Parameter: ip_local_port_range ...PASSED   OS Kernel Parameter: rmem_default ...PASSED   OS Kernel Parameter: rmem_max ...PASSED   OS Kernel Parameter: wmem_default ...PASSED   OS Kernel Parameter: wmem_max ...PASSED   OS Kernel Parameter: aio-max-nr ...PASSED   OS Kernel Parameter: panic_on_oops ...PASSED   Package: kmod-20-21 (x86_64) ...PASSED   Package: kmod-libs-20-21 (x86_64) ...PASSED   Package: binutils-2.30-49.0.2 ...PASSED   Package: libgcc-8.2.1 (x86_64) ...PASSED   Package: libstdc++-8.2.1 (x86_64) ...PASSED   Package: sysstat-10.1.5 ...PASSED   Package: ksh ...PASSED   Package: make-4.2.1 ...PASSED   Package: glibc-2.28 (x86_64) ...PASSED   Package: glibc-devel-2.28 (x86_64) ...PASSED   Package: libaio-0.3.110 (x86_64) ...PASSED   Package: nfs-utils-2.3.3-14 ...PASSED   Package: smartmontools-6.6-3 ...PASSED   Package: net-tools-2.0-0.51 ...PASSED   Package: policycoreutils-2.9-3 ...PASSED   Package: policycoreutils-python-utils-2.9-3 ...PASSED   Users With Same UID: 0 ...PASSED   Current Group ID ...PASSED   Root user consistency ...PASSED   Pre-check for Oracle Restart configuration was unsuccessful.     Failures were encountered during execution of CVU verification request "stage -pre hacfg".   Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node          "oragrid" [Required physical memory = 8GB (8388608.0KB)]   Group Membership: dba ...FAILED oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for          privileges "OSDBA" on node "oragrid".     CVU operation performed:      stage -pre hacfg Date:                         12-Dec-2024 13:06:32 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/19.2.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$       *******************************     oragrid: PRVG-10460 : User "grid" does not belong to group "dba" selected for  privileges "OSDBA" on node "oragrid".      cat /etc/group|grep -i grid dba:x:54322:grid  <<<<<--- add grid into dba group asmdba:x:54327:grid asmoper:x:54328:grid asmadmin:x:54329:grid   ********************************       ./runcluvfy.sh stage -pre hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Physical Memory ...FAILED (PRVF-7530)   Available Physical Memory ...PASSED   Swap Size ...PASSED   Free Space: oragrid:/usr,oragrid:/var,oragrid:/etc,oragrid:/sbin,oragrid:/tmp ...PASSED   User Existence: grid ...     Users With Same UID: 1100 ...PASSED   User Existence: grid ...PASSED   Group Existence: dba ...PASSED   Group Existence: oinstall ...PASSED   Group Membership: dba ...PASSED   Group Membership: oinstall(Primary) ...PASSED   Run Level ...PASSED   Architecture ...PASSED   OS Kernel Version ...PASSED   OS Kernel Parameter: semmsl ...PASSED   OS Kernel Parameter: semmns ...PASSED   OS Kernel Parameter: semopm ...PASSED   OS Kernel Parameter: semmni ...PASSED   OS Kernel Parameter: shmmax ...PASSED   OS Kernel Parameter: shmmni ...PASSED   OS Kernel Parameter: shmall ...PASSED   OS Kernel Parameter: file-max ...PASSED   OS Kernel Parameter: ip_local_port_range ...PASSED   OS Kernel Parameter: rmem_default ...PASSED   OS Kernel Parameter: rmem_max ...PASSED   OS Kernel Parameter: wmem_default ...PASSED   OS Kernel Parameter: wmem_max ...PASSED   OS Kernel Parameter: aio-max-nr ...PASSED   OS Kernel Parameter: panic_on_oops ...PASSED   Package: kmod-20-21 (x86_64) ...PASSED   Package: kmod-libs-20-21 (x86_64) ...PASSED   Package: binutils-2.30-49.0.2 ...PASSED   Package: libgcc-8.2.1 (x86_64) ...PASSED   Package: libstdc++-8.2.1 (x86_64) ...PASSED   Package: sysstat-10.1.5 ...PASSED   Package: ksh ...PASSED   Package: make-4.2.1 ...PASSED   Package: glibc-2.28 (x86_64) ...PASSED   Package: glibc-devel-2.28 (x86_64) ...PASSED   Package: libaio-0.3.110 (x86_64) ...PASSED   Package: nfs-utils-2.3.3-14 ...PASSED   Package: smartmontools-6.6-3 ...PASSED   Package: net-tools-2.0-0.51 ...PASSED   Package: policycoreutils-2.9-3 ...PASSED   Package: policycoreutils-python-utils-2.9-3 ...PASSED   Users With Same UID: 0 ...PASSED   Current Group ID ...PASSED   Root user consistency ...PASSED   Pre-check for Oracle Restart configuration was unsuccessful.     Failures were encountered during execution of CVU verification request "stage -pre hacfg".   Physical Memory ...FAILED oragrid: PRVF-7530 : Sufficient physical memory is not available on node          "oragrid" [Required physical memory = 8GB (8388608.0KB)]     CVU operation performed:      stage -pre hacfg Date:                         12-Dec-2024 13:24:10 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/19.2.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$         unset ORACLE_HOME unset ORACLE_BASE unset ORACLE_SID   [grid@oragrid grid]$ export CV_ASSUME_DISTID=OEL7.8 [grid@oragrid grid]$ ./gridSetup.sh & [1] 11065 [grid@oragrid grid]$ ERROR: Unable to verify the graphical display setup. This application requires X display. Make sure that xdpyinfo exist under PATH variable. Launching Oracle Grid Infrastructure Setup Wizard...   The response file for this session can be found at:  /u01/app/21.3.0/grid/install/response/grid_2024-12-12_03-04-14PM.rsp   You can find the log of this install session at:  /u01/app/oraInventory/logs/GridSetupActions2024-12-12_03-04-14PM/gridSetupActions2024-12-12_03-04-14PM.log         [root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh Performing root user operation.   The following environment variables are set as:     ORACLE_OWNER= grid     ORACLE_HOME=  /u01/app/21.3.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 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: /u01/app/21.3.0/grid/crs/install/crsconfig_params The log of current session can be found at:   /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log 2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'. 2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'. 2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'. Redirecting to /bin/systemctl restart rsyslog.service 2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'. 2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'. 2024/12/12 15:18:18 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. 2024/12/12 15:18:23 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 oragrid successfully pinned. 2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'. 2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'. 2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service' 2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.   oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0   oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844 2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'. 2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server [root@oragrid ~]#       [grid@oragrid grid]$ crsctl query has releaseversion Oracle High Availability Services release version on the local node is [21.0.0.0.0] [grid@oragrid grid]$ crsctl query has softwareversion Oracle High Availability Services version on the local node is [21.0.0.0.0] [grid@oragrid grid]$     [grid@oragrid grid]$ $ORACLE_HOME/OPatch/opatch lspatches There are no Interim patches installed in this Oracle Home "/u01/app/21.3.0/grid".   OPatch succeeded. [grid@oragrid grid]$   ====   [1]+  Done                    ./gridSetup.sh [grid@oragrid grid]$       [grid@oragrid grid]$ cluvfy stage -post hacfg This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.   Performing following verification checks ...     Oracle Restart Integrity ...PASSED   OLR Integrity ...PASSED   Post-check for Oracle Restart configuration was successful.   CVU operation performed:      stage -post hacfg Date:                         12-Dec-2024 15:28:01 CVU home:                     /u01/app/21.3.0/grid Grid home:                    /u01/app/21.3.0/grid User:                         grid Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64 [grid@oragrid grid]$

 

[root@oragrid ~]# /u01/app/21.3.0/grid/rootupgrade.sh

Performing root user operation.

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/21.3.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 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: /u01/app/21.3.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/oragrid/crsconfig/roothas_2024-12-12_03-17-27PM.log

2024/12/12 15:17:30 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.

2024/12/12 15:17:36 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.

2024/12/12 15:17:40 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.

Redirecting to /bin/systemctl restart rsyslog.service

2024/12/12 15:17:41 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.

2024/12/12 15:18:18 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.

2024/12/12 15:18:18 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.

2024/12/12 15:18:23 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 oragrid successfully pinned.

2024/12/12 15:18:27 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.

2024/12/12 15:18:29 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.

2024/12/12 15:18:29 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'

2024/12/12 15:18:48 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

oragrid     2024/12/12 15:19:45     /u01/app/grid/crsdata/oragrid/olr/backup_20241212_151945.olr     0

oragrid     2024/12/10 15:51:48     /u01/app/grid/crsdata/oragrid/olr/backup_20241210_155148.olr     724960844

2024/12/12 15:19:45 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.

2024/12/12 15:20:51 CLSRSC-327: Successfully configured Oracle Restart for a standalone server

[root@oragrid ~]#

[grid@oragrid grid]$ crsctl query has releaseversion

Oracle High Availability Services release version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$ crsctl query has softwareversion

Oracle High Availability Services version on the local node is [21.0.0.0.0]

[grid@oragrid grid]$

[grid@oragrid grid]$ cluvfy stage -post hacfg

This standalone version of CVU is "1253" days old. The latest release of standalone CVU can be obtained from the Oracle support site. Refer to MOS note 2731675.1 for more details.

Performing following verification checks ...

  Oracle Restart Integrity ...PASSED

  OLR Integrity ...PASSED

Post-check for Oracle Restart configuration was successful.

CVU operation performed:      stage -post hacfg

Date:                         12-Dec-2024 15:28:01

CVU home:                     /u01/app/21.3.0/grid

Grid home:                    /u01/app/21.3.0/grid

User:                         grid

Operating system:             Linux4.18.0-348.7.1.el8_5.x86_64

[grid@oragrid grid]$