################################################################################## # #Node 01 # ################################################################################## [root@oel8n1-21c ~]# uname -a Linux oel8n1-21c.oralocal 5.4.17-2102.201.3.el8uek.x86_64 #2 SMP Fri Apr 23 09:05:57 PDT 2021 x86_64 x86_64 x86_64 GNU/Linux [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# su - grid [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ olsnodes oel8n1-21c oel8n2-21c [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ sqlplus / as sysasm SQL*Plus: Release 21.0.0.0.0 - Production on Sat Mar 12 17:55:18 2022 Version 21.3.0.0.0 Copyright (c) 1982, 2021, Oracle. All rights reserved. Connected to: Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 SQL> SQL> set linesize 255 SQL> col name format a40 SQL> col value format a40 SQL> SELECT group_number, name, value FROM v$asm_attribute where name like '%compat%' order by name, GROUP_NUMBER; GROUP_NUMBER NAME VALUE ------------ ---------------------------------------- ---------------------------------------- 1 compatible.advm 21.0.0.0.0 2 compatible.advm 21.0.0.0.0 3 compatible.advm 21.0.0.0.0 1 compatible.asm 21.0.0.0.0 2 compatible.asm 21.0.0.0.0 3 compatible.asm 21.0.0.0.0 1 compatible.patch.asm.containerparity ENABLED 2 compatible.patch.asm.containerparity ENABLED 3 compatible.patch.asm.containerparity ENABLED 1 compatible.patch.asm.doubleparity ENABLED 2 compatible.patch.asm.doubleparity ENABLED GROUP_NUMBER NAME VALUE ------------ ---------------------------------------- ---------------------------------------- 3 compatible.patch.asm.doubleparity ENABLED 1 compatible.rdbms 10.1.0.0.0 2 compatible.rdbms 10.1.0.0.0 3 compatible.rdbms 10.1.0.0.0 15 rows selected. SQL> col name format a20 SQL> col COMPATIBILITY format a10 SQL> col DATABASE_COMPATIBILITY format a15 SQL> select GROUP_NUMBER,NAME,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup; GROUP_NUMBER NAME COMPATIBIL DATABASE_COMPAT ------------ -------------------- ---------- --------------- 1 DATA 21.0.0.0.0 10.1.0.0.0 2 RECO 21.0.0.0.0 10.1.0.0.0 3 SYSTEMDG 21.0.0.0.0 10.1.0.0.0 SQL> SQL> exit Disconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 [grid@oel8n1-21c ~]$ [root@oel8n1-21c ~]$ [root@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 12.2.0.1.26 Copyright (c) 2022, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/21.0.0.0/grid Central Inventory : /u01/app/oraInventory from : /u01/app/21.0.0.0/grid/oraInst.loc OPatch version : 12.2.0.1.26 OUI version : 12.2.0.9.0 Log file location : /u01/app/21.0.0.0/grid/cfgtoollogs/opatch/opatch2022-03-12_17-56-48PM_1.log Lsinventory Output file location : /u01/app/21.0.0.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2022-03-12_17-56-48PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: oel8n1-21c.oralocal ARU platform id: 226 ARU platform description:: Linux x86-64 Installed Top-level Products (1): Oracle Grid Infrastructure 21c 21.0.0.0.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded. [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ crsctl query crs activeversion -f Oracle Clusterware active version on the cluster is [21.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0]. [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs activeversion -f Oracle Clusterware active version on the cluster is [21.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0]. [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs releasepatch Oracle Clusterware release patch level is [0] and no patches have been applied on the local node. The release patch string is [21.3.0.0.0]. [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs softwarepatch Oracle Clusterware patch level on node oel8n1-21c is [0]. [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /u01/app/21.0.0.0/grid/bin/kfod op=patches --------------- List of Patches =============== [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /u01/app/21.0.0.0/grid/bin/kfod op=patchlvl ------------------- Current Patch level =================== 0 [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ /opt/oracle.ahf/bin/tfactl -version TFA Version : 214200 TFA Build ID : 20220211135650 [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ [grid@oel8n1-21c ~]$ exit logout [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# su - oracle [oracle@oel8n1-21c ~]$ [oracle@oel8n1-21c ~]$ export ORACLE_HOME=/u01/app/oracle/product/21.5.0.0/dbhome_1 [oracle@oel8n1-21c ~]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH [oracle@oel8n1-21c ~]$ [oracle@oel8n1-21c ~]$ opatch lspatches 33531707;OCW RELEASE UPDATE 21.5.0.0.0 (33531707) 33516412;Database Release Update : 21.5.0.0.220118 (33516412) OPatch succeeded. [oracle@oel8n1-21c ~]$ [oracle@oel8n1-21c ~]$ srvctl status database -d orcl21c Instance orcl21c1 is running on node oel8n1-21c Instance orcl21c2 is running on node oel8n2-21c [oracle@oel8n1-21c ~]$ [oracle@oel8n1-21c ~]$ logout [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# grub2-editenv - list | grep kernelopts kernelopts=root=/dev/mapper/ol-root ro resume=/dev/mapper/ol-swap rd.lvm.lv=ol/root rd.lvm.lv=ol/swap transparent_hugepage=never [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# cat /sys/kernel/mm/transparent_hugepage/enabled always madvise [never] [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# grep AnonHugePages /proc/meminfo AnonHugePages: 0 kB [root@oel8n1-21c ~]# [root@oel8n1-21c ~]# grep HugePages /proc/meminfo AnonHugePages: 0 kB ShmemHugePages: 0 kB FileHugePages: 0 kB HugePages_Total: 1280 HugePages_Free: 514 HugePages_Rsvd: 3 HugePages_Surp: 0 [root@oel8n1-21c ~]# ################################################################################## # #Node 02 # ################################################################################## [root@oel8n2-21c ~]# uname -a Linux oel8n2-21c.oralocal 5.4.17-2102.201.3.el8uek.x86_64 #2 SMP Fri Apr 23 09:05:57 PDT 2021 x86_64 x86_64 x86_64 GNU/Linux [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# /opt/oracle.ahf/bin/tfactl -version TFA Version : 214200 TFA Build ID : 20220211135650 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# grub2-editenv - list | grep kernelopts kernelopts=root=/dev/mapper/ol-root ro resume=/dev/mapper/ol-swap rd.lvm.lv=ol/root rd.lvm.lv=ol/swap transparent_hugepage=never [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# cat /sys/kernel/mm/transparent_hugepage/enabled always madvise [never] [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# grep AnonHugePages /proc/meminfo AnonHugePages: 0 kB [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# grep HugePages /proc/meminfo AnonHugePages: 0 kB ShmemHugePages: 0 kB FileHugePages: 0 kB HugePages_Total: 1280 HugePages_Free: 514 HugePages_Rsvd: 3 HugePages_Surp: 0 [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# [root@oel8n2-21c ~]# su - grid [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs activeversion -f Oracle Clusterware active version on the cluster is [21.0.0.0.0]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [0]. [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs releasepatch Oracle Clusterware release patch level is [0] and no patches have been applied on the local node. The release patch string is [21.3.0.0.0]. [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/bin/crsctl query crs softwarepatch Oracle Clusterware patch level on node oel8n2-21c is [0]. [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/bin/kfod op=patches --------------- List of Patches =============== [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/bin/kfod op=patchlvl ------------------- Current Patch level =================== 0 [grid@oel8n2-21c ~]$ [grid@oel8n2-21c ~]$ /u01/app/21.0.0.0/grid/OPatch/opatch lspatches There are no Interim patches installed in this Oracle Home "/u01/app/21.0.0.0/grid". OPatch succeeded. [grid@oel8n2-21c ~]$