Description:-
In this article we are going to see step by step Deploying Oracle 19c Grid Infrastructure for a Standalone Server
Note:- Click the below link to complete oracle 19c Grid and oracle installation
Step:-1 Oracle Cloud Vm Machine-Create VM machine For Oracle 19c ASM Configuration
Step:-2 Oracle Cloud Vm Machine-Oracle 19c Configuration ASM Storage For A Standalone Database
Step:-3 Oracle Cloud Vm Machine-Oracle 19c Configuration Grid And Database Installation
Step:-4 Oracle Cloud Vm Machine-Oracle 19c installation Grid Infrastructure for a Standalone Server
Step:-5 Oracle Cloud Vm Machine-Oracle 19c installation for a Standalone Server
High level steps:-
- Cluvfy verification
- Login to Vncserver
- install oracle 19c Grid software
- Check the status of grid process
- Create ASM Diskgroup
- Check the cluster resource
Step:-1 Disable avahi-daemon
[root@orcldbwr ~]# systemctl disable avahi-daemon.socket avahi-daemon.service
Removed symlink /etc/systemd/system/multi-user.target.wants/avahi-daemon.service .
Removed symlink /etc/systemd/system/sockets.target.wants/avahi-daemon.socket.
Removed symlink /etc/systemd/system/dbus-org.freedesktop.Avahi.service.
[root@orcldbwr ~]# systemctl mask avahi-daemon.socket avahi-daemon.service
Created symlink from /etc/systemd/system/avahi-daemon.socket to /dev/null.
Created symlink from /etc/systemd/system/avahi-daemon.service to /dev/null.
[root@orcldbwr ~]# systemctl stop avahi-daemon.socket avahi-daemon.service
Step:-2 Execute Cluvfy verification
[oracle@orcldbwr ~]$ . .bash_profile
[oracle@orcldbwr ~]$ . .grid.env
[oracle@orcldbwr ~]$ cd $ORACLE_HOME
[oracle@orcldbwr grid]$ ./runcluvfy.sh stage -pre crsinst -n orcldbwr -verbose
Verifying Physical Memory …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 23.2738GB (2.4404332E7KB) 8GB (8388608.0KB) passed
Verifying Physical Memory …PASSED
Verifying Available Physical Memory …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 21.3836GB (2.2422372E7KB) 50MB (51200.0KB) passed
Verifying Available Physical Memory …PASSED
Verifying Swap Size …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 8GB (8388604.0KB) 16GB (1.6777216E7KB) failed
Verifying Swap Size …FAILED (PRVF-7573)
Verifying Free Space: orcldbwr:/usr,orcldbwr:/var,orcldbwr:/etc,orcldbwr:/sbin,orcldbwr:/tmp …
Path Node Name Mount point Available Required Status
—————- ———— ———— ———— ———— ————
/usr orcldbwr / 19.5361GB 25MB passed
/var orcldbwr / 19.5361GB 5MB passed
/etc orcldbwr / 19.5361GB 25MB passed
/sbin orcldbwr / 19.5361GB 10MB passed
/tmp orcldbwr / 19.5361GB 1GB passed
Verifying Free Space: orcldbwr:/usr,orcldbwr:/var,orcldbwr:/etc,orcldbwr:/sbin,orcldbwr:/tmp …PASSED
Verifying User Existence: oracle …
Node Name Status Comment
———— ———————— ————————
orcldbwr passed exists(54321)
Verifying Users With Same UID: 54321 …PASSED
Verifying User Existence: oracle …PASSED
Verifying Group Existence: asmadmin …
Node Name Status Comment
———— ———————— ————————
orcldbwr passed exists
Verifying Group Existence: asmadmin …PASSED
Verifying Group Existence: asmdba …
Node Name Status Comment
———— ———————— ————————
orcldbwr passed exists
Verifying Group Existence: asmdba …PASSED
Verifying Group Existence: oinstall …
Node Name Status Comment
———— ———————— ————————
orcldbwr passed exists
Verifying Group Existence: oinstall …PASSED
Verifying Group Membership: asmadmin …
Node Name User Exists Group Exists User in Group Status
—————- ———— ———— ———— —————-
orcldbwr yes yes yes passed
Verifying Group Membership: asmadmin …PASSED
Verifying Group Membership: asmdba …
Node Name User Exists Group Exists User in Group Status
—————- ———— ———— ———— —————-
orcldbwr 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
—————- ———— ———— ———— ———— ————
orcldbwr yes yes yes yes passed
Verifying Group Membership: oinstall(Primary) …PASSED
Verifying Run Level …
Node Name run level Required Status
———— ———————— ———————— ———-
orcldbwr 3 3,5 passed
Verifying Run Level …PASSED
Verifying Architecture …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr x86_64 x86_64 passed
Verifying Architecture …PASSED
Verifying OS Kernel Version …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 4.14.35-1902.6.6.el7uek.x86_64 4.1.12 passed
Verifying OS Kernel Version …PASSED
Verifying OS Kernel Parameter: semmsl …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 250 250 250 passed
Verifying OS Kernel Parameter: semmsl …PASSED
Verifying OS Kernel Parameter: semmns …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 32000 32000 32000 passed
Verifying OS Kernel Parameter: semmns …PASSED
Verifying OS Kernel Parameter: semopm …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 100 100 100 passed
Verifying OS Kernel Parameter: semopm …PASSED
Verifying OS Kernel Parameter: semmni …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 128 128 128 passed
Verifying OS Kernel Parameter: semmni …PASSED
Verifying OS Kernel Parameter: shmmax …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 4398046511104 4398046511104 12495017984 passed
Verifying OS Kernel Parameter: shmmax …PASSED
Verifying OS Kernel Parameter: shmmni …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 4096 4096 4096 passed
Verifying OS Kernel Parameter: shmmni …PASSED
Verifying OS Kernel Parameter: shmall …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 1073741824 1073741824 1073741824 passed
Verifying OS Kernel Parameter: shmall …PASSED
Verifying OS Kernel Parameter: file-max …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 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
—————- ———— ———— ———— ———— ————
orcldbwr 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
—————- ———— ———— ———— ———— ————
orcldbwr 262144 262144 262144 passed
Verifying OS Kernel Parameter: rmem_default …PASSED
Verifying OS Kernel Parameter: rmem_max …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 4194304 4194304 4194304 passed
Verifying OS Kernel Parameter: rmem_max …PASSED
Verifying OS Kernel Parameter: wmem_default …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 262144 262144 262144 passed
Verifying OS Kernel Parameter: wmem_default …PASSED
Verifying OS Kernel Parameter: wmem_max …
Node Name Current Configured Required Status Comment
—————- ———— ———— ———— ———— ————
orcldbwr 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
—————- ———— ———— ———— ———— ————
orcldbwr 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
—————- ———— ———— ———— ———— ————
orcldbwr 1 1 1 passed
Verifying OS Kernel Parameter: panic_on_oops …PASSED
Verifying Package: kmod-20-21 (x86_64) …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr kmod(x86_64)-20-25.0.1.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
———— ———————— ———————— ———-
orcldbwr kmod-libs(x86_64)-20-25.0.1.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
———— ———————— ———————— ———-
orcldbwr binutils-2.27-41.base.0.1.el7 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
———— ———————— ———————— ———-
orcldbwr 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
———— ———————— ———————— ———-
orcldbwr libgcc(x86_64)-4.8.5-39.0.1.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
———— ———————— ———————— ———-
orcldbwr libstdc++(x86_64)-4.8.5-39.0.1.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
———— ———————— ———————— ———-
orcldbwr libstdc++-devel(x86_64)-4.8.5-39.0.1.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
———— ———————— ———————— ———-
orcldbwr sysstat-10.1.5-18.el7 sysstat-10.1.5 passed
Verifying Package: sysstat-10.1.5 …PASSED
Verifying Package: ksh …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr ksh ksh passed
Verifying Package: ksh …PASSED
Verifying Package: make-3.82 …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 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
———— ———————— ———————— ———-
orcldbwr glibc(x86_64)-2.17-292.0.1.el7 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
———— ———————— ———————— ———-
orcldbwr glibc-devel(x86_64)-2.17-292.0.1.el7 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
———— ———————— ———————— ———-
orcldbwr 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
———— ———————— ———————— ———-
orcldbwr 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
———— ———————— ———————— ———-
orcldbwr nfs-utils-1.3.0-0.65.0.1.el7 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
———— ———————— ———————— ———-
orcldbwr smartmontools-7.0-1.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
———— ———————— ———————— ———-
orcldbwr 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
—————- ———— ———— ———— —————-
orcldbwr 6200 TCP yes successful
orcldbwr 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
—————- ———— ———— ———— —————-
orcldbwr 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
———————————— ————————
orcldbwr passed
Verifying Root user consistency …PASSED
Verifying Package: cvuqdisk-1.0.10-1 …
Node Name Available Required Status
———— ———————— ———————— ———-
orcldbwr 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
———————————— ————————
orcldbwr passed
Verifying Hosts File …PASSED
Interface information for node “orcldbwr”
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
—— ————— ————— ————— ————— —————– ——
ens3 10.0.0.12 10.0.0.0 0.0.0.0 10.0.0.1 02:00:17:06:9B:0F 9000
Check: MTU consistency of the subnet “10.0.0.0”.
Node Name IP Address Subnet MTU
—————- ———— ———— ———— —————-
orcldbwr ens3 10.0.0.12 10.0.0.0 9000
Verifying Check that maximum (MTU) size packet goes through subnet …PASSED
Verifying Node Connectivity …PASSED
Verifying Network Time Protocol (NTP) …
Verifying ‘/etc/chrony.conf’ …
Node Name File exists?
———————————— ————————
orcldbwr yes
Verifying ‘/etc/chrony.conf’ …PASSED
Verifying Daemon ‘chronyd’ …
Node Name Running?
———————————— ————————
orcldbwr yes
Verifying Daemon ‘chronyd’ …PASSED
Verifying NTP daemon or service using UDP port 123 …
Node Name Port Open?
———————————— ————————
orcldbwr yes
Verifying NTP daemon or service using UDP port 123 …PASSED
Verifying chrony daemon is synchronized with at least one external time source …PASSED
Verifying Network Time Protocol (NTP) …PASSED
Verifying Same core file name pattern …PASSED
Verifying User Mask …
Node Name Available Required Comment
———— ———————— ———————— ———-
orcldbwr 0022 0022 passed
Verifying User Mask …PASSED
Verifying User Not In Group “root”: oracle …
Node Name Status Comment
———— ———————— ————————
orcldbwr passed does not exist
Verifying User Not In Group “root”: oracle …PASSED
Verifying Time zone consistency …PASSED
Verifying resolv.conf Integrity …
Node Name Status
———————————— ————————
orcldbwr passed
checking response for name “orcldbwr” from each of the name servers specified
in “/etc/resolv.conf”
Node Name Source Comment Status
———— ———————— ———————— ———-
orcldbwr 169.254.169.254 IPv4 passed
Verifying resolv.conf Integrity …PASSED
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
———— ———————— ————————
orcldbwr no passed
Node Name Running? Status
———— ———————— ————————
orcldbwr no passed
Verifying Daemon “avahi-daemon” not configured and running …PASSED
Verifying Daemon “proxyt” not configured and running …
Node Name Configured Status
———— ———————— ————————
orcldbwr no passed
Node Name Running? Status
———— ———————— ————————
orcldbwr 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 Swap Size …FAILED
orcldbwr: PRVF-7573 : Sufficient swap size is not available on node “orcldbwr”
[Required = 16GB (1.6777216E7KB) ; Found = 8GB (8388604.0KB)]
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: Nov 10, 2019 5:25:30 PM
CVU home: /u01/app/oracle/19c/grid/
User: oracle
Step:-3 Login to Vncserver
[oracle@orcldbwr ~]$ . .bash_profile
[oracle@orcldbwr ~]$ . .grid.env
[oracle@orcldbwr ~]$ cd $ORACLE_HOME
[oracle@orcldbwr grid]$ ./gridSetup.sh
- Click Standalone server
- Click External – > browse /dev/oracleasm/disks -> select the disk
- Enter ASM Password
- Leave as it is
- Change according to your user groups
- check the base and home going to install
- Check the inventory directory
- Leave as it is
- Click ignore all
- Click install
- Needs to execute the below script as a root user
- Executed as root user
[root@orcldbwr disks]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@orcldbwr disks]# /u01/app/oracle/19c/grid/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/19c/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin …
Copying oraenv to /usr/local/bin …
Copying coraenv to /usr/local/bin …
/bin/grep: /etc/oratab: Is a directory
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/oracle/19c/grid/crs/install/crsconfig_params
The log of current session can be found at:
/u01/app/oracle/crsdata/orcldbwr/crsconfig/roothas_2019-11-10_06-31-22PM.log
2019/11/10 18:31:25 CLSRSC-363: User ignored prerequisites during installation
LOCAL ADD MODE
Creating OCR keys for user ‘oracle’, privgrp ‘oinstall’..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user ‘root’, privgrp ‘root’..
Operation successful.
CRS-4664: Node orcldbwr successfully pinned.
2019/11/10 18:31:33 CLSRSC-330: Adding Clusterware entries to file ‘oracle-ohasd.service’
orcldbwr 2019/11/10 18:32:13 /u01/app/oracle/crsdata/orcldbwr/olr/backup_20191110_183213.olr 724960844
2019/11/10 18:32:14 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
- Oracle 19c Grid installation successfully completed
- Check the status of grid process
[oracle@orcldbwr disks]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[oracle@orcldbwr disks]$ crsctl check css
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[oracle@orcldbwr disks]$ crsctl check evm
CRS-4533: Event Manager is online
Create ASM Diskgroup using ASMCA Tool.
- Export Path and start asmca tool
[oracle@orcldbwr ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@orcldbwr ~]$ asmca
- Enter password and click specify disk group
- Type /dev/oracleasm/disks and press ok
- Enter Data -> external -> select disk path
- Asm Diskgroup created successfully
- Login to putty session using asmcmd
[oracle@orcldbwr ~]$ export ORACLE_SID=+ASM
[oracle@orcldbwr ~]$ 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 51196 51096 0 51096 0 N DATA/
- Check the cluster resource
[oracle@orcldbwr tmp]$ crsctl status resource -t
——————————————————————————–
Name Target State Server State details
——————————————————————————–
Local Resources
——————————————————————————–
ora.DATA.dg
ONLINE ONLINE orcldbwr STABLE
ora.LISTENER.lsnr
ONLINE ONLINE orcldbwr STABLE
ora.asm
ONLINE ONLINE orcldbwr Started,STABLE
ora.ons
OFFLINE OFFLINE orcldbwr STABLE
——————————————————————————–
Cluster Resources
——————————————————————————–
ora.cssd
1 ONLINE ONLINE orcldbwr STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE orcldbwr STABLE
——————————————————————————–
Next post:-
Step:-1 Oracle Cloud Vm Machine-Create VM machine For Oracle 19c ASM Configuration
Step:-2 Oracle Cloud Vm Machine-Oracle 19c Configuration ASM Storage For A Standalone Database
Step:-3 Oracle Cloud Vm Machine-Oracle 19c Configuration Grid And Database Installation
Step:-4 Oracle Cloud Vm Machine-Oracle 19c installation Grid Infrastructure for a Standalone Server
Step:-5 Oracle Cloud Vm Machine-Oracle 19c installation for a Standalone Server
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
