Sunday, August 30, 2020




 

Hi DBA Connections,


In this video, we are going to see step by step oracle 19c RAC installation and configuration on OEL 7.5


Download the following Softwares:

----------------------------------------


– Oracle Linux 7

– VirtualBox for Windows physical hosts

– Oracle Database 19c Release 3 – Linux x86-64 - GRID Binaries


Oracle VirtualBox Installation:

-------------------------------


Download and install  VirtualBox-6.1.12-Win


Version 6.1.12 r139181 (Qt5.6.2)


My Lab Server Configuration overview:

----------------------------------------------


RAC Node1 details:

------------------------

Host Name : srlabrac1.localdomain

Public IP : 192.168.58.201 srlabrac1.localdomain srlabrac1

Private IP: 192.168.10.1   srlabrac1-priv.localdomain srlabrac1-priv

RAC VIP   : 192.168.58.210 srlabrac1-vip.localdomain srlabrac1-vip

GRID_HOME : /u01/app/19.3.0.0/grid_1

 

RAC Node2 details:

------------------------

Host Name : srlabrac2.localdomain

Public IP : 192.168.58.202 srlabrac2.localdomain srlabrac2

Private IP: 192.168.10.2   srlabrac2-priv.localdomain srlabrac2-priv

RAC VIP   : 192.168.58.220 srlabrac2-vip.localdomain srlabrac2-vip

GRID_HOME : /u01/app/19.3.0.0/grid_1


SCAN IP's : 192.168.58.241 srlab-scan.localdomain srlab-scan

            192.168.58.242 srlab-scan.localdomain srlab-scan

    192.168.58.243 srlab-scan.localdomain srlab-scan  


High Level Steps:-

------------------


1. Oracle virtual box setup

2. Install OEL 7.5

3. DNS nameserver configuration - Skipping this step.

4. Copy the Virtual Machine

5. Creating a Shared Disk for ASM disks

6. Configure Oracle ASM Library

7. Pre-check for RAC Setup

8. Install and Configure Oracle Grid Infrastructure for a Cluster

9. Oracle 19c Database Installation

10. Post-Check For Rac Setup


Network Settings and Configuration:

-----------------------------------


[root@srlabrac1]# ifconfig


[root@srlabrac2]# ifconfig


Install the system Linux prerequisites:

---------------------------------------


For software updating purpose we need to configure internet settings, first check internet working or not.


[root@srlabrac1 ~]# ping www.sachinrameshoracledbablog.com

PING ghs.googlehosted.com (216.58.194.83) 56(84) bytes of data.

64 bytes from dfw25s13-in-f19.1e100.net (216.58.194.83): icmp_seq=1 ttl=116 time=183 ms

64 bytes from dfw25s13-in-f19.1e100.net (216.58.194.83): icmp_seq=2 ttl=116 time=483 ms

64 bytes from dfw25s13-in-f19.1e100.net (216.58.194.83): icmp_seq=3 ttl=116 time=450 ms

64 bytes from dfw25s13-in-f19.1e100.net (216.58.194.83): icmp_seq=4 ttl=116 time=911 ms

64 bytes from dfw25s13-in-f19.1e100.net (216.58.194.83): icmp_seq=5 ttl=116 time=516 ms


The package oracle-database-preinstall-19c contains all the prerequisites on Oracle Linux using the Oracle Unbreakable Enterprise Kernel (UEK).


# yum update -y - For Latest Linux Updates

# yum install -y oracle-database-preinstall-19c.x86_64 - For Oracle Settings

# yum install oracleasm-support - For ASM Disk configuration

# yum install bind* -y - For DNS configuration

# sysctl -p - To verify the oracle settings


Configure Hosts File:

---------------------


[root@srlabrac1 dev]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4


# Public


192.168.58.201 srlabrac1.localdomain srlabrac1

192.168.58.202 srlabrac2.localdomain srlabrac2


# Private


192.168.10.1 srlabrac1-priv.localdomain srlabrac1-priv

192.168.10.2 srlabrac2-priv.localdomain srlabrac2-priv


# RAC Virtual IP


192.168.58.210 srlabrac1-vip.localdomain srlabrac1-vip

192.168.58.220 srlabrac2-vip.localdomain srlabrac2-vip


# SCAN IP


192.168.58.241 srlab-scan.localdomain srlab-scan

192.168.58.242 srlab-scan.localdomain srlab-scan

192.168.58.243 srlab-scan.localdomain srlab-scan


Create Groups and permissions:

------------------------------


groupadd -g 54327 asmdba

groupadd -g 54328 asmoper

groupadd -g 54329 asmadmin


Create Oracle user password

----------------------------

[root@srlabrac01 ~]# passwd oracle


Create the directories in which the Oracle software will be installed

---------------------------------------------------------------------


mkdir -p /u01/app/19.3.0.0/grid_1

mkdir -p /u01/app/oracle/product/19.3.0.0/db_1

chown -R oracle:oinstall /u01

chmod -R 775 /u01/


Configure Bash Profile of Users:

--------------------------------


We are going to install Grid and Oracle as oracle user.


Update the bash profile file for grid and oracle respectively as below.


Log in as the “oracle” user and add the following lines at the end of the “/home/oracle/.bash_profile” file.


# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle

export GRID_HOME=/u01/app/19.3.0.0/grid_1

export DB_HOME=$ORACLE_BASE/product/19.3.0.0/db_1

export ORACLE_HOME=$DB_HOME

export ORACLE_SID=SRLABDB

export ORACLE_TERM=xterm

export BASE_PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


alias grid='. /home/oracle/grid_env'

alias db='. /home/oracle/db_env'


Grid Home bash profile

----------------------


Create a file called "/home/oracle/grid_env" with the following contents


vi /home/oracle/grid_env


export ORACLE_SID=+ASM1

export ORACLE_HOME=$GRID_HOME

export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


Oracle Home bash profile:

-------------------------


Create a file called "/home/oracle/db_env" with the following contents


vi /home/oracle/db_env


export ORACLE_SID=SRLABDB

export ORACLE_HOME=$DB_HOME

export PATH=$ORACLE_HOME/bin:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


Firewall Stop and Disable:

-------------------------


We can open firewall after installation


systemctl stop firewalld.service

systemctl disable firewalld.service


Chrony NTP Configuration:

-------------------------


systemctl enable chronyd.service

systemctl restart chronyd.service

chronyc -a 'burst 4/4'

chronyc -a makestep


[root@srlabrac1 ~]# yum install -y oracle-database-preinstall-19c.x86_64

Last metadata expiration check: 0:35:43 ago on Sat 15 Aug 2020 03:24:28 PM CDT.

Dependencies resolved.

======================================================================================================================================

 Package                                    Architecture       Version                            Repository                     Size

======================================================================================================================================

Installing:

 oracle-database-preinstall-19c             x86_64             1.0-1.el8                          ol8_baseos_latest              24 k

Installing dependencies:

 ksh                                        x86_64             20120801-254.0.1.el8               ol8_appstream                 927 k

 libaio-devel                               x86_64             0.3.112-1.el8                      ol8_baseos_latest              19 k

 libnsl                                     x86_64             2.28-101.0.1.el8                   ol8_baseos_latest              97 k


Transaction Summary

======================================================================================================================================

Install  4 Packages


Total download size: 1.0 M

Installed size: 3.5 M

Downloading Packages:

(1/4): libaio-devel-0.3.112-1.el8.x86_64.rpm                                                          3.2 kB/s |  19 kB     00:05

(2/4): oracle-database-preinstall-19c-1.0-1.el8.x86_64.rpm                                            3.4 kB/s |  24 kB     00:07

(3/4): libnsl-2.28-101.0.1.el8.x86_64.rpm                                                              13 kB/s |  97 kB     00:07

(4/4): ksh-20120801-254.0.1.el8.x86_64.rpm                                                            106 kB/s | 927 kB     00:08

--------------------------------------------------------------------------------------------------------------------------------------

Total                                                                                                  73 kB/s | 1.0 MB     00:14

warning: /var/cache/dnf/ol8_baseos_latest-e4c6155830ad002c/packages/libnsl-2.28-101.0.1.el8.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ad986da3: NOKEY

Oracle Linux 8 BaseOS Latest (x86_64)                                                                 1.3 MB/s | 3.1 kB     00:00

Importing GPG key 0xAD986DA3:

 Userid     : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"

 Fingerprint: 76FD 3DB1 3AB6 7410 B89D B10E 8256 2EA9 AD98 6DA3

 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Key imported successfully

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                              1/1

  Installing       : ksh-20120801-254.0.1.el8.x86_64                                                                              1/4

  Running scriptlet: ksh-20120801-254.0.1.el8.x86_64                                                                              1/4

  Installing       : libaio-devel-0.3.112-1.el8.x86_64                                                                            2/4

  Installing       : libnsl-2.28-101.0.1.el8.x86_64                                                                               3/4

  Running scriptlet: oracle-database-preinstall-19c-1.0-1.el8.x86_64                                                              4/4

  Installing       : oracle-database-preinstall-19c-1.0-1.el8.x86_64                                                              4/4

  Running scriptlet: oracle-database-preinstall-19c-1.0-1.el8.x86_64                                                              4/4

  Verifying        : libnsl-2.28-101.0.1.el8.x86_64                                                                               1/4

  Verifying        : oracle-database-preinstall-19c-1.0-1.el8.x86_64                                                              2/4

  Verifying        : libaio-devel-0.3.112-1.el8.x86_64                                                                            3/4

  Verifying        : ksh-20120801-254.0.1.el8.x86_64                                                                              4/4


Installed:

  ksh-20120801-254.0.1.el8.x86_64                       libaio-devel-0.3.112-1.el8.x86_64       libnsl-2.28-101.0.1.el8.x86_64

  oracle-database-preinstall-19c-1.0-1.el8.x86_64


Complete!


[root@srlabrac1 ~]# rpm -qa |grep preinstall

oracle-database-preinstall-19c-1.0-2.el7.x86_64

oracle-rdbms-server-12cR1-preinstall-1.0-7.el7.x86_64

oracle-database-server-12cR2-preinstall-1.0-5.el7.x86_64


[root@srlabrac1 ~]# yum install oracleasm-support

Last metadata expiration check: 0:40:58 ago on Sat 15 Aug 2020 03:24:28 PM CDT.

No match for argument: oracleasm-support

Error: Unable to find a match: oracleasm-support


[root@srlabrac1 ~]# yum install bind* -y

Last metadata expiration check: 0:41:35 ago on Sat 15 Aug 2020 03:24:28 PM CDT.

Package bind-export-libs-32:9.11.13-5.0.1.el8_2.x86_64 is already installed.

Package bind-libs-32:9.11.13-5.0.1.el8_2.x86_64 is already installed.

Package bind-libs-lite-32:9.11.13-5.0.1.el8_2.x86_64 is already installed.

Package bind-license-32:9.11.13-5.0.1.el8_2.noarch is already installed.

Package bind-utils-32:9.11.13-5.0.1.el8_2.x86_64 is already installed.

Dependencies resolved.

======================================================================================================================================

 Package                           Architecture         Version                                 Repository                       Size

======================================================================================================================================

Installing:

 bind                              x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   2.1 M

 bind-chroot                       x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   102 k

 bind-devel                        x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   175 k

 bind-export-devel                 x86_64               32:9.11.13-5.0.1.el8_2                  ol8_baseos_latest               403 k

 bind-lite-devel                   x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   396 k

 bind-pkcs11                       x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   389 k

 bind-pkcs11-devel                 x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   120 k

 bind-pkcs11-libs                  x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   1.1 M

 bind-pkcs11-utils                 x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   257 k

 bind-sdb                          x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   449 k

 bind-sdb-chroot                   x86_64               32:9.11.13-5.0.1.el8_2                  ol8_appstream                   102 k

Installing dependencies:

 cmake-filesystem                  x86_64               3.11.4-7.el8                            ol8_appstream                    40 k

 keyutils-libs-devel               x86_64               1.5.10-6.el8                            ol8_baseos_latest                48 k

 krb5-devel                        x86_64               1.17-18.el8                             ol8_baseos_latest               549 k

 libcap-devel                      x86_64               2.26-3.el8                              ol8_baseos_latest                33 k

 libcom_err-devel                  x86_64               1.45.4-3.0.5.el8                        ol8_UEKR6                        39 k

 libkadm5                          x86_64               1.17-18.el8                             ol8_baseos_latest               185 k

 libmaxminddb-devel                x86_64               1.2.0-7.el8                             ol8_appstream                    37 k

 libselinux-devel                  x86_64               2.9-3.el8                               ol8_baseos_latest               199 k

 libsepol-devel                    x86_64               2.9-1.el8                               ol8_baseos_latest                86 k

 libverto-devel                    x86_64               0.3.0-5.el8                             ol8_baseos_latest                18 k

 libxml2-devel                     x86_64               2.9.7-7.0.1.el8                         ol8_appstream                   1.0 M

 openssl-devel                     x86_64               1:1.1.1c-15.el8                         ol8_baseos_latest               2.3 M

 pcre2-devel                       x86_64               10.32-1.el8                             ol8_baseos_latest               605 k

 pcre2-utf32                       x86_64               10.32-1.el8                             ol8_baseos_latest               220 k

 xz-devel                          x86_64               5.2.4-3.el8                             ol8_baseos_latest                62 k

 zlib-devel                        x86_64               1.2.11-13.el8                           ol8_baseos_latest                57 k


Transaction Summary

======================================================================================================================================

Install  27 Packages


Total download size: 11 M

Installed size: 29 M

Downloading Packages:

(1/27): libverto-devel-0.3.0-5.el8.x86_64.rpm                                                         7.5 kB/s |  18 kB     00:02

(2/27): zlib-devel-1.2.11-13.el8.x86_64.rpm                                                            20 kB/s |  57 kB     00:02

(3/27): libkadm5-1.17-18.el8.x86_64.rpm                                                                66 kB/s | 185 kB     00:02

(4/27): keyutils-libs-devel-1.5.10-6.el8.x86_64.rpm                                                    29 kB/s |  48 kB     00:01

(5/27): xz-devel-5.2.4-3.el8.x86_64.rpm                                                                36 kB/s |  62 kB     00:01

(6/27): krb5-devel-1.17-18.el8.x86_64.rpm                                                             221 kB/s | 549 kB     00:02

(7/27): pcre2-utf32-10.32-1.el8.x86_64.rpm                                                             75 kB/s | 220 kB     00:02

(8/27): bind-export-devel-9.11.13-5.0.1.el8_2.x86_64.rpm                                               82 kB/s | 403 kB     00:04

(9/27): libselinux-devel-2.9-3.el8.x86_64.rpm                                                          56 kB/s | 199 kB     00:03

(10/27): libcap-devel-2.26-3.el8.x86_64.rpm                                                            15 kB/s |  33 kB     00:02

(11/27): pcre2-devel-10.32-1.el8.x86_64.rpm                                                           120 kB/s | 605 kB     00:05

(12/27): libsepol-devel-2.9-1.el8.x86_64.rpm                                                           37 kB/s |  86 kB     00:02

(13/27): openssl-devel-1.1.1c-15.el8.x86_64.rpm                                                       178 kB/s | 2.3 MB     00:13

(14/27): bind-pkcs11-devel-9.11.13-5.0.1.el8_2.x86_64.rpm                                              41 kB/s | 120 kB     00:02

(15/27): bind-pkcs11-9.11.13-5.0.1.el8_2.x86_64.rpm                                                    91 kB/s | 389 kB     00:04

(16/27): libxml2-devel-2.9.7-7.0.1.el8.x86_64.rpm                                                     140 kB/s | 1.0 MB     00:07

(17/27): bind-lite-devel-9.11.13-5.0.1.el8_2.x86_64.rpm                                                92 kB/s | 396 kB     00:04

(18/27): bind-chroot-9.11.13-5.0.1.el8_2.x86_64.rpm                                                    49 kB/s | 102 kB     00:02

(19/27): bind-pkcs11-utils-9.11.13-5.0.1.el8_2.x86_64.rpm                                              61 kB/s | 257 kB     00:04

(20/27): bind-devel-9.11.13-5.0.1.el8_2.x86_64.rpm                                                     61 kB/s | 175 kB     00:02

(21/27): libmaxminddb-devel-1.2.0-7.el8.x86_64.rpm                                                     19 kB/s |  37 kB     00:01

(22/27): bind-sdb-chroot-9.11.13-5.0.1.el8_2.x86_64.rpm                                                33 kB/s | 102 kB     00:03

(23/27): cmake-filesystem-3.11.4-7.el8.x86_64.rpm                                                      17 kB/s |  40 kB     00:02

(24/27): bind-sdb-9.11.13-5.0.1.el8_2.x86_64.rpm                                                      108 kB/s | 449 kB     00:04

(25/27): libcom_err-devel-1.45.4-3.0.5.el8.x86_64.rpm                                                  19 kB/s |  39 kB     00:02

(26/27): bind-pkcs11-libs-9.11.13-5.0.1.el8_2.x86_64.rpm                                               79 kB/s | 1.1 MB     00:14

(27/27): bind-9.11.13-5.0.1.el8_2.x86_64.rpm                                                          117 kB/s | 2.1 MB     00:18

--------------------------------------------------------------------------------------------------------------------------------------

Total                                                                                                 230 kB/s |  11 MB     00:48

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                              1/1

  Running scriptlet: bind-32:9.11.13-5.0.1.el8_2.x86_64                                                                          1/27

  Installing       : bind-32:9.11.13-5.0.1.el8_2.x86_64                                                                          1/27

  Running scriptlet: bind-32:9.11.13-5.0.1.el8_2.x86_64                                                                          1/27

  Installing       : bind-pkcs11-libs-32:9.11.13-5.0.1.el8_2.x86_64                                                              2/27

  Installing       : zlib-devel-1.2.11-13.el8.x86_64                                                                             3/27

  Installing       : bind-sdb-32:9.11.13-5.0.1.el8_2.x86_64                                                                      4/27

  Running scriptlet: bind-sdb-32:9.11.13-5.0.1.el8_2.x86_64                                                                      4/27

  Installing       : libcom_err-devel-1.45.4-3.0.5.el8.x86_64                                                                    5/27

  Installing       : cmake-filesystem-3.11.4-7.el8.x86_64                                                                        6/27

  Installing       : libmaxminddb-devel-1.2.0-7.el8.x86_64                                                                       7/27

  Installing       : libsepol-devel-2.9-1.el8.x86_64                                                                             8/27

  Installing       : libcap-devel-2.26-3.el8.x86_64                                                                              9/27

  Installing       : pcre2-utf32-10.32-1.el8.x86_64                                                                             10/27

  Installing       : pcre2-devel-10.32-1.el8.x86_64                                                                             11/27

  Installing       : libselinux-devel-2.9-3.el8.x86_64                                                                          12/27

  Installing       : xz-devel-5.2.4-3.el8.x86_64                                                                                13/27

  Installing       : libxml2-devel-2.9.7-7.0.1.el8.x86_64                                                                       14/27

  Installing       : keyutils-libs-devel-1.5.10-6.el8.x86_64                                                                    15/27

  Installing       : libverto-devel-0.3.0-5.el8.x86_64                                                                          16/27

  Installing       : libkadm5-1.17-18.el8.x86_64                                                                                17/27

  Installing       : krb5-devel-1.17-18.el8.x86_64                                                                              18/27

  Installing       : openssl-devel-1:1.1.1c-15.el8.x86_64                                                                       19/27

  Installing       : bind-lite-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                              20/27

  Installing       : bind-pkcs11-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                            21/27

  Installing       : bind-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                                   22/27

  Installing       : bind-export-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                            23/27

  Installing       : bind-sdb-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                              24/27

  Running scriptlet: bind-sdb-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                              24/27

  Installing       : bind-pkcs11-32:9.11.13-5.0.1.el8_2.x86_64                                                                  25/27

  Running scriptlet: bind-pkcs11-32:9.11.13-5.0.1.el8_2.x86_64                                                                  25/27

  Installing       : bind-pkcs11-utils-32:9.11.13-5.0.1.el8_2.x86_64                                                            26/27

  Installing       : bind-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                                  27/27

  Running scriptlet: bind-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                                  27/27

  Running scriptlet: bind-sdb-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                              27/27

  Running scriptlet: bind-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                                  27/27

  Verifying        : libkadm5-1.17-18.el8.x86_64                                                                                 1/27

  Verifying        : libverto-devel-0.3.0-5.el8.x86_64                                                                           2/27

  Verifying        : zlib-devel-1.2.11-13.el8.x86_64                                                                             3/27

  Verifying        : keyutils-libs-devel-1.5.10-6.el8.x86_64                                                                     4/27

  Verifying        : krb5-devel-1.17-18.el8.x86_64                                                                               5/27

  Verifying        : xz-devel-5.2.4-3.el8.x86_64                                                                                 6/27

  Verifying        : openssl-devel-1:1.1.1c-15.el8.x86_64                                                                        7/27

  Verifying        : bind-export-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                             8/27

  Verifying        : pcre2-utf32-10.32-1.el8.x86_64                                                                              9/27

  Verifying        : libselinux-devel-2.9-3.el8.x86_64                                                                          10/27

  Verifying        : pcre2-devel-10.32-1.el8.x86_64                                                                             11/27

  Verifying        : libcap-devel-2.26-3.el8.x86_64                                                                             12/27

  Verifying        : libsepol-devel-2.9-1.el8.x86_64                                                                            13/27

  Verifying        : libxml2-devel-2.9.7-7.0.1.el8.x86_64                                                                       14/27

  Verifying        : bind-pkcs11-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                            15/27

  Verifying        : bind-pkcs11-32:9.11.13-5.0.1.el8_2.x86_64                                                                  16/27

  Verifying        : bind-lite-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                              17/27

  Verifying        : bind-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                                  18/27

  Verifying        : bind-pkcs11-utils-32:9.11.13-5.0.1.el8_2.x86_64                                                            19/27

  Verifying        : bind-pkcs11-libs-32:9.11.13-5.0.1.el8_2.x86_64                                                             20/27

  Verifying        : bind-devel-32:9.11.13-5.0.1.el8_2.x86_64                                                                   21/27

  Verifying        : libmaxminddb-devel-1.2.0-7.el8.x86_64                                                                      22/27

  Verifying        : bind-sdb-chroot-32:9.11.13-5.0.1.el8_2.x86_64                                                              23/27

  Verifying        : cmake-filesystem-3.11.4-7.el8.x86_64                                                                       24/27

  Verifying        : bind-sdb-32:9.11.13-5.0.1.el8_2.x86_64                                                                     25/27

  Verifying        : bind-32:9.11.13-5.0.1.el8_2.x86_64                                                                         26/27

  Verifying        : libcom_err-devel-1.45.4-3.0.5.el8.x86_64                                                                   27/27


Installed:

  bind-32:9.11.13-5.0.1.el8_2.x86_64                                bind-chroot-32:9.11.13-5.0.1.el8_2.x86_64

  bind-devel-32:9.11.13-5.0.1.el8_2.x86_64                          bind-export-devel-32:9.11.13-5.0.1.el8_2.x86_64

  bind-lite-devel-32:9.11.13-5.0.1.el8_2.x86_64                     bind-pkcs11-32:9.11.13-5.0.1.el8_2.x86_64

  bind-pkcs11-devel-32:9.11.13-5.0.1.el8_2.x86_64                   bind-pkcs11-libs-32:9.11.13-5.0.1.el8_2.x86_64

  bind-pkcs11-utils-32:9.11.13-5.0.1.el8_2.x86_64                   bind-sdb-32:9.11.13-5.0.1.el8_2.x86_64

  bind-sdb-chroot-32:9.11.13-5.0.1.el8_2.x86_64                     cmake-filesystem-3.11.4-7.el8.x86_64

  keyutils-libs-devel-1.5.10-6.el8.x86_64                           krb5-devel-1.17-18.el8.x86_64

  libcap-devel-2.26-3.el8.x86_64                                    libcom_err-devel-1.45.4-3.0.5.el8.x86_64

  libkadm5-1.17-18.el8.x86_64                                       libmaxminddb-devel-1.2.0-7.el8.x86_64

  libselinux-devel-2.9-3.el8.x86_64                                 libsepol-devel-2.9-1.el8.x86_64

  libverto-devel-0.3.0-5.el8.x86_64                                 libxml2-devel-2.9.7-7.0.1.el8.x86_64

  openssl-devel-1:1.1.1c-15.el8.x86_64                              pcre2-devel-10.32-1.el8.x86_64

  pcre2-utf32-10.32-1.el8.x86_64                                    xz-devel-5.2.4-3.el8.x86_64

  zlib-devel-1.2.11-13.el8.x86_64


Complete!



[root@srlabrac01 /]# cd /home

[root@srlabrac01 home]# ls -lrt

total 24

drwx------.  2 root          root          16384 Aug  1 20:59 lost+found

drwx------. 15 sachinrramesh sachinrramesh  4096 Aug  1 22:32 sachinrramesh

drwx------.  3 oracle        oinstall       4096 Aug 15 16:01 oracle

[root@srlabrac01 home]# cd oracle

[root@srlabrac01 oracle]# ls -lrt

total 0

[root@srlabrac01 oracle]# pwd

/home/oracle

[root@srlabrac01 oracle]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54330(racdba),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba)

[root@srlabrac01 oracle]#


[root@srlabrac01 19.3]# yum install oracleasmlib-2.0.12-1.el7.x86_64.rpm


Last metadata expiration check: 1:28:13 ago on Sat 15 Aug 2020 03:24:28 PM CDT.

Dependencies resolved.

======================================================================================================================================

 Package                          Architecture               Version                           Repository                        Size

======================================================================================================================================

Installing:

 oracleasmlib                     x86_64                     2.0.12-1.el7                      @commandline                      19 k


Transaction Summary

======================================================================================================================================

Install  1 Package


Total size: 19 k

Installed size: 39 k

Is this ok [y/N]: y

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                              1/1

  Installing       : oracleasmlib-2.0.12-1.el7.x86_64                                                                             1/1

  Verifying        : oracleasmlib-2.0.12-1.el7.x86_64                                                                             1/1


Installed:

  oracleasmlib-2.0.12-1.el7.x86_64


Complete!

[root@srlabrac01 19.3]# yum install oracleasm-support-2.1.11-2.el7.x86_64.rpm

Last metadata expiration check: 1:28:44 ago on Sat 15 Aug 2020 03:24:28 PM CDT.

Dependencies resolved.

======================================================================================================================================

 Package                              Architecture              Version                         Repository                       Size

======================================================================================================================================

Installing:

 oracleasm-support                    x86_64                    2.1.11-2.el7                    @commandline                     85 k


Transaction Summary

======================================================================================================================================

Install  1 Package


Total size: 85 k

Installed size: 266 k

Is this ok [y/N]: y

Downloading Packages:

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

  Preparing        :                                                                                                              1/1

  Installing       : oracleasm-support-2.1.11-2.el7.x86_64                                                                        1/1

  Running scriptlet: oracleasm-support-2.1.11-2.el7.x86_64                                                                        1/1

Note: Forwarding request to 'systemctl enable oracleasm.service'.

Synchronizing state of oracleasm.service with SysV service script with /usr/lib/systemd/systemd-sysv-install.

Executing: /usr/lib/systemd/systemd-sysv-install enable oracleasm

Created symlink /etc/systemd/system/multi-user.target.wants/oracleasm.service → /usr/lib/systemd/system/oracleasm.service.


  Verifying        : oracleasm-support-2.1.11-2.el7.x86_64                                                                        1/1


Installed:

  oracleasm-support-2.1.11-2.el7.x86_64


Complete!


[root@srlabrac01 19.3]#

[root@srlabrac01 19.3]# sysctl -p

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500


Configure Oracle ASM:

--------------------


[root@srlabrac1 ~]# systemctl disable firewalld.service

[root@srlabrac1 ~]# systemctl stop firewalld.service

[root@srlabrac1 ~]# systemctl enable chronyd.service

Created symlink /etc/systemd/system/multi-user.target.wants/chronyd.service → /usr/lib/systemd/system/chronyd.service.

[root@srlabrac1 ~]# systemctl restart chronyd.service

[root@srlabrac1 ~]# chronyc -a 'burst 4/4'

200 OK

[root@srlabrac01 ~]# chronyc -a makestep

200 OK


Check Resolve.Conf File:

------------------------


[root@srlabrac2 named]# cat /etc/resolv.conf

# Generated by NetworkManager

search localdomain

nameserver 192.168.58.201

options timeout:1

options attempts:5

[root@srlabrac02 named]#

[root@srlabrac02 named]# vi /etc/resolv.conf

[root@srlabrac02 named]#


Pre-check for RAC Setup:

------------------------


login as: oracle

oracle@192.168.58.201's password:


SSH Setup for remote node passwordless authentication:

------------------------------------------------------


[oracle@srlabrac1 deinstall]$

[oracle@srlabrac1 deinstall]$ ./sshUserSetup.sh -user oracle -hosts "srlabrac1 srlabrac2" -noPromptPassphrase -confirm -advanced


[oracle@srlabrac1 deinstall]$ ssh srlabrac2 date


[oracle@srlabrac1 deinstall]$./runcluvfy.sh stage -pre crsinst -n srlabrac1,srlabrac2 -verbose



Install and Configure Oracle 19c Grid Infrastructure for a Cluster:

-------------------------------------------------------------------


[oracle@srlabrac1]$./gridSetup.sh


Missed things and fixes:

------------------------


Verifying Group Membership: asmadmin ...FAILED

srlabrac2: PRVG-10460 : User "oracle" does not belong to group "asmadmin"

           selected for privileges "OSASM" on node "srlabrac2".


srlabrac1: PRVG-10460 : User "oracle" does not belong to group "asmadmin"

           selected for privileges "OSASM" on node "srlabrac1".


Verifying Group Membership: asmdba ...FAILED

srlabrac2: PRVG-10460 : User "oracle" does not belong to group "asmdba"

           selected for privileges "OSDBA" on node "srlabrac2".


srlabrac1: PRVG-10460 : User "oracle" does not belong to group "asmdba"

           selected for privileges "OSDBA" on node "srlabrac1".


usermod -G asmdba,asmoper,asmadmin oracle



Verifying Package: cvuqdisk-1.0.10-1 ...FAILED

srlabrac2: PRVG-11550 : Package "cvuqdisk" is missing on node "srlabrac2"


srlabrac1: PRVG-11550 : Package "cvuqdisk" is missing on node "srlabrac1"


[root@srlabrac1 rpm]# ls -lrt

total 12

-rw-r--r--. 1 oracle oinstall 11412 Mar 13  2019 cvuqdisk-1.0.10-1.rpm

[root@srlabrac1 rpm]# pwd

/u01/app/19.3.0.0/grid_1/cv/rpm



Node1 and Node2: Activity Log:

------------------------------


login as: oracle

oracle@192.168.58.201's password:

Last login: Fri Aug 28 21:30:19 2020 from gateway

[oracle@srlabrac1 ~]$ cd /u01/app/19.3.0.0/grid_1/deinstall/

[oracle@srlabrac1 deinstall]$ pwd

/u01/app/19.3.0.0/grid_1/deinstall

[oracle@srlabrac1 deinstall]$ ./sshUserSetup.sh -user oracle -hosts "srlabrac1 srlabrac2" -noPromptPassphrase -confirm -advanced

The output of this script is also logged into /tmp/sshUserSetup_2020-08-29-03-40-41.log

Hosts are srlabrac1 srlabrac2

user is oracle

Platform:- Linux

Checking if the remote hosts are reachable

PING srlabrac1.localdomain (192.168.58.201) 56(84) bytes of data.

64 bytes from srlabrac1.localdomain (192.168.58.201): icmp_seq=1 ttl=64 time=0.065 ms

64 bytes from srlabrac1.localdomain (192.168.58.201): icmp_seq=2 ttl=64 time=0.069 ms

64 bytes from srlabrac1.localdomain (192.168.58.201): icmp_seq=3 ttl=64 time=0.073 ms

64 bytes from srlabrac1.localdomain (192.168.58.201): icmp_seq=4 ttl=64 time=0.056 ms

64 bytes from srlabrac1.localdomain (192.168.58.201): icmp_seq=5 ttl=64 time=0.130 ms


--- srlabrac1.localdomain ping statistics ---

5 packets transmitted, 5 received, 0% packet loss, time 4020ms

rtt min/avg/max/mdev = 0.056/0.078/0.130/0.028 ms

PING srlabrac2.localdomain (192.168.58.202) 56(84) bytes of data.

64 bytes from srlabrac2.localdomain (192.168.58.202): icmp_seq=1 ttl=64 time=1.67 ms

64 bytes from srlabrac2.localdomain (192.168.58.202): icmp_seq=2 ttl=64 time=0.565 ms

64 bytes from srlabrac2.localdomain (192.168.58.202): icmp_seq=3 ttl=64 time=0.621 ms

64 bytes from srlabrac2.localdomain (192.168.58.202): icmp_seq=4 ttl=64 time=1.48 ms

64 bytes from srlabrac2.localdomain (192.168.58.202): icmp_seq=5 ttl=64 time=0.612 ms


--- srlabrac2.localdomain ping statistics ---

5 packets transmitted, 5 received, 0% packet loss, time 4007ms

rtt min/avg/max/mdev = 0.565/0.991/1.677/0.484 ms

Remote host reachability check succeeded.

The following hosts are reachable: srlabrac1 srlabrac2.

The following hosts are not reachable: .

All hosts are reachable. Proceeding further...

firsthost srlabrac1

numhosts 2

The script will setup SSH connectivity from the host srlabrac1.localdomain to all

the remote hosts. After the script is executed, the user can use SSH to run

commands on the remote hosts or copy files between this host srlabrac1.localdomain

and the remote hosts without being prompted for passwords or confirmations.


NOTE 1:

As part of the setup procedure, this script will use ssh and scp to copy

files between the local host and the remote hosts. Since the script does not

store passwords, you may be prompted for the passwords during the execution of

the script whenever ssh or scp is invoked.


NOTE 2:

AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY

AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEGES TO THESE

directories.


Do you want to continue and let the script make the above mentioned changes (yes/no)?

Confirmation provided on the command line


The user chose yes

User chose to skip passphrase related questions.

Creating .ssh directory on local host, if not present already

Creating authorized_keys file on local host

Changing permissions on authorized_keys to 644 on local host

Creating known_hosts file on local host

Changing permissions on known_hosts to 644 on local host

Creating config file on local host

If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.

Creating .ssh directory and setting permissions on remote host srlabrac1

THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.

The script would create ~oracle/.ssh/config file on remote host srlabrac1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.

The user may be prompted for a password here since the script would be running SSH on host srlabrac1.

Warning: Permanently added 'srlabrac1,192.168.58.201' (ECDSA) to the list of known hosts.

oracle@srlabrac1's password:

Done with creating .ssh directory and setting permissions on remote host srlabrac1.

Creating .ssh directory and setting permissions on remote host srlabrac2

THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.

The script would create ~oracle/.ssh/config file on remote host srlabrac2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.

The user may be prompted for a password here since the script would be running SSH on host srlabrac2.

Warning: Permanently added 'srlabrac2,192.168.58.202' (ECDSA) to the list of known hosts.

Done with creating .ssh directory and setting permissions on remote host srlabrac2.

Copying local host public key to the remote host srlabrac1

The user may be prompted for a password or passphrase here since the script would be using SCP for host srlabrac1.

oracle@srlabrac1's password:

Done copying local host public key to the remote host srlabrac1

Copying local host public key to the remote host srlabrac2

The user may be prompted for a password or passphrase here since the script would be using SCP for host srlabrac2.

Done copying local host public key to the remote host srlabrac2

Creating keys on remote host srlabrac1 if they do not exist already. This is required to setup SSH on host srlabrac1.


Creating keys on remote host srlabrac2 if they do not exist already. This is required to setup SSH on host srlabrac2.


Updating authorized_keys file on remote host srlabrac1

Updating known_hosts file on remote host srlabrac1

Updating authorized_keys file on remote host srlabrac2

Updating known_hosts file on remote host srlabrac2

cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory

cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory

SSH setup is complete.


------------------------------------------------------------------------

Verifying SSH setup

===================

The script will now run the date command on the remote nodes using ssh

to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,

THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR

PASSWORDS. If you see any output other than date or are prompted for the

password, ssh is not setup correctly and you will need to resolve the

issue and set up ssh again.

The possible causes for failure could be:

1. The server settings in /etc/ssh/sshd_config file do not allow ssh

for user oracle.

2. The server may have disabled public key based authentication.

3. The client public key on the server may be outdated.

4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.

5. User may not have passed -shared option for shared remote users or

may be passing the -shared option for non-shared remote users.

6. If there is output in addition to the date, but no password is asked,

it may be a security alert shown as part of company policy. Append the

additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.

------------------------------------------------------------------------

--srlabrac1:--

Running /usr/bin/ssh -x -l oracle srlabrac1 date to verify SSH connectivity has been setup from local host to srlabrac1.

IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.

Sat Aug 29 03:41:07 IST 2020

------------------------------------------------------------------------

--srlabrac2:--

Running /usr/bin/ssh -x -l oracle srlabrac2 date to verify SSH connectivity has been setup from local host to srlabrac2.

IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.

Sat Aug 29 03:41:07 IST 2020

------------------------------------------------------------------------

------------------------------------------------------------------------

Verifying SSH connectivity has been setup from srlabrac1 to srlabrac1

IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.

Sat Aug 29 03:41:09 IST 2020

------------------------------------------------------------------------

------------------------------------------------------------------------

Verifying SSH connectivity has been setup from srlabrac1 to srlabrac2

IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.

Sat Aug 29 03:41:10 IST 2020

------------------------------------------------------------------------

-Verification from complete-

SSH verification complete.

[oracle@srlabrac1 deinstall]$ hostname

srlabrac1.localdomain

[oracle@srlabrac1 deinstall]$ ssh srlabrac2 date

Sat Aug 29 03:41:25 IST 2020

[oracle@srlabrac1 deinstall]$ ssh srlabrac2

Last login: Sat Aug 29 02:25:33 2020 from gateway

[oracle@srlabrac2 ~]$ hostname

srlabrac2.localdomain

[oracle@srlabrac2 ~]$ eit

bash: eit: command not found...

[oracle@srlabrac2 ~]$ exit

logout

Connection to srlabrac2 closed.

[oracle@srlabrac1 deinstall]$

[oracle@srlabrac1 grid_1]$ ./runcluvfy.sh stage -pre crsinst -n srlabrac1,srlabrac2 -verbose


ERROR:

PRVG-10467 : The default Oracle Inventory group could not be determined.


Verifying Physical Memory ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     4.0866GB (4285092.0KB)    8GB (8388608.0KB)         failed

  srlabrac1     4.0866GB (4285092.0KB)    8GB (8388608.0KB)         failed

Verifying Physical Memory ...FAILED (PRVF-7530)

Verifying Available Physical Memory ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     3.4984GB (3668304.0KB)    50MB (51200.0KB)          passed

  srlabrac1     3.3542GB (3517144.0KB)    50MB (51200.0KB)          passed

Verifying Available Physical Memory ...PASSED

Verifying Swap Size ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     8GB (8388604.0KB)         4.0866GB (4285092.0KB)    passed

  srlabrac1     8GB (8388604.0KB)         4.0866GB (4285092.0KB)    passed

Verifying Swap Size ...PASSED

Verifying Free Space: srlabrac2:/usr,srlabrac2:/var,srlabrac2:/etc,srlabrac2:/sbin ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /usr              srlabrac2     /             15.0391GB     25MB          passed

  /var              srlabrac2     /             15.0391GB     5MB           passed

  /etc              srlabrac2     /             15.0391GB     25MB          passed

  /sbin             srlabrac2     /             15.0391GB     10MB          passed

Verifying Free Space: srlabrac2:/usr,srlabrac2:/var,srlabrac2:/etc,srlabrac2:/sbin ...PASSED

Verifying Free Space: srlabrac2:/tmp ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /tmp              srlabrac2     /tmp          3.8047GB      1GB           passed

Verifying Free Space: srlabrac2:/tmp ...PASSED

Verifying Free Space: srlabrac1:/usr,srlabrac1:/var,srlabrac1:/etc,srlabrac1:/sbin ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /usr              srlabrac1     /             5.6953GB      25MB          passed

  /var              srlabrac1     /             5.6953GB      5MB           passed

  /etc              srlabrac1     /             5.6953GB      25MB          passed

  /sbin             srlabrac1     /             5.6953GB      10MB          passed

Verifying Free Space: srlabrac1:/usr,srlabrac1:/var,srlabrac1:/etc,srlabrac1:/sbin ...PASSED

Verifying Free Space: srlabrac1:/tmp ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /tmp              srlabrac1     /tmp          3.8008GB      1GB           passed

Verifying Free Space: srlabrac1:/tmp ...PASSED

Verifying User Existence: oracle ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists(54321)

  srlabrac1     passed                    exists(54321)


  Verifying Users With Same UID: 54321 ...PASSED

Verifying User Existence: oracle ...PASSED

Verifying Group Existence: asmadmin ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists

  srlabrac1     passed                    exists

Verifying Group Existence: asmadmin ...PASSED

Verifying Group Existence: asmdba ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists

  srlabrac1     passed                    exists

Verifying Group Existence: asmdba ...PASSED

Verifying Group Membership: asmadmin ...

  Node Name         User Exists   Group Exists  User in Group  Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         yes           yes           no            failed

  srlabrac1         yes           yes           no            failed

Verifying Group Membership: asmadmin ...FAILED (PRVG-10460)

Verifying Group Membership: asmdba ...

  Node Name         User Exists   Group Exists  User in Group  Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         yes           yes           no            failed

  srlabrac1         yes           yes           no            failed

Verifying Group Membership: asmdba ...FAILED (PRVG-10460)

Verifying Run Level ...

  Node Name     run level                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     5                         3,5                       passed

  srlabrac1     5                         3,5                       passed

Verifying Run Level ...PASSED

Verifying Hard Limit: maximum open file descriptors ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         hard          65536         65536         passed

  srlabrac1         hard          65536         65536         passed

Verifying Hard Limit: maximum open file descriptors ...PASSED

Verifying Soft Limit: maximum open file descriptors ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          1024          1024          passed

  srlabrac1         soft          1024          1024          passed

Verifying Soft Limit: maximum open file descriptors ...PASSED

Verifying Hard Limit: maximum user processes ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         hard          16384         16384         passed

  srlabrac1         hard          16384         16384         passed

Verifying Hard Limit: maximum user processes ...PASSED

Verifying Soft Limit: maximum user processes ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          16384         2047          passed

  srlabrac1         soft          16384         2047          passed

Verifying Soft Limit: maximum user processes ...PASSED

Verifying Soft Limit: maximum stack size ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          10240         10240         passed

  srlabrac1         soft          10240         10240         passed

Verifying Soft Limit: maximum stack size ...PASSED

Verifying Architecture ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     x86_64                    x86_64                    passed

  srlabrac1     x86_64                    x86_64                    passed

Verifying Architecture ...PASSED

Verifying OS Kernel Version ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     4.1.12-124.41.4.el7uek.x86_64  4.1.12                    passed

  srlabrac1     4.1.12-124.41.4.el7uek.x86_64  4.1.12                    passed

Verifying OS Kernel Version ...PASSED

Verifying OS Kernel Parameter: semmsl ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         250           250           250           passed

  srlabrac2         250           250           250           passed

Verifying OS Kernel Parameter: semmsl ...PASSED

Verifying OS Kernel Parameter: semmns ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         32000         32000         32000         passed

  srlabrac2         32000         32000         32000         passed

Verifying OS Kernel Parameter: semmns ...PASSED

Verifying OS Kernel Parameter: semopm ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         100           100           100           passed

  srlabrac2         100           100           100           passed

Verifying OS Kernel Parameter: semopm ...PASSED

Verifying OS Kernel Parameter: semmni ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         128           128           128           passed

  srlabrac2         128           128           128           passed

Verifying OS Kernel Parameter: semmni ...PASSED

Verifying OS Kernel Parameter: shmmax ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4398046511104  4398046511104  2193967104    passed

  srlabrac2         4398046511104  4398046511104  2193967104    passed

Verifying OS Kernel Parameter: shmmax ...PASSED

Verifying OS Kernel Parameter: shmmni ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4096          4096          4096          passed

  srlabrac2         4096          4096          4096          passed

Verifying OS Kernel Parameter: shmmni ...PASSED

Verifying OS Kernel Parameter: shmall ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1073741824    1073741824    1073741824    passed

  srlabrac2         1073741824    1073741824    1073741824    passed

Verifying OS Kernel Parameter: shmall ...PASSED

Verifying OS Kernel Parameter: file-max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         6815744       6815744       6815744       passed

  srlabrac2         6815744       6815744       6815744       passed

Verifying OS Kernel Parameter: file-max ...PASSED

Verifying OS Kernel Parameter: ip_local_port_range ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         between 9000 & 65500  between 9000 & 65500  between 9000 & 65535  passed

  srlabrac2         between 9000 & 65500  between 9000 & 65500  between 9000 & 65535  passed

Verifying OS Kernel Parameter: ip_local_port_range ...PASSED

Verifying OS Kernel Parameter: rmem_default ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         262144        262144        262144        passed

  srlabrac2         262144        262144        262144        passed

Verifying OS Kernel Parameter: rmem_default ...PASSED

Verifying OS Kernel Parameter: rmem_max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4194304       4194304       4194304       passed

  srlabrac2         4194304       4194304       4194304       passed

Verifying OS Kernel Parameter: rmem_max ...PASSED

Verifying OS Kernel Parameter: wmem_default ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         262144        262144        262144        passed

  srlabrac2         262144        262144        262144        passed

Verifying OS Kernel Parameter: wmem_default ...PASSED

Verifying OS Kernel Parameter: wmem_max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1048576       1048576       1048576       passed

  srlabrac2         1048576       1048576       1048576       passed

Verifying OS Kernel Parameter: wmem_max ...PASSED

Verifying OS Kernel Parameter: aio-max-nr ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1048576       1048576       1048576       passed

  srlabrac2         1048576       1048576       1048576       passed

Verifying OS Kernel Parameter: aio-max-nr ...PASSED

Verifying OS Kernel Parameter: panic_on_oops ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1             1             1             passed

  srlabrac2         1             1             1             passed

Verifying OS Kernel Parameter: panic_on_oops ...PASSED

Verifying Package: kmod-20-21 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     kmod(x86_64)-20-28.0.3.el7  kmod(x86_64)-20-21        passed

  srlabrac1     kmod(x86_64)-20-28.0.3.el7  kmod(x86_64)-20-21        passed

Verifying Package: kmod-20-21 (x86_64) ...PASSED

Verifying Package: kmod-libs-20-21 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     kmod-libs(x86_64)-20-28.0.3.el7  kmod-libs(x86_64)-20-21   passed

  srlabrac1     kmod-libs(x86_64)-20-28.0.3.el7  kmod-libs(x86_64)-20-21   passed

Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED

Verifying Package: binutils-2.23.52.0.1 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     binutils-2.27-43.base.0.1.el7_8.1  binutils-2.23.52.0.1      passed

  srlabrac1     binutils-2.27-43.base.0.1.el7_8.1  binutils-2.23.52.0.1      passed

Verifying Package: binutils-2.23.52.0.1 ...PASSED

Verifying Package: compat-libcap1-1.10 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     compat-libcap1-1.10-7.el7  compat-libcap1-1.10       passed

  srlabrac1     compat-libcap1-1.10-7.el7  compat-libcap1-1.10       passed

Verifying Package: compat-libcap1-1.10 ...PASSED

Verifying Package: libgcc-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libgcc(x86_64)-4.8.5-39.0.5.el7  libgcc(x86_64)-4.8.2      passed

  srlabrac1     libgcc(x86_64)-4.8.5-39.0.5.el7  libgcc(x86_64)-4.8.2      passed

Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED

Verifying Package: libstdc++-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libstdc++(x86_64)-4.8.5-39.0.5.el7  libstdc++(x86_64)-4.8.2   passed

  srlabrac1     libstdc++(x86_64)-4.8.5-39.0.5.el7  libstdc++(x86_64)-4.8.2   passed

Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED

Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libstdc++-devel(x86_64)-4.8.5-39.0.5.el7  libstdc++-devel(x86_64)-4.8.2  passed

  srlabrac1     libstdc++-devel(x86_64)-4.8.5-39.0.5.el7  libstdc++-devel(x86_64)-4.8.2  passed

Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED

Verifying Package: sysstat-10.1.5 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     sysstat-10.1.5-19.el7     sysstat-10.1.5            passed

  srlabrac1     sysstat-10.1.5-19.el7     sysstat-10.1.5            passed

Verifying Package: sysstat-10.1.5 ...PASSED

Verifying Package: ksh ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     ksh                       ksh                       passed

  srlabrac1     ksh                       ksh                       passed

Verifying Package: ksh ...PASSED

Verifying Package: make-3.82 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     make-3.82-24.el7          make-3.82                 passed

  srlabrac1     make-3.82-24.el7          make-3.82                 passed

Verifying Package: make-3.82 ...PASSED

Verifying Package: glibc-2.17 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     glibc(x86_64)-2.17-307.0.1.el7.1  glibc(x86_64)-2.17        passed

  srlabrac1     glibc(x86_64)-2.17-307.0.1.el7.1  glibc(x86_64)-2.17        passed

Verifying Package: glibc-2.17 (x86_64) ...PASSED

Verifying Package: glibc-devel-2.17 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     glibc-devel(x86_64)-2.17-307.0.1.el7.1  glibc-devel(x86_64)-2.17  passed

  srlabrac1     glibc-devel(x86_64)-2.17-307.0.1.el7.1  glibc-devel(x86_64)-2.17  passed

Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED

Verifying Package: libaio-0.3.109 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libaio(x86_64)-0.3.109-13.el7  libaio(x86_64)-0.3.109    passed

  srlabrac1     libaio(x86_64)-0.3.109-13.el7  libaio(x86_64)-0.3.109    passed

Verifying Package: libaio-0.3.109 (x86_64) ...PASSED

Verifying Package: libaio-devel-0.3.109 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libaio-devel(x86_64)-0.3.109-13.el7  libaio-devel(x86_64)-0.3.109  passed

  srlabrac1     libaio-devel(x86_64)-0.3.109-13.el7  libaio-devel(x86_64)-0.3.109  passed

Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED

Verifying Package: nfs-utils-1.2.3-15 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     nfs-utils-1.3.0-0.66.0.1.el7_8  nfs-utils-1.2.3-15        passed

  srlabrac1     nfs-utils-1.3.0-0.66.0.1.el7_8  nfs-utils-1.2.3-15        passed

Verifying Package: nfs-utils-1.2.3-15 ...PASSED

Verifying Package: smartmontools-6.2-4 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     smartmontools-7.0-2.el7   smartmontools-6.2-4       passed

  srlabrac1     smartmontools-7.0-2.el7   smartmontools-6.2-4       passed

Verifying Package: smartmontools-6.2-4 ...PASSED

Verifying Package: net-tools-2.0-0.17 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     net-tools-2.0-0.25.20131004git.el7  net-tools-2.0-0.17        passed

  srlabrac1     net-tools-2.0-0.25.20131004git.el7  net-tools-2.0-0.17        passed

Verifying Package: net-tools-2.0-0.17 ...PASSED

Verifying Port Availability for component "Oracle Notification Service (ONS)" ...

  Node Name         Port Number   Protocol      Available     Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         6200          TCP           yes           successful

  srlabrac1         6200          TCP           yes           successful

  srlabrac2         6100          TCP           yes           successful

  srlabrac1         6100          TCP           yes           successful

Verifying Port Availability for component "Oracle Notification Service (ONS)" ...PASSED

Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...

  Node Name         Port Number   Protocol      Available     Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         42424         TCP           yes           successful

  srlabrac1         42424         TCP           yes           successful

Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...PASSED

Verifying Users With Same UID: 0 ...PASSED

Verifying Current Group ID ...PASSED

Verifying Root user consistency ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac2                             passed

  srlabrac1                             passed

Verifying Root user consistency ...PASSED

Verifying Package: cvuqdisk-1.0.10-1 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     missing                   cvuqdisk-1.0.10-1         failed

  srlabrac1     missing                   cvuqdisk-1.0.10-1         failed

Verifying Package: cvuqdisk-1.0.10-1 ...FAILED (PRVG-11550)

Verifying Host name ...PASSED

Verifying Node Connectivity ...

  Verifying Hosts File ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed

  Verifying Hosts File ...PASSED


Interface information for node "srlabrac2"


 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 enp0s8 192.168.58.202  192.168.58.0    0.0.0.0         192.168.58.1    08:00:27:06:51:8C 1500

 enp0s9 192.168.10.2    192.168.10.0    0.0.0.0         192.168.58.1    08:00:27:7A:F4:34 1500

 virbr0 192.168.122.1   192.168.122.0   0.0.0.0         192.168.58.1    52:54:00:7E:A4:39 1500


Interface information for node "srlabrac1"


 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 enp0s8 192.168.58.201  192.168.58.0    0.0.0.0         192.168.58.1    08:00:27:ED:B2:B6 1500

 enp0s9 192.168.10.1    192.168.10.0    0.0.0.0         192.168.58.1    08:00:27:21:0A:B7 1500

 virbr0 192.168.122.1   192.168.122.0   0.0.0.0         192.168.58.1    52:54:00:7E:A4:39 1500


Check: MTU consistency of the subnet "192.168.10.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         enp0s9        192.168.10.2  192.168.10.0  1500

  srlabrac1         enp0s9        192.168.10.1  192.168.10.0  1500


Check: MTU consistency of the subnet "192.168.122.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         virbr0        192.168.122.1  192.168.122.0  1500

  srlabrac1         virbr0        192.168.122.1  192.168.122.0  1500


Check: MTU consistency of the subnet "192.168.58.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         enp0s8        192.168.58.202  192.168.58.0  1500

  srlabrac1         enp0s8        192.168.58.201  192.168.58.0  1500

  Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[enp0s9:192.168.10.1]  srlabrac2[enp0s9:192.168.10.2]  yes


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[virbr0:192.168.122.1]  srlabrac2[virbr0:192.168.122.1]  yes


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[enp0s8:192.168.58.201]  srlabrac2[enp0s8:192.168.58.202]  yes

  Verifying subnet mask consistency for subnet "192.168.10.0" ...PASSED

  Verifying subnet mask consistency for subnet "192.168.122.0" ...PASSED

  Verifying subnet mask consistency for subnet "192.168.58.0" ...PASSED

Verifying Node Connectivity ...FAILED (PRVG-1172, PRVG-11067, PRVG-11095)

Verifying Multicast or broadcast check ...

Checking subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251"

Verifying Multicast or broadcast check ...PASSED

Verifying ASMLib installation and configuration verification. ...

  Verifying '/etc/init.d/oracleasm' ...PASSED

  Verifying '/dev/oracleasm' ...PASSED

  Verifying '/etc/sysconfig/oracleasm' ...PASSED


  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed

Verifying ASMLib installation and configuration verification. ...PASSED

Verifying Network Time Protocol (NTP) ...

  Verifying '/etc/chrony.conf' ...

  Node Name                             File exists?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying '/etc/chrony.conf' ...PASSED

  Verifying Daemon 'chronyd' ...

  Node Name                             Running?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying Daemon 'chronyd' ...PASSED

  Verifying NTP daemon or service using UDP port 123 ...

  Node Name                             Port Open?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying NTP daemon or service using UDP port 123 ...PASSED

  Verifying chrony daemon is synchronized with at least one external time source ...FAILED (PRVG-13606)

Verifying Network Time Protocol (NTP) ...FAILED (PRVG-13606)

Verifying Same core file name pattern ...PASSED

Verifying User Mask ...

  Node Name     Available                 Required                  Comment

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     0022                      0022                      passed

  srlabrac1     0022                      0022                      passed

Verifying User Mask ...PASSED

Verifying User Not In Group "root": oracle ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    does not exist

  srlabrac1     passed                    does not exist

Verifying User Not In Group "root": oracle ...PASSED

Verifying Time zone consistency ...PASSED

Verifying Time offset between nodes ...PASSED

Verifying resolv.conf Integrity ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed


checking response for name "srlabrac1" from each of the name servers specified

in "/etc/resolv.conf"


  Node Name     Source                    Comment                   Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac1     192.168.58.201            IPv4                      failed


checking response for name "srlabrac2" from each of the name servers specified

in "/etc/resolv.conf"


  Node Name     Source                    Comment                   Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     192.168.58.202            IPv4                      failed

Verifying resolv.conf Integrity ...FAILED (PRVG-10048)

Verifying DNS/NIS name service ...PASSED

Verifying Domain Sockets ...PASSED

Verifying /boot mount ...PASSED

Verifying Daemon "avahi-daemon" not configured and running ...

  Node Name     Configured                Status

  ------------  ------------------------  ------------------------

  srlabrac2     yes                       failed

  srlabrac1     yes                       failed


  Node Name     Running?                  Status

  ------------  ------------------------  ------------------------

  srlabrac2     yes                       failed

  srlabrac1     yes                       failed

Verifying Daemon "avahi-daemon" not configured and running ...FAILED (PRVG-1359, PRVG-1360)

Verifying Daemon "proxyt" not configured and running ...

  Node Name     Configured                Status

  ------------  ------------------------  ------------------------

  srlabrac2     no                        passed

  srlabrac1     no                        passed


  Node Name     Running?                  Status

  ------------  ------------------------  ------------------------

  srlabrac2     no                        passed

  srlabrac1     no                        passed

Verifying Daemon "proxyt" not configured and running ...PASSED

Verifying User Equivalence ...PASSED

Verifying RPM Package Manager database ...INFORMATION (PRVG-11250)

Verifying /dev/shm mounted as temporary file system ...PASSED

Verifying File system mount options for path /var ...PASSED

Verifying DefaultTasksMax parameter ...PASSED

Verifying zeroconf check ...PASSED

Verifying ASM Filter Driver configuration ...PASSED

Verifying Systemd login manager IPC parameter ...PASSED


Pre-check for cluster services setup was unsuccessful on all the nodes.



Failures were encountered during execution of CVU verification request "stage -pre crsinst".


Verifying Physical Memory ...FAILED

srlabrac2: PRVF-7530 : Sufficient physical memory is not available on node

           "srlabrac2" [Required physical memory = 8GB (8388608.0KB)]


srlabrac1: PRVF-7530 : Sufficient physical memory is not available on node

           "srlabrac1" [Required physical memory = 8GB (8388608.0KB)]


Verifying Group Membership: asmadmin ...FAILED

srlabrac2: PRVG-10460 : User "oracle" does not belong to group "asmadmin"

           selected for privileges "OSASM" on node "srlabrac2".


srlabrac1: PRVG-10460 : User "oracle" does not belong to group "asmadmin"

           selected for privileges "OSASM" on node "srlabrac1".


Verifying Group Membership: asmdba ...FAILED

srlabrac2: PRVG-10460 : User "oracle" does not belong to group "asmdba"

           selected for privileges "OSDBA" on node "srlabrac2".


srlabrac1: PRVG-10460 : User "oracle" does not belong to group "asmdba"

           selected for privileges "OSDBA" on node "srlabrac1".


Verifying Package: cvuqdisk-1.0.10-1 ...FAILED

srlabrac2: PRVG-11550 : Package "cvuqdisk" is missing on node "srlabrac2"


srlabrac1: PRVG-11550 : Package "cvuqdisk" is missing on node "srlabrac1"


Verifying Node Connectivity ...FAILED

PRVG-1172 : The IP address "192.168.122.1" is on multiple interfaces "virbr0"

on nodes "srlabrac2,srlabrac1"


srlabrac2: PRVG-11067 : TCP connectivity from node "srlabrac2": "192.168.122.1"

           to node "srlabrac2": "192.168.122.1" failed.

           PRVG-11095 : The TCP system call "connect" failed with error "111"

           while executing exectask on node "srlabrac2"

           Connection refused

srlabrac2: PRVG-11067 : TCP connectivity from node "srlabrac2": "192.168.122.1"

           to node "srlabrac1": "192.168.122.1" failed.

           PRVG-11095 : The TCP system call "connect" failed with error "111"

           while executing exectask on node "srlabrac2"

           Connection refused


Verifying Network Time Protocol (NTP) ...FAILED

  Verifying chrony daemon is synchronized with at least one external time

  source ...FAILED

  srlabrac2: PRVG-13606 : chrony daemon is not synchronized with any external

             time source on node "srlabrac2".


  srlabrac1: PRVG-13606 : chrony daemon is not synchronized with any external

             time source on node "srlabrac1".


Verifying resolv.conf Integrity ...FAILED

srlabrac2: PRVG-10048 : Name "srlabrac2" was not resolved to an address of the

           specified type by name servers "192.168.58.202".


srlabrac1: PRVG-10048 : Name "srlabrac1" was not resolved to an address of the

           specified type by name servers "192.168.58.201".


Verifying Daemon "avahi-daemon" not configured and running ...FAILED

srlabrac2: PRVG-1359 : Daemon process "avahi-daemon" is configured on node

           "srlabrac2"

srlabrac2: PRVG-1360 : Daemon process "avahi-daemon" is running on node

           "srlabrac2"


srlabrac1: PRVG-1359 : Daemon process "avahi-daemon" is configured on node

           "srlabrac1"

srlabrac1: PRVG-1360 : Daemon process "avahi-daemon" is running on node

           "srlabrac1"


Verifying RPM Package Manager database ...INFORMATION

PRVG-11250 : The check "RPM Package Manager database" was not performed because

it needs 'root' user privileges.



CVU operation performed:      stage -pre crsinst

Date:                         Aug 29, 2020 3:43:38 AM

CVU home:                     /u01/app/19.3.0.0/grid_1/

User:                         oracle

[oracle@srlabrac1 grid_1]$ ./runcluvfy.sh stage -pre crsinst -n srlabrac1,srlabrac2 -verbose


Verifying Physical Memory ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     4.0866GB (4285092.0KB)    8GB (8388608.0KB)         failed

  srlabrac1     4.0866GB (4285092.0KB)    8GB (8388608.0KB)         failed

Verifying Physical Memory ...FAILED (PRVF-7530)

Verifying Available Physical Memory ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     3.4932GB (3662916.0KB)    50MB (51200.0KB)          passed

  srlabrac1     3.3195GB (3480796.0KB)    50MB (51200.0KB)          passed

Verifying Available Physical Memory ...PASSED

Verifying Swap Size ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     8GB (8388604.0KB)         4.0866GB (4285092.0KB)    passed

  srlabrac1     8GB (8388604.0KB)         4.0866GB (4285092.0KB)    passed

Verifying Swap Size ...PASSED

Verifying Free Space: srlabrac2:/usr,srlabrac2:/var,srlabrac2:/etc,srlabrac2:/sbin ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /usr              srlabrac2     /             15.0371GB     25MB          passed

  /var              srlabrac2     /             15.0371GB     5MB           passed

  /etc              srlabrac2     /             15.0371GB     25MB          passed

  /sbin             srlabrac2     /             15.0371GB     10MB          passed

Verifying Free Space: srlabrac2:/usr,srlabrac2:/var,srlabrac2:/etc,srlabrac2:/sbin ...PASSED

Verifying Free Space: srlabrac2:/tmp ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /tmp              srlabrac2     /tmp          3.8047GB      1GB           passed

Verifying Free Space: srlabrac2:/tmp ...PASSED

Verifying Free Space: srlabrac1:/usr,srlabrac1:/var,srlabrac1:/etc,srlabrac1:/sbin ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /usr              srlabrac1     /             5.6953GB      25MB          passed

  /var              srlabrac1     /             5.6953GB      5MB           passed

  /etc              srlabrac1     /             5.6953GB      25MB          passed

  /sbin             srlabrac1     /             5.6953GB      10MB          passed

Verifying Free Space: srlabrac1:/usr,srlabrac1:/var,srlabrac1:/etc,srlabrac1:/sbin ...PASSED

Verifying Free Space: srlabrac1:/tmp ...

  Path              Node Name     Mount point   Available     Required      Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  /tmp              srlabrac1     /tmp          3.7949GB      1GB           passed

Verifying Free Space: srlabrac1:/tmp ...PASSED

Verifying User Existence: oracle ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists(54321)

  srlabrac1     passed                    exists(54321)


  Verifying Users With Same UID: 54321 ...PASSED

Verifying User Existence: oracle ...PASSED

Verifying Group Existence: asmadmin ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists

  srlabrac1     passed                    exists

Verifying Group Existence: asmadmin ...PASSED

Verifying Group Existence: asmdba ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists

  srlabrac1     passed                    exists

Verifying Group Existence: asmdba ...PASSED

Verifying Group Existence: oinstall ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    exists

  srlabrac1     passed                    exists

Verifying Group Existence: oinstall ...PASSED

Verifying Group Membership: asmadmin ...

  Node Name         User Exists   Group Exists  User in Group  Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         yes           yes           yes           passed

  srlabrac1         yes           yes           yes           passed

Verifying Group Membership: asmadmin ...PASSED

Verifying Group Membership: asmdba ...

  Node Name         User Exists   Group Exists  User in Group  Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         yes           yes           yes           passed

  srlabrac1         yes           yes           yes           passed

Verifying Group Membership: asmdba ...PASSED

Verifying Group Membership: oinstall(Primary) ...

  Node Name         User Exists   Group Exists  User in Group  Primary       Status

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac2         yes           yes           yes           yes           passed

  srlabrac1         yes           yes           yes           yes           passed

Verifying Group Membership: oinstall(Primary) ...PASSED

Verifying Run Level ...

  Node Name     run level                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     5                         3,5                       passed

  srlabrac1     5                         3,5                       passed

Verifying Run Level ...PASSED

Verifying Hard Limit: maximum open file descriptors ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         hard          65536         65536         passed

  srlabrac1         hard          65536         65536         passed

Verifying Hard Limit: maximum open file descriptors ...PASSED

Verifying Soft Limit: maximum open file descriptors ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          1024          1024          passed

  srlabrac1         soft          1024          1024          passed

Verifying Soft Limit: maximum open file descriptors ...PASSED

Verifying Hard Limit: maximum user processes ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         hard          16384         16384         passed

  srlabrac1         hard          16384         16384         passed

Verifying Hard Limit: maximum user processes ...PASSED

Verifying Soft Limit: maximum user processes ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          16384         2047          passed

  srlabrac1         soft          16384         2047          passed

Verifying Soft Limit: maximum user processes ...PASSED

Verifying Soft Limit: maximum stack size ...

  Node Name         Type          Available     Required      Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         soft          10240         10240         passed

  srlabrac1         soft          10240         10240         passed

Verifying Soft Limit: maximum stack size ...PASSED

Verifying Architecture ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     x86_64                    x86_64                    passed

  srlabrac1     x86_64                    x86_64                    passed

Verifying Architecture ...PASSED

Verifying OS Kernel Version ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     4.1.12-124.41.4.el7uek.x86_64  4.1.12                    passed

  srlabrac1     4.1.12-124.41.4.el7uek.x86_64  4.1.12                    passed

Verifying OS Kernel Version ...PASSED

Verifying OS Kernel Parameter: semmsl ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         250           250           250           passed

  srlabrac2         250           250           250           passed

Verifying OS Kernel Parameter: semmsl ...PASSED

Verifying OS Kernel Parameter: semmns ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         32000         32000         32000         passed

  srlabrac2         32000         32000         32000         passed

Verifying OS Kernel Parameter: semmns ...PASSED

Verifying OS Kernel Parameter: semopm ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         100           100           100           passed

  srlabrac2         100           100           100           passed

Verifying OS Kernel Parameter: semopm ...PASSED

Verifying OS Kernel Parameter: semmni ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         128           128           128           passed

  srlabrac2         128           128           128           passed

Verifying OS Kernel Parameter: semmni ...PASSED

Verifying OS Kernel Parameter: shmmax ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4398046511104  4398046511104  2193967104    passed

  srlabrac2         4398046511104  4398046511104  2193967104    passed

Verifying OS Kernel Parameter: shmmax ...PASSED

Verifying OS Kernel Parameter: shmmni ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4096          4096          4096          passed

  srlabrac2         4096          4096          4096          passed

Verifying OS Kernel Parameter: shmmni ...PASSED

Verifying OS Kernel Parameter: shmall ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1073741824    1073741824    1073741824    passed

  srlabrac2         1073741824    1073741824    1073741824    passed

Verifying OS Kernel Parameter: shmall ...PASSED

Verifying OS Kernel Parameter: file-max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         6815744       6815744       6815744       passed

  srlabrac2         6815744       6815744       6815744       passed

Verifying OS Kernel Parameter: file-max ...PASSED

Verifying OS Kernel Parameter: ip_local_port_range ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         between 9000 & 65500  between 9000 & 65500  between 9000 & 65535  passed

  srlabrac2         between 9000 & 65500  between 9000 & 65500  between 9000 & 65535  passed

Verifying OS Kernel Parameter: ip_local_port_range ...PASSED

Verifying OS Kernel Parameter: rmem_default ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         262144        262144        262144        passed

  srlabrac2         262144        262144        262144        passed

Verifying OS Kernel Parameter: rmem_default ...PASSED

Verifying OS Kernel Parameter: rmem_max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         4194304       4194304       4194304       passed

  srlabrac2         4194304       4194304       4194304       passed

Verifying OS Kernel Parameter: rmem_max ...PASSED

Verifying OS Kernel Parameter: wmem_default ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         262144        262144        262144        passed

  srlabrac2         262144        262144        262144        passed

Verifying OS Kernel Parameter: wmem_default ...PASSED

Verifying OS Kernel Parameter: wmem_max ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1048576       1048576       1048576       passed

  srlabrac2         1048576       1048576       1048576       passed

Verifying OS Kernel Parameter: wmem_max ...PASSED

Verifying OS Kernel Parameter: aio-max-nr ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1048576       1048576       1048576       passed

  srlabrac2         1048576       1048576       1048576       passed

Verifying OS Kernel Parameter: aio-max-nr ...PASSED

Verifying OS Kernel Parameter: panic_on_oops ...

  Node Name         Current       Configured    Required      Status        Comment

  ----------------  ------------  ------------  ------------  ------------  ------------

  srlabrac1         1             1             1             passed

  srlabrac2         1             1             1             passed

Verifying OS Kernel Parameter: panic_on_oops ...PASSED

Verifying Package: kmod-20-21 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     kmod(x86_64)-20-28.0.3.el7  kmod(x86_64)-20-21        passed

  srlabrac1     kmod(x86_64)-20-28.0.3.el7  kmod(x86_64)-20-21        passed

Verifying Package: kmod-20-21 (x86_64) ...PASSED

Verifying Package: kmod-libs-20-21 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     kmod-libs(x86_64)-20-28.0.3.el7  kmod-libs(x86_64)-20-21   passed

  srlabrac1     kmod-libs(x86_64)-20-28.0.3.el7  kmod-libs(x86_64)-20-21   passed

Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED

Verifying Package: binutils-2.23.52.0.1 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     binutils-2.27-43.base.0.1.el7_8.1  binutils-2.23.52.0.1      passed

  srlabrac1     binutils-2.27-43.base.0.1.el7_8.1  binutils-2.23.52.0.1      passed

Verifying Package: binutils-2.23.52.0.1 ...PASSED

Verifying Package: compat-libcap1-1.10 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     compat-libcap1-1.10-7.el7  compat-libcap1-1.10       passed

  srlabrac1     compat-libcap1-1.10-7.el7  compat-libcap1-1.10       passed

Verifying Package: compat-libcap1-1.10 ...PASSED

Verifying Package: libgcc-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libgcc(x86_64)-4.8.5-39.0.5.el7  libgcc(x86_64)-4.8.2      passed

  srlabrac1     libgcc(x86_64)-4.8.5-39.0.5.el7  libgcc(x86_64)-4.8.2      passed

Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED

Verifying Package: libstdc++-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libstdc++(x86_64)-4.8.5-39.0.5.el7  libstdc++(x86_64)-4.8.2   passed

  srlabrac1     libstdc++(x86_64)-4.8.5-39.0.5.el7  libstdc++(x86_64)-4.8.2   passed

Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED

Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libstdc++-devel(x86_64)-4.8.5-39.0.5.el7  libstdc++-devel(x86_64)-4.8.2  passed

  srlabrac1     libstdc++-devel(x86_64)-4.8.5-39.0.5.el7  libstdc++-devel(x86_64)-4.8.2  passed

Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED

Verifying Package: sysstat-10.1.5 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     sysstat-10.1.5-19.el7     sysstat-10.1.5            passed

  srlabrac1     sysstat-10.1.5-19.el7     sysstat-10.1.5            passed

Verifying Package: sysstat-10.1.5 ...PASSED

Verifying Package: ksh ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     ksh                       ksh                       passed

  srlabrac1     ksh                       ksh                       passed

Verifying Package: ksh ...PASSED

Verifying Package: make-3.82 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     make-3.82-24.el7          make-3.82                 passed

  srlabrac1     make-3.82-24.el7          make-3.82                 passed

Verifying Package: make-3.82 ...PASSED

Verifying Package: glibc-2.17 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     glibc(x86_64)-2.17-307.0.1.el7.1  glibc(x86_64)-2.17        passed

  srlabrac1     glibc(x86_64)-2.17-307.0.1.el7.1  glibc(x86_64)-2.17        passed

Verifying Package: glibc-2.17 (x86_64) ...PASSED

Verifying Package: glibc-devel-2.17 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     glibc-devel(x86_64)-2.17-307.0.1.el7.1  glibc-devel(x86_64)-2.17  passed

  srlabrac1     glibc-devel(x86_64)-2.17-307.0.1.el7.1  glibc-devel(x86_64)-2.17  passed

Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED

Verifying Package: libaio-0.3.109 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libaio(x86_64)-0.3.109-13.el7  libaio(x86_64)-0.3.109    passed

  srlabrac1     libaio(x86_64)-0.3.109-13.el7  libaio(x86_64)-0.3.109    passed

Verifying Package: libaio-0.3.109 (x86_64) ...PASSED

Verifying Package: libaio-devel-0.3.109 (x86_64) ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     libaio-devel(x86_64)-0.3.109-13.el7  libaio-devel(x86_64)-0.3.109  passed

  srlabrac1     libaio-devel(x86_64)-0.3.109-13.el7  libaio-devel(x86_64)-0.3.109  passed

Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED

Verifying Package: nfs-utils-1.2.3-15 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     nfs-utils-1.3.0-0.66.0.1.el7_8  nfs-utils-1.2.3-15        passed

  srlabrac1     nfs-utils-1.3.0-0.66.0.1.el7_8  nfs-utils-1.2.3-15        passed

Verifying Package: nfs-utils-1.2.3-15 ...PASSED

Verifying Package: smartmontools-6.2-4 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     smartmontools-7.0-2.el7   smartmontools-6.2-4       passed

  srlabrac1     smartmontools-7.0-2.el7   smartmontools-6.2-4       passed

Verifying Package: smartmontools-6.2-4 ...PASSED

Verifying Package: net-tools-2.0-0.17 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     net-tools-2.0-0.25.20131004git.el7  net-tools-2.0-0.17        passed

  srlabrac1     net-tools-2.0-0.25.20131004git.el7  net-tools-2.0-0.17        passed

Verifying Package: net-tools-2.0-0.17 ...PASSED

Verifying Port Availability for component "Oracle Notification Service (ONS)" ...

  Node Name         Port Number   Protocol      Available     Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         6200          TCP           yes           successful

  srlabrac1         6200          TCP           yes           successful

  srlabrac2         6100          TCP           yes           successful

  srlabrac1         6100          TCP           yes           successful

Verifying Port Availability for component "Oracle Notification Service (ONS)" ...PASSED

Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...

  Node Name         Port Number   Protocol      Available     Status

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         42424         TCP           yes           successful

  srlabrac1         42424         TCP           yes           successful

Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...PASSED

Verifying Users With Same UID: 0 ...PASSED

Verifying Current Group ID ...PASSED

Verifying Root user consistency ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac2                             passed

  srlabrac1                             passed

Verifying Root user consistency ...PASSED

Verifying Package: cvuqdisk-1.0.10-1 ...

  Node Name     Available                 Required                  Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     cvuqdisk-1.0.10-1         cvuqdisk-1.0.10-1         passed

  srlabrac1     cvuqdisk-1.0.10-1         cvuqdisk-1.0.10-1         passed

Verifying Package: cvuqdisk-1.0.10-1 ...PASSED

Verifying Host name ...PASSED

Verifying Node Connectivity ...

  Verifying Hosts File ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed

  Verifying Hosts File ...PASSED


Interface information for node "srlabrac2"


 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 enp0s8 192.168.58.202  192.168.58.0    0.0.0.0         192.168.58.1    08:00:27:06:51:8C 1500

 enp0s9 192.168.10.2    192.168.10.0    0.0.0.0         192.168.58.1    08:00:27:7A:F4:34 1500

 virbr0 192.168.122.1   192.168.122.0   0.0.0.0         192.168.58.1    52:54:00:7E:A4:39 1500


Interface information for node "srlabrac1"


 Name   IP Address      Subnet          Gateway         Def. Gateway    HW Address        MTU

 ------ --------------- --------------- --------------- --------------- ----------------- ------

 enp0s8 192.168.58.201  192.168.58.0    0.0.0.0         192.168.58.1    08:00:27:ED:B2:B6 1500

 enp0s9 192.168.10.1    192.168.10.0    0.0.0.0         192.168.58.1    08:00:27:21:0A:B7 1500

 virbr0 192.168.122.1   192.168.122.0   0.0.0.0         192.168.58.1    52:54:00:7E:A4:39 1500


Check: MTU consistency of the subnet "192.168.10.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         enp0s9        192.168.10.2  192.168.10.0  1500

  srlabrac1         enp0s9        192.168.10.1  192.168.10.0  1500


Check: MTU consistency of the subnet "192.168.122.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         virbr0        192.168.122.1  192.168.122.0  1500

  srlabrac1         virbr0        192.168.122.1  192.168.122.0  1500


Check: MTU consistency of the subnet "192.168.58.0".


  Node              Name          IP Address    Subnet        MTU

  ----------------  ------------  ------------  ------------  ----------------

  srlabrac2         enp0s8        192.168.58.202  192.168.58.0  1500

  srlabrac1         enp0s8        192.168.58.201  192.168.58.0  1500

  Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[enp0s9:192.168.10.1]  srlabrac2[enp0s9:192.168.10.2]  yes


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[virbr0:192.168.122.1]  srlabrac2[virbr0:192.168.122.1]  yes


  Source                          Destination                     Connected?

  ------------------------------  ------------------------------  ----------------

  srlabrac1[enp0s8:192.168.58.201]  srlabrac2[enp0s8:192.168.58.202]  yes

  Verifying subnet mask consistency for subnet "192.168.10.0" ...PASSED

  Verifying subnet mask consistency for subnet "192.168.122.0" ...PASSED

  Verifying subnet mask consistency for subnet "192.168.58.0" ...PASSED

Verifying Node Connectivity ...FAILED (PRVG-1172, PRVG-11067, PRVG-11095)

Verifying Multicast or broadcast check ...

Checking subnet "192.168.10.0" for multicast communication with multicast group "224.0.0.251"

Verifying Multicast or broadcast check ...PASSED

Verifying ASMLib installation and configuration verification. ...

  Verifying '/etc/init.d/oracleasm' ...PASSED

  Verifying '/dev/oracleasm' ...PASSED

  Verifying '/etc/sysconfig/oracleasm' ...PASSED


  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed

Verifying ASMLib installation and configuration verification. ...PASSED

Verifying Network Time Protocol (NTP) ...

  Verifying '/etc/chrony.conf' ...

  Node Name                             File exists?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying '/etc/chrony.conf' ...PASSED

  Verifying Daemon 'chronyd' ...

  Node Name                             Running?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying Daemon 'chronyd' ...PASSED

  Verifying NTP daemon or service using UDP port 123 ...

  Node Name                             Port Open?

  ------------------------------------  ------------------------

  srlabrac2                             yes

  srlabrac1                             yes


  Verifying NTP daemon or service using UDP port 123 ...PASSED

  Verifying chrony daemon is synchronized with at least one external time source ...FAILED (PRVG-13606)

Verifying Network Time Protocol (NTP) ...FAILED (PRVG-13606)

Verifying Same core file name pattern ...PASSED

Verifying User Mask ...

  Node Name     Available                 Required                  Comment

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     0022                      0022                      passed

  srlabrac1     0022                      0022                      passed

Verifying User Mask ...PASSED

Verifying User Not In Group "root": oracle ...

  Node Name     Status                    Comment

  ------------  ------------------------  ------------------------

  srlabrac2     passed                    does not exist

  srlabrac1     passed                    does not exist

Verifying User Not In Group "root": oracle ...PASSED

Verifying Time zone consistency ...PASSED

Verifying Time offset between nodes ...PASSED

Verifying resolv.conf Integrity ...

  Node Name                             Status

  ------------------------------------  ------------------------

  srlabrac1                             passed

  srlabrac2                             passed


checking response for name "srlabrac1" from each of the name servers specified

in "/etc/resolv.conf"


  Node Name     Source                    Comment                   Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac1     192.168.58.201            IPv4                      failed


checking response for name "srlabrac2" from each of the name servers specified

in "/etc/resolv.conf"


  Node Name     Source                    Comment                   Status

  ------------  ------------------------  ------------------------  ----------

  srlabrac2     192.168.58.202            IPv4                      failed

Verifying resolv.conf Integrity ...FAILED (PRVG-10048)

Verifying DNS/NIS name service ...PASSED

Verifying Domain Sockets ...PASSED

Verifying /boot mount ...PASSED

Verifying Daemon "avahi-daemon" not configured and running ...

  Node Name     Configured                Status

  ------------  ------------------------  ------------------------

  srlabrac2     yes                       failed

  srlabrac1     yes                       failed


  Node Name     Running?                  Status

  ------------  ------------------------  ------------------------

  srlabrac2     yes                       failed

  srlabrac1     yes                       failed

Verifying Daemon "avahi-daemon" not configured and running ...FAILED (PRVG-1359, PRVG-1360)

Verifying Daemon "proxyt" not configured and running ...

  Node Name     Configured                Status

  ------------  ------------------------  ------------------------

  srlabrac2     no                        passed

  srlabrac1     no                        passed


  Node Name     Running?                  Status

  ------------  ------------------------  ------------------------

  srlabrac2     no                        passed

  srlabrac1     no                        passed

Verifying Daemon "proxyt" not configured and running ...PASSED

Verifying User Equivalence ...PASSED

Verifying RPM Package Manager database ...INFORMATION (PRVG-11250)

Verifying /dev/shm mounted as temporary file system ...PASSED

Verifying File system mount options for path /var ...PASSED

Verifying DefaultTasksMax parameter ...PASSED

Verifying zeroconf check ...PASSED

Verifying ASM Filter Driver configuration ...PASSED

Verifying Systemd login manager IPC parameter ...PASSED


Pre-check for cluster services setup was unsuccessful on all the nodes.



Failures were encountered during execution of CVU verification request "stage -pre crsinst".


Verifying Physical Memory ...FAILED

srlabrac2: PRVF-7530 : Sufficient physical memory is not available on node

           "srlabrac2" [Required physical memory = 8GB (8388608.0KB)]


srlabrac1: PRVF-7530 : Sufficient physical memory is not available on node

           "srlabrac1" [Required physical memory = 8GB (8388608.0KB)]


Verifying Node Connectivity ...FAILED

PRVG-1172 : The IP address "192.168.122.1" is on multiple interfaces "virbr0"

on nodes "srlabrac2,srlabrac1"


srlabrac2: PRVG-11067 : TCP connectivity from node "srlabrac2": "192.168.122.1"

           to node "srlabrac2": "192.168.122.1" failed.

           PRVG-11095 : The TCP system call "connect" failed with error "111"

           while executing exectask on node "srlabrac2"

           Connection refused

srlabrac2: PRVG-11067 : TCP connectivity from node "srlabrac2": "192.168.122.1"

           to node "srlabrac1": "192.168.122.1" failed.

           PRVG-11095 : The TCP system call "connect" failed with error "111"

           while executing exectask on node "srlabrac2"

           Connection refused


Verifying Network Time Protocol (NTP) ...FAILED

  Verifying chrony daemon is synchronized with at least one external time

  source ...FAILED

  srlabrac2: PRVG-13606 : chrony daemon is not synchronized with any external

             time source on node "srlabrac2".


  srlabrac1: PRVG-13606 : chrony daemon is not synchronized with any external

             time source on node "srlabrac1".


Verifying resolv.conf Integrity ...FAILED

srlabrac2: PRVG-10048 : Name "srlabrac2" was not resolved to an address of the

           specified type by name servers "192.168.58.202".


srlabrac1: PRVG-10048 : Name "srlabrac1" was not resolved to an address of the

           specified type by name servers "192.168.58.201".


Verifying Daemon "avahi-daemon" not configured and running ...FAILED

srlabrac2: PRVG-1359 : Daemon process "avahi-daemon" is configured on node

           "srlabrac2"

srlabrac2: PRVG-1360 : Daemon process "avahi-daemon" is running on node

           "srlabrac2"


srlabrac1: PRVG-1359 : Daemon process "avahi-daemon" is configured on node

           "srlabrac1"

srlabrac1: PRVG-1360 : Daemon process "avahi-daemon" is running on node

           "srlabrac1"


Verifying RPM Package Manager database ...INFORMATION

PRVG-11250 : The check "RPM Package Manager database" was not performed because

it needs 'root' user privileges.



CVU operation performed:      stage -pre crsinst

Date:                         Aug 29, 2020 3:59:09 AM

CVU home:                     /u01/app/19.3.0.0/grid_1/

User:                         oracle


[root@srlabrac1 srcdb2]# hostname

srlabrac1.localdomain

[root@srlabrac1 srcdb2]# /u01/app/19.3.0.0/grid_1/root.sh

Performing root user operation.


The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/19.3.0.0/grid_1


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.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.3.0.0/grid_1/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/srlabrac1/crsconfig/rootcrs_srlabrac1_2020-08-29_04-50-22AM.log

2020/08/29 04:51:41 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/08/29 04:51:42 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/08/29 04:51:42 CLSRSC-363: User ignored prerequisites during installation

2020/08/29 04:51:42 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/08/29 04:51:54 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/08/29 04:51:59 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/08/29 04:51:59 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/08/29 04:52:03 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/08/29 04:55:40 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/08/29 04:56:20 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/08/29 04:56:25 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/08/29 04:57:28 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/08/29 04:57:29 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/08/29 04:58:08 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/08/29 04:58:10 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2020/08/29 05:05:23 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/08/29 05:05:54 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/08/29 05:13:43 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/08/29 05:14:10 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.


ASM has been created and started successfully.


[DBT-30001] Disk groups created successfully. Check /u01/app/oracle/cfgtoollogs/asmca/asmca-200829AM051600.log for details.


2020/08/29 05:18:38 CLSRSC-482: Running command: '/u01/app/19.3.0.0/grid_1/bin/ocrconfig -upgrade oracle oinstall'

CRS-4256: Updating the profile

Successful addition of voting disk fa52a8fa083f4f85bf1250f69562b0ce.

Successfully replaced voting disk group with +OCRVOTE.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   fa52a8fa083f4f85bf1250f69562b0ce (/dev/oracleasm/disks/VOTE) [OCRVOTE]

Located 1 voting disk(s).

2020/08/29 05:25:30 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/08/29 05:28:19 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/08/29 05:28:20 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/08/29 05:40:12 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/08/29 05:45:22 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@srlabrac1 srcdb2]#



[oracle@srlabrac1 ~]$ . oraenv

ORACLE_SID = [SRLABDB] ? +ASM1

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@srlabrac1 ~]$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 29 07:00:40 2020

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> select instance_name from v$instance;


INSTANCE_NAME

----------------

+ASM1


SQL>

SQL>

SQL>

SQL>

SQL>

SQL> set lines 300 pages 2000

SQL>

SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

OCRVOTE                           19.9960938   19.6679688 MOUNTED


SQL> col path for a40

SQL> select name,path,os_mb/1024,total_mb/1024,free_mb/1024,state from v$asm_disk;


NAME                           PATH                                     OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ---------------------------------------- ---------- ------------- ------------ --------

                               /dev/oracleasm/disks/DATA                39.9990234             0            0 NORMAL

OCRVOTE_0000                   /dev/oracleasm/disks/VOTE                19.9990234    19.9960938   19.6679688 NORMAL


SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@srlabrac1 ~]$ sqlplus / as sysasm


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 29 07:12:58 2020

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> set lines 300 pages 2000

SQL>

SQL> CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA';


Diskgroup created.


SQL> col path for a40

SQL> select name,path,os_mb/1024,total_mb/1024,free_mb/1024,state from v$asm_disk;


NAME                           PATH                                     OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ---------------------------------------- ---------- ------------- ------------ --------

OCRVOTE_0000                   /dev/oracleasm/disks/VOTE                19.9990234    19.9960938   19.6679688 NORMAL

DATA_0000                      /dev/oracleasm/disks/DATA                39.9990234    39.9990234   39.9482422 NORMAL


SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

OCRVOTE                           19.9960938   19.6679688 MOUNTED

DATA                              39.9990234   39.9482422 MOUNTED


SQL> select * from v$asm_operation;


no rows selected


SQL>

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0



[oracle@srlabrac1 ~]$

[oracle@srlabrac1 ~]$

[oracle@srlabrac1 ~]$ ps -ef |grep d.bin

oracle    7529  3777  0 07:21 pts/1    00:00:00 grep --color=auto d.bin

root     22230     1  5 05:25 ?        00:05:54 /u01/app/19.3.0.0/grid_1/bin/ohasd.bin reboot BLOCKING_STACK_LOCALE_OHAS=AMERICAN_AMERICA.AL32UTF8

oracle   22953     1  0 05:25 ?        00:00:34 /u01/app/19.3.0.0/grid_1/bin/mdnsd.bin

oracle   22955     1  1 05:25 ?        00:01:45 /u01/app/19.3.0.0/grid_1/bin/evmd.bin

oracle   23063     1  0 05:26 ?        00:00:39 /u01/app/19.3.0.0/grid_1/bin/gpnpd.bin

oracle   23172     1  1 05:26 ?        00:01:46 /u01/app/19.3.0.0/grid_1/bin/gipcd.bin

root     23214     1  9 05:26 ?        00:10:57 /u01/app/19.3.0.0/grid_1/bin/osysmond.bin

oracle   23335     1  3 05:26 ?        00:04:25 /u01/app/19.3.0.0/grid_1/bin/ocssd.bin  -S 1

root     23635     1  1 05:26 ?        00:01:38 /u01/app/19.3.0.0/grid_1/bin/octssd.bin reboot

root     24058     1  5 05:27 ?        00:05:47 /u01/app/19.3.0.0/grid_1/bin/crsd.bin reboot

[oracle@srlabrac1 ~]$ ps -ef |grep pmon

oracle    7849  3777  0 07:21 pts/1    00:00:00 grep --color=auto pmon

oracle   23873     1  0 05:27 ?        00:00:01 asm_pmon_+ASM1

[oracle@srlabrac1 ~]$ ps -ef |grep tns

root        22     2  0 02:06 ?        00:00:00 [netns]

oracle    1719     1  0 05:43 ?        00:00:00 /u01/app/19.3.0.0/grid_1/bin/tnslsnr LISTENER -no_crs_notify -inherit

oracle    7944  3777  0 07:22 pts/1    00:00:00 grep --color=auto tns

oracle   28260     1  0 05:36 ?        00:00:10 /u01/app/19.3.0.0/grid_1/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit

oracle   29567     1  0 05:38 ?        00:00:00 /u01/app/19.3.0.0/grid_1/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit

oracle   29634     1  0 05:38 ?        00:00:00 /u01/app/19.3.0.0/grid_1/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit

[oracle@srlabrac1 ~]$ crsctl check cluster -all

**************************************************************

srlabrac1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

srlabrac2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[oracle@srlabrac1 ~]$ crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[oracle@srlabrac1 ~]$ crsctl check has

CRS-4638: Oracle High Availability Services is online

[oracle@srlabrac1 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.chad

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.net1.network

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.ons

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.proxy_advm

               OFFLINE OFFLINE      srlabrac1                STABLE

               OFFLINE OFFLINE      srlabrac2                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.DATA.dg(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       srlabrac2                STABLE

ora.LISTENER_SCAN2.lsnr

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.LISTENER_SCAN3.lsnr

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.OCRVOTE.dg(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                Started,STABLE

      2        ONLINE  ONLINE       srlabrac2                Started,STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.qosmserver

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       srlabrac2                STABLE

ora.scan2.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.scan3.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.srlabrac1.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.srlabrac2.vip

      1        ONLINE  ONLINE       srlabrac2                STABLE

--------------------------------------------------------------------------------

[oracle@srlabrac1 ~]$


Node2: 

-----


-rw-r--r--. 1 oracle oinstall 11412 Aug 29 03:57 cvuqdisk-1.0.10-1.rpm

[root@srlabrac2 tmp]# yum install cvuqdisk-1.0.10-1.rpm

Loaded plugins: langpacks, ulninfo

Examining cvuqdisk-1.0.10-1.rpm: cvuqdisk-1.0.10-1.x86_64

Marking cvuqdisk-1.0.10-1.rpm to be installed

Resolving Dependencies

--> Running transaction check

---> Package cvuqdisk.x86_64 0:1.0.10-1 will be installed

--> Finished Dependency Resolution

https://yum.oracle.com/repo/OracleLinux/OL7/UEKR4/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"

Trying other mirror.

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/repodata/repomd.xml: [Errno 14] curl#6 - "Could not resolve host: yum.oracle.com; Unknown error"

Trying other mirror.


Dependencies Resolved


=======================================================================================================

 Package               Arch                Version               Repository                       Size

=======================================================================================================

Installing:

 cvuqdisk              x86_64              1.0.10-1              /cvuqdisk-1.0.10-1               22 k


Transaction Summary

=======================================================================================================

Install  1 Package


Total size: 22 k

Installed size: 22 k

Is this ok [y/d/N]: y

Downloading packages:

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

  Installing : cvuqdisk-1.0.10-1.x86_64                                                            1/1

  Verifying  : cvuqdisk-1.0.10-1.x86_64                                                            1/1


Installed:

  cvuqdisk.x86_64 0:1.0.10-1


Complete!

[root@srlabrac2 tmp]# cd /u01/app/19.3.0.0/

[root@srlabrac2 19.3.0.0]# ls -lrt

total 4

drwxrwxr-x. 2 oracle oinstall 4096 Aug 29 03:03 grid_1

[root@srlabrac2 19.3.0.0]# chown -R oracle:oinstall grid_1/

[root@srlabrac2 19.3.0.0]# cd /dev/oracleasm/disks/

[root@srlabrac2 disks]# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Cleaning disk "DATA"

Cleaning disk "OCRVOTE"

Scanning system for ASM disks...

[root@srlabrac2 disks]#

[root@srlabrac2 disks]# oracleasm scandisks

Reloading disk partitions: done

Cleaning any stale ASM disks...

Scanning system for ASM disks...

Instantiating disk "VOTE"

Instantiating disk "DATA"

[root@srlabrac2 disks]# oracleasm listdisks

DATA

VOTE

[root@srlabrac2 disks]# /u01/app/19.3.0.0/grid_1/root.sh

Performing root user operation.


The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/19.3.0.0/grid_1


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.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.3.0.0/grid_1/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/oracle/crsdata/srlabrac2/crsconfig/rootcrs_srlabrac2_2020-08-29_05-51-11AM.log

2020/08/29 05:52:18 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/08/29 05:52:18 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/08/29 05:52:19 CLSRSC-363: User ignored prerequisites during installation

2020/08/29 05:52:19 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/08/29 05:52:31 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/08/29 05:52:31 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/08/29 05:52:32 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/08/29 05:52:38 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/08/29 05:52:50 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/08/29 05:52:50 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/08/29 05:53:37 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/08/29 05:53:38 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/08/29 05:54:04 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/08/29 05:54:07 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2020/08/29 06:01:14 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/08/29 06:12:23 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/08/29 06:12:44 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/08/29 06:23:15 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/08/29 06:23:31 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

2020/08/29 06:24:50 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/08/29 06:26:59 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/08/29 06:27:01 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/08/29 06:31:24 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/08/29 06:32:41 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@srlabrac2 disks]#

[oracle@srlabrac2 ~]$ . oraenv

ORACLE_SID = [SRCDB1SBY] ? +ASM2

The Oracle base remains unchanged with value /u01/app/oracle

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ sqlplus / as sysdba


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 29 07:01:19 2020

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> select instance_name from v$instance;


INSTANCE_NAME

----------------

+ASM2


SQL> set lines 300 pages 2000

SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

OCRVOTE                           19.9960938   19.6679688 MOUNTED


SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

DATA                                       0            0 DISMOUNTED

OCRVOTE                           19.9960938   19.6679688 MOUNTED


SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ sqlplus / as sysasm


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 29 07:15:50 2020

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> set lines 300 pages 2000

SQL>

SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

DATA                                       0            0 DISMOUNTED

OCRVOTE                           19.9960938   19.6679688 MOUNTED


SQL> col path for a40

SQL> select name,path,os_mb/1024,total_mb/1024,free_mb/1024,state from v$asm_disk;


NAME                           PATH                                     OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ---------------------------------------- ---------- ------------- ------------ --------

                               /dev/oracleasm/disks/DATA                39.9990234             0          0 NORMAL

OCRVOTE_0000                   /dev/oracleasm/disks/VOTE                19.9990234    19.9960938   19.6679688 NORMAL


SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  4194304     20476    20140                0           20140              0             Y  OCRVOTE/

ASMCMD>

ASMCMD> mount DATA

ASMCMD> lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  1048576     40959    40864                0           40864              0             N  DATA/

MOUNTED  EXTERN  N         512             512   4096  4194304     20476    20140                0           20140              0             Y  OCRVOTE/

ASMCMD> exit

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ sqlplus / as sysasm


SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 29 07:20:01 2020

Version 19.3.0.0.0


Copyright (c) 1982, 2019, Oracle.  All rights reserved.



Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0


SQL> set lines 300 pages 2000

SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

OCRVOTE                           19.9960938   19.6679688 MOUNTED

DATA                              39.9990234     39.90625 MOUNTED


SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ ps -ef |grep d.bin

root     13941     1  4 06:24 ?        00:02:29 /u01/app/19.3.0.0/grid_1/bin/ohasd.bin reboot BLOCKING_STACK_LOCALE_OHAS=AMERICAN_AMERICA.AL32UTF8

oracle   14374     1  0 06:25 ?        00:00:16 /u01/app/19.3.0.0/grid_1/bin/mdnsd.bin

oracle   14376     1  1 06:25 ?        00:00:58 /u01/app/19.3.0.0/grid_1/bin/evmd.bin

oracle   14427     1  0 06:25 ?        00:00:21 /u01/app/19.3.0.0/grid_1/bin/gpnpd.bin

oracle   14648     1  2 06:25 ?        00:01:06 /u01/app/19.3.0.0/grid_1/bin/gipcd.bin

root     14728     1  9 06:25 ?        00:04:55 /u01/app/19.3.0.0/grid_1/bin/osysmond.bin

oracle   14780     1  5 06:25 ?        00:02:48 /u01/app/19.3.0.0/grid_1/bin/ocssd.bin  -S 2

root     15052     1  1 06:26 ?        00:00:53 /u01/app/19.3.0.0/grid_1/bin/octssd.bin reboot

root     15222     1  2 06:26 ?        00:01:19 /u01/app/19.3.0.0/grid_1/bin/crsd.bin reboot

oracle   18636  3622  0 07:20 pts/1    00:00:00 grep --color=auto d.bin

[oracle@srlabrac2 ~]$ crsctl check cluster -all

**************************************************************

srlabrac1:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

srlabrac2:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

[oracle@srlabrac2 ~]$ ps -ef |grep tns

root        22     2  0 02:10 ?        00:00:00 [netns]

oracle   15775     1  0 06:27 ?        00:00:00 /u01/app/19.3.0.0/grid_1/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit

oracle   15818     1  0 06:27 ?        00:00:05 /u01/app/19.3.0.0/grid_1/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit

oracle   18366     1  0 06:32 ?        00:00:00 /u01/app/19.3.0.0/grid_1/bin/tnslsnr LISTENER -no_crs_notify -inherit

oracle   18846  3622  0 07:20 pts/1    00:00:00 grep --color=auto tns

[oracle@srlabrac2 ~]$ crsctl check has

CRS-4638: Oracle High Availability Services is online

[oracle@srlabrac2 ~]$ crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.chad

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.net1.network

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.ons

               ONLINE  ONLINE       srlabrac1                STABLE

               ONLINE  ONLINE       srlabrac2                STABLE

ora.proxy_advm

               OFFLINE OFFLINE      srlabrac1                STABLE

               OFFLINE OFFLINE      srlabrac2                STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.DATA.dg(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       srlabrac2                STABLE

ora.LISTENER_SCAN2.lsnr

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.LISTENER_SCAN3.lsnr

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.OCRVOTE.dg(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                Started,STABLE

      2        ONLINE  ONLINE       srlabrac2                Started,STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       srlabrac1                STABLE

      2        ONLINE  ONLINE       srlabrac2                STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.qosmserver

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       srlabrac2                STABLE

ora.scan2.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.scan3.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.srlabrac1.vip

      1        ONLINE  ONLINE       srlabrac1                STABLE

ora.srlabrac2.vip

      1        ONLINE  ONLINE       srlabrac2                STABLE

--------------------------------------------------------------------------------

[oracle@srlabrac2 ~]$


Create Disk Group Manually:

--------------------------


CREATE DISKGROUP DATA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/DATA';


On 2nd Node its showing dismounted. So we need to do the following steps.


SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

DATA                                       0            0 DISMOUNTED

OCRVOTE                           19.9960938   19.6679688 MOUNTED


SQL> col path for a40

SQL> select name,path,os_mb/1024,total_mb/1024,free_mb/1024,state from v$asm_disk;


NAME                           PATH                                     OS_MB/1024 TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ---------------------------------------- ---------- ------------- ------------ --------

                               /dev/oracleasm/disks/DATA                39.9990234             0          0 NORMAL

OCRVOTE_0000                   /dev/oracleasm/disks/VOTE                19.9990234    19.9960938   19.6679688 NORMAL


SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$

[oracle@srlabrac2 ~]$ asmcmd

ASMCMD> lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  4194304     20476    20140                0           20140              0             Y  OCRVOTE/

ASMCMD>

ASMCMD> mount DATA

ASMCMD> lsdg

State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name

MOUNTED  EXTERN  N         512             512   4096  1048576     40959    40864                0           40864              0             N  DATA/

MOUNTED  EXTERN  N         512             512   4096  4194304     20476    20140                0           20140              0             Y  OCRVOTE/


SQL> select name,total_mb/1024,free_mb/1024,state from v$asm_diskgroup;


NAME                           TOTAL_MB/1024 FREE_MB/1024 STATE

------------------------------ ------------- ------------ -----------

OCRVOTE                           19.9960938   19.6679688 MOUNTED

DATA                              39.9990234     39.90625 MOUNTED



Regards,

Ramesh.



Please follow me on:


DBA BLOG:https://www.sachinrameshoracledbablog.com

YOUTUBE: https://www.youtube.com/oraclef1

TWITTER: https://twitter.com/sachinrameshdba

FACEBOOK: https://www.facebook.com/rameshkumar.krishnamoorthy.9

LINKEDIN:https://www.linkedin.com/in/ramesh-kumar-krishnamoorthy-3a67ba69

INSTAGRAM: https://www.instagram.com/oraclef1

Email: oraclehelplines@gmail.com







1 comments :