RAC INSTALLATION STEPS
┌──────────────────────────────────────────────────────────────────────┐
│ • MobaXterm Personal Edition v24.0 • │
│ (SSH client, X server and network tools) │
│ │
│ ⮞ SSH session to root@192.168.56.10 │
│ • Direct SSH : ✓ │
│ • SSH compression : ✓ │
│ • SSH-browser : ✓ │
│ • X11-forwarding : ✓ (remote display is forwarded through SSH) │
│ │
│ ⮞ For more info, ctrl+click on help or visit our website. │
└──────────────────────────────────────────────────────────────────────┘
Last failed login: Fri Jun 7 15:30:24 IST 2024 from 192.168.56.1 on ssh:notty
There was 1 failed login attempt since the last successful login.
Last login: Fri Jun 7 15:26:38 2024
STEP-1 on both node (note- set hostname accordingly different hostname)
[root@node1 ~]# hostnamectl set-hostname rac1.clover.com
[root@node1 ~]#
[root@node1 ~]# hostname
rac1.clover.com
STEP-2 on both node
update hosts file with
# Public
192.168.56.10 rac1.clover.com rac1
192.168.56.20 rac2.clover.com rac2
# Private
10.0.0.1 rac1-priv.clover.com rac1-priv
10.0.0.2 rac2-priv.clover.com rac2-priv
# Virtual
192.168.56.61 rac1-vip.clover.com rac1-vip
192.168.56.62 rac2-vip.clover.com rac2-vip
# SCAN
192.168.56.63 rac-scan.clover.com rac-scan
192.168.56.64 rac-scan.clover.com rac-scan
192.168.56.65 rac-scan.clover.com rac-scan
[root@node1 ~]# vi /etc/hosts
check the connnectivity on both node
[root@node1 ~]# ping rac1
PING rac1.clover.com (192.168.56.10) 56(84) bytes of data.
64 bytes from rac1.clover.com (192.168.56.10): icmp_seq=1 ttl=64 time=0.090 ms
64 bytes from rac1.clover.com (192.168.56.10): icmp_seq=2 ttl=64 time=0.057 ms
64 bytes from rac1.clover.com (192.168.56.10): icmp_seq=3 ttl=64 time=0.061 ms
^C
--- rac1.clover.com ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2041ms
rtt min/avg/max/mdev = 0.057/0.069/0.090/0.016 ms
[root@node1 ~]# ping rac2
PING rac2.clover.com (192.168.56.20) 56(84) bytes of data.
64 bytes from rac2.clover.com (192.168.56.20): icmp_seq=1 ttl=64 time=0.945 ms
64 bytes from rac2.clover.com (192.168.56.20): icmp_seq=2 ttl=64 time=1.17 ms
64 bytes from rac2.clover.com (192.168.56.20): icmp_seq=3 ttl=64 time=1.12 ms
^C
--- rac2.clover.com ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2005ms
rtt min/avg/max/mdev = 0.945/1.079/1.174/0.104 ms
[root@node1 ~]# ping rac2-priv
PING rac2-priv.clover.com (10.0.0.2) 56(84) bytes of data.
64 bytes from rac2-priv.clover.com (10.0.0.2): icmp_seq=1 ttl=64 time=2.53 ms
64 bytes from rac2-priv.clover.com (10.0.0.2): icmp_seq=2 ttl=64 time=1.29 ms
^C
--- rac2-priv.clover.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1002ms
rtt min/avg/max/mdev = 1.292/1.912/2.533/0.622 ms
[root@node1 ~]# ping rac1-priv
PING rac1-priv.clover.com (10.0.0.1) 56(84) bytes of data.
64 bytes from rac1-priv.clover.com (10.0.0.1): icmp_seq=1 ttl=64 time=0.102 ms
64 bytes from rac1-priv.clover.com (10.0.0.1): icmp_seq=2 ttl=64 time=0.055 ms
^C
--- rac1-priv.clover.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1015ms
rtt min/avg/max/mdev = 0.055/0.078/0.102/0.025 ms
[root@node1 ~]# ping google.com
PING google.com (142.250.182.238) 56(84) bytes of data.
64 bytes from bom07s29-in-f14.1e100.net (142.250.182.238): icmp_seq=1 ttl=54 time=68.3 ms
64 bytes from bom07s29-in-f14.1e100.net (142.250.182.238): icmp_seq=2 ttl=54 time=66.9 ms
^C
--- google.com ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1002ms
rtt min/avg/max/mdev = 66.975/67.661/68.347/0.686 ms
install below packages on both node
yum install -y oracle-database-preinstall-19c
yum install -y oracleasm-support*
yum install -y kmod-oracleasm*
yum install -y bind* --skip-broken
create below group and users
create directorys for grid and oracle home
[root@node1 ~]# groupadd -g 54328 asmoper
[root@node1 ~]# groupadd -g 5429 asmadmin
[root@node1 ~]#
[root@node1 ~]# useradd -u 54323 -g oinstall -G asmadmin,asmdba,asmoper grid
[root@node1 ~]#
[root@node1 ~]# usermod -a -G asmdba oracle
[root@node1 ~]#
[root@node1 ~]# usermod -G asmdba,backupdba,dba,oinstall,racdba,kmdba,dgdba,oper oracle
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# mkdir -p /u01/app/oracle/product/19C/dbhome
[root@node1 ~]# chown -R oracle:oinstall /u01/
[root@node1 ~]#
[root@node1 ~]# mkdir -p /u02/app/grid/product/19C/dbhome
[root@node1 ~]# chown -R grid:oinstall /u02
[root@node1 ~]# chmod -R 775 /u01
[root@node1 ~]# chmod -R 775 /u02
[root@node1 ~]#
[root@node1 ~]#
SETUP PASSWORD FOR GRID AND ORACLE USERS ON BOTH NODE
passwd oracle
passwd grid
Configure ASM on both node
[root@node1 ~]#
[root@node1 ~]# oracleasm configure -i
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting <ENTER> without typing an
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: oinstall
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# oracleasm init
Creating /dev/oracleasm mount point: /dev/oracleasm
Loading module "oracleasm": oracleasm
Configuring "oracleasm" to use device physical block size
Mounting ASMlib driver filesystem: /dev/oracleasm
──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
ATTACH SHAREABLE DISK ON BOTH NODE AND
MAKE THE Partition AND DISK AS SHOW BELOW ONLY ON NODE 1
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# fdisk -l
Disk /dev/sda: 128.8 GB, 128849018880 bytes, 251658240 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0x00030bb6
Device Boot Start End Blocks Id System
/dev/sda1 * 2048 1001471 499712 83 Linux
/dev/sda2 1001472 251658239 125328384 8e Linux LVM
Disk /dev/sdb: 16.1 GB, 16106127360 bytes, 31457280 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/sdc: 16.1 GB, 16106127360 bytes, 31457280 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/sdd: 12.9 GB, 12884901888 bytes, 25165824 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/mapper/ol-root: 113.3 GB, 113321705472 bytes, 221331456 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/mapper/ol-swap: 9999 MB, 9999220736 bytes, 19529728 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk /dev/mapper/ol-tmp: 4999 MB, 4999610368 bytes, 9764864 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
[root@rac1 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdd 8:48 0 12G 0 disk
sdb 8:16 0 15G 0 disk
sr0 11:0 1 1024M 0 rom
sdc 8:32 0 15G 0 disk
sda 8:0 0 120G 0 disk
├─sda2 8:2 0 119.5G 0 part
│ ├─ol-swap 252:1 0 9.3G 0 lvm /swap
│ ├─ol-tmp 252:2 0 4.7G 0 lvm /tmp
│ └─ol-root 252:0 0 105.6G 0 lvm /
└─sda1 8:1 0 488M 0 part /boot
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# fdisk /dev/sdb
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0xde8f1d03.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p):
Using default response p
Partition number (1-4, default 1):
First sector (2048-31457279, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-31457279, default 31457279):
Using default value 31457279
Partition 1 of type Linux and of size 15 GiB is set
Command (m for help):
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac1 ~]# fdisk /dev/sdc
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x00e127aa.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p):
Using default response p
Partition number (1-4, default 1):
First sector (2048-31457279, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-31457279, default 31457279):
Using default value 31457279
Partition 1 of type Linux and of size 15 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac1 ~]#
[root@rac1 ~]# fdisk /dev/sdd
Welcome to fdisk (util-linux 2.23.2).
Changes will remain in memory only, until you decide to write them.
Be careful before using the write command.
Device does not contain a recognized partition table
Building a new DOS disklabel with disk identifier 0x9e04b50e.
Command (m for help): n
Partition type:
p primary (0 primary, 0 extended, 4 free)
e extended
Select (default p):
Using default response p
Partition number (1-4, default 1):
First sector (2048-25165823, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-25165823, default 25165823):
Using default value 25165823
Partition 1 of type Linux and of size 12 GiB is set
Command (m for help):
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sdd 8:48 0 12G 0 disk
└─sdd1 8:49 0 12G 0 part
sdb 8:16 0 15G 0 disk
└─sdb1 8:17 0 15G 0 part
sr0 11:0 1 1024M 0 rom
sdc 8:32 0 15G 0 disk
└─sdc1 8:33 0 15G 0 part
sda 8:0 0 120G 0 disk
├─sda2 8:2 0 119.5G 0 part
│ ├─ol-swap 252:1 0 9.3G 0 lvm /swap
│ ├─ol-tmp 252:2 0 4.7G 0 lvm /tmp
│ └─ol-root 252:0 0 105.6G 0 lvm /
└─sda1 8:1 0 488M 0 part /boot
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oracleasm createdisk disk1 /dev/sdb1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oracleasm createdisk disk2 /dev/sdc1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oracleasm createdisk disk3 /dev/sdd1
Writing disk header: done
Instantiating disk: done
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# oracleasm listdisks
DISK1
DISK2
DISK3
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# chmod -R 775 /u02
[root@rac1 ~]#
DNS Configuration only on node 1
[root@node1 ~]# systemctl start named.service
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# nslookup rac1
Server: 192.168.56.10
Address: 192.168.56.10#53
Name: rac1.clover.com
Address: 192.168.56.10
[root@node1 ~]#
[root@node1 ~]#
[root@node1 ~]# nslookup rac2
Server: 192.168.56.10
Address: 192.168.56.10#53
Name: rac2.clover.com
Address: 192.168.56.20
----------------------------------------------------------------------------------------------------------
ON NODE 2
oracleasm scandisks
oracleasm listdisks
--------------------------------------------------------------------------------------------------------------
upload the software on node 1
[grid@rac1 ~]$
[grid@rac1 ~]$ cd /u02/app/grid/product/19C/dbhome/
[grid@rac1 dbhome]$ cd
[grid@rac1 ~]$ vi .bash_profile
[grid@rac1 ~]$ cd $ORACLE_HOME
[grid@rac1 ~]$
[grid@rac1 ~]$
[grid@rac1 ~]$ . .bash_profile
[grid@rac1 ~]$ cd $ORACLE_HOME
[grid@rac1 dbhome]$ ls -l
total 5871516
-rw-r--r--. 1 grid oinstall 3059705302 Jun 7 16:02 LINUX.X64_193000_db_home.zip
-rw-r--r--. 1 grid oinstall 2755264512 Jun 7 16:03 LINUX.X64_193000_grid_home.zip
[grid@rac1 dbhome]$
[grid@rac1 dbhome]$
[grid@rac1 dbhome]$ unzip LINUX.X64_193000_grid_home.zip
SETUP PASSWORDLESS FOR GRID AND ORACLE ON NODE 1
[grid@rac1 dbhome]$ cd deinstall/
[grid@rac1 deinstall]$ ls -l
total 172
-rwxrwxr-x. 1 grid oinstall 55480 Apr 17 2019 bootstrap_files.lst
-rwxrwxr-x. 1 grid oinstall 14927 Apr 17 2019 bootstrap.pl
-rwxrwxr-x. 1 grid oinstall 11224 Apr 18 2019 deinstall
-rwxrwxr-x. 1 grid oinstall 33171 Apr 17 2019 deinstall.pl
-rwxrwxr-x. 1 grid oinstall 8479 Sep 19 2017 deinstall.xml
drwxrwxr-x. 2 grid oinstall 102 Apr 17 2019 jlib
-rwxrwxr-x. 1 grid oinstall 401 Feb 10 2012 readme.txt
drwxrwxr-x. 2 grid oinstall 32 Apr 17 2019 response
-rwxrwxr-x. 1 grid oinstall 33333 Jan 7 2015 sshUserSetup.sh
drwxrwxr-x. 2 grid oinstall 33 Apr 17 2019 utl
[grid@rac1 deinstall]$ ./sshUserSetup.sh -user grid -hosts 'rac1 rac2' -noPromptPassphrase -confirm -advanced
[grid@rac1 deinstall]$ ./sshUserSetup.sh -user oracle hosts 'rac1 rac2' -noPromptPassphrase -confirm -advanced
-----------------------------------------------------------------------------------------------------------------------------
run the cuv package on both node
[grid@rac1 deinstall]$ cd ..
[grid@rac1 dbhome]$ cd cv/rpm/
[grid@rac1 rpm]$ ls -l
total 12
-rwxrwxr-x. 1 grid oinstall 11412 Mar 13 2019 cvuqdisk-1.0.10-1.rpm
[grid@rac1 rpm]$ pwd
/u02/app/grid/product/19C/dbhome/cv/rpm
[grid@rac1 rpm]$ su -
Password:
Last login: Fri Jun 7 16:09:55 IST 2024 on pts/1
[root@rac1 ~]# rpm -ivh /u02/app/grid/product/19C/dbhome/cv/rpm/cvuqdisk-1.0.10-1.rpm
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@rac1 ~]# scp /u02/app/grid/product/19C/dbhome/cv/rpm/cvuqdisk-1.0.10-1.rpm rac2:/tmp
root@rac2's password:
cvuqdisk-1.0.10-1.rpm 100% 11KB 1.2MB/s 00:00
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]#
[root@rac1 ~]# logout
[grid@rac1 rpm]$
[grid@rac1 rpm]$
[grid@rac1 rpm]$
[grid@rac1 rpm]$ cd ../..
-----------------------------------------------------------------------------------------------------------------------------
run the runclufy from node1
[grid@rac1 dbhome]$ ./runcluvfy.sh stage -pre crsinst -n 'rac1,rac2' -fixup
After this
run the gridsetup.sh
[grid@rac1 dbhome]$
[grid@rac1 dbhome]$
[grid@rac1 dbhome]$ ./gridSetup.sh
Launching Oracle Grid Infrastructure Setup Wizard...
-----------------------------------------------------------------------------------------------------------------------------
after this will gernrate 2 scrpit run this script in sequence on both node one by one
[root@rac1 ~]# /u02/app/grid/oraInventory/orainstRoot.sh
Changing permissions of /u02/app/grid/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u02/app/grid/oraInventory to oinstall.
The execution of the script is complete.
-----------------------------------------------------------------------------------------------------------------------------
[root@rac1 ~]# /u02/app/grid/product/19C/dbhome/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u02/app/grid/product/19C/dbhome
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 ...
Creating /etc/oratab file...
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: /u02/app/grid/product/19C/dbhome/crs/install/crsconfig_params
The log of current session can be found at:
/u02/app/grid/grid_base/crsdata/rac1/crsconfig/rootcrs_rac1_2024-06-07_04-37-54PM.log
2024/06/07 16:38:36 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2024/06/07 16:38:36 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2024/06/07 16:38:36 CLSRSC-363: User ignored prerequisites during installation
2024/06/07 16:38:37 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2024/06/07 16:38:40 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2024/06/07 16:38:42 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
2024/06/07 16:38:42 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2024/06/07 16:38:42 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2024/06/07 16:39:49 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2024/06/07 16:40:02 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2024/06/07 16:40:23 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2024/06/07 16:40:31 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2024/06/07 16:40:32 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2024/06/07 16:40:40 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2024/06/07 16:40:40 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2024/06/07 16:41:14 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2024/06/07 16:41:23 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2024/06/07 16:41:32 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2024/06/07 16:41:40 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
ASM has been created and started successfully.
[DBT-30001] Disk groups created successfully. Check /u02/app/grid/grid_base/cfgtoollogs/asmca/asmca-240607PM044230.log for details.
2024/06/07 16:44:43 CLSRSC-482: Running command: '/u02/app/grid/product/19C/dbhome/bin/ocrconfig -upgrade grid oinstall'
CRS-4256: Updating the profile
Successful addition of voting disk 33b96e35ddad4f44bfcfa5b998ab3f37.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 33b96e35ddad4f44bfcfa5b998ab3f37 (/dev/oracleasm/disks/DISK3) [CRS]
Located 1 voting disk(s).
2024/06/07 16:48:56 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2024/06/07 16:51:12 CLSRSC-343: Successfully started Oracle Clusterware stack
2024/06/07 16:51:12 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2024/06/07 16:54:58 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2024/06/07 16:56:28 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
[root@rac1 ~]#
Comments
Post a Comment