HOME > > Create Infrastructure for Oracle RAC On RHEL 7.9 using VMWARE

Create Infrastructure for Oracle RAC On RHEL 7.9 using VMWARE

Anup - Friday, February 24, 2023

 


Download Linux 7.9


Section: A (Create first Virtual Machine)


1. Create the windows folders to house the first virtual machines and the shared storage.


F:\>mkdir RAC1

F:\>mkdir RAC2

F:\>mkdir SHARED-STORAGE


2. Open VMWARE Console and Click on New Virtual Machine and click next.

3. Select Virtual Machine Configurations: Custom 



4. Choose Vm Machine Compatibility 












Click on the Finish button. 

 

Now your virtual machine is ready to install Linux 7.9 OS


Section: B (Install Linux 7.9 OS on first Virtual Machine)


1. Double Click on CD-ROM Devices. Select Use ISO image when you planning to install OS through ISO image otherwise Use physical drive.






2. Click on Start the Virtual Machine. 





Click on 









/10GB

/boot 500MB

/var 6GB

/swap 10GB

/home 20GB

/oracle 156 GB







reboot machine 


Perform below steps 


Step 1: Check the internet connectivity and network adapters are enabled.


ping google.com


Step 2 : Check the YUM is working by using the below command.


yum repolist


Step 3: Install Pre-installed packages 

First thing is to install a pre-install package for the database.

cd /etc/yum.repos.d

wget https://yum.oracle.com/public-yum-ol7.repo



Using a text editor for Oracle Linux 6 or 7, change the field 'enabled=0' to 'enabled=1' for the repositories corresponding to the machine's operating system while also enabling the 'addons' channel. Here's an example of a repo file's entries:


[ol7_latest]

name=Oracle Linux $releasever Latest ($basearch)

baseurl=https://yum.oracle.com/repo/OracleLinux/OL6/latest/$basearch/

gpgkey=https://yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


[ol7_addons]

name=Oracle Linux $releasever Add ons ($basearch)

baseurl=https://yum.oracle.com/repo/OracleLinux/OL6/addons/$basearch/

gpgkey=https://yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


[ol6_UEK_latest]

name=Latest Unbreakable Enterprise Kernel for Oracle Linux $releasever ($basearch)

baseurl=https://yum.oracle.com/repo/OracleLinux/OL6/UEK/latest/$basearch/

gpgkey=https://yum.oracle.com/RPM-GPG-KEY-oracle-ol6

gpgcheck=1

enabled=1


For Oracle Linux 6 or 7, update all packages and then install the preinstallation rpm by running the following yum commands:

yum update

Install Required RPM’s for Database 

yum install elfutils-libelf*

For 11g:

yum install oracle-rdbms-server-11gR2-preinstall


For 12c:

yum install oracle-rdbms-server-12cR1-preinstall

Step 5 :- Disable secure linux by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

SELINUX=disabled

Change Enforcing to disabled

Section : C (Add network interface for private connectivity)


1. Click on Edit virtual machine setting 

2. Click Add button and select Ethernet Adapter 

3. Select Bridge Network type


Shutdown the machine and close it from VM Console




Section: D (Create Shared Storage and Configure)


►Create virtual disks for storage usage, which is shared by Both Machine


1. down the virtual Machine (RAC1) 

2. Go to VMware Server Console. Click on Edit virtual machine settings. 

Virtual Machine Settings: Click on Add. 

Add Hardware Wizard: Click on Next. 

Hardware types: Select Hard Disk. 

Select a Disk: 

Disk: Select create a new virtual disk. 

Select a Disk Type: 

Virtual Disk Type: Select IDE (Recommended). 

Specify Disk Capacity: 

Disk capacity: Enter “100GB.” 

Select Allocate all disk space now. 

Specify Disk File: 

Disk file: Enter “F :\> SHARED-STORAGE\DISK1.vmdk.” 

Click on Advanced 

Add Hardware Wizard: 

Virtual device node: Select IDE0.1. 

Mode: Select Independent, Persistent for all shared disks. 

3. Click on Finish. 


Modify virtual machine configuration file. 

Additional parameters are required to enable disk sharing between the two virtual RAC nodes. Open the configuration file, F:\>SUNOS-1\ Solaris 10.vmx.vmx and add the bold parameters listed below.

.

.

.

priority.grabbed = "normal"

priority.ungrabbed = "normal"

disk.locking = "FALSE"

diskLib.dataCacheMaxSize = "0"

ide0:1.sharedBus = "virtual"

ide0:0.redo = ""

ethernet0.addressType = "generated

-

-

-

-

-

ethernet0.connectionType = "hostonly"

ide0:1.present = "TRUE"

ide0:1.fileName = "E:\SHARED-DISK.vmdk"

ide0:1.redo = ""

checkpoint.vmState = ""

ide0:1.mode = "independent-persistent"

scsi0:1.deviceType= "disk"

disk.locking = "FALSE"

diskLib.dataCacheMaxSize = "0"

scsi0:1.sharedBus = "virtual"

floppy0.present = "FALSE"


Save it.


Section: E (Create  Second Virtual Machine)


1. Create the windows folders to house the second virtual machines.

E:\>mkdir RAC2

2. Shutdown the First Virtual Machine 

3. Copy all the files from F:\RAC1 to E:\RAC2 

4. Open VMware Server Console, press CTRL-O to open the second virtual machine, E:\RAC2\Solaris 10.vmx. 

5. Rename the second virtual machine name from RAC1 to RAC2. 

Click on Start this virtual machine to start RAC2, leaving RAC1 powered off. 

RAC2 – Virtual Machine: Select create a new identifier. 


Start First Machine


Configure network on first Machine







validate and if need to change  hostname in /etc/hostname file


validate /etc/resolv.conf file




Put the following entry in the /etc/hosts file on First node Node.


192.168.157.111 racnode1.indiandba.com racnode1

192.168.157.222 racnode2.indiandba.com racnode2

192.168.158.11 racnode1-priv.indiandba.com racnode1-priv

192.168.158.22 racnode2-priv.indiandba.com racnode2-priv

192.168.157.50 racnode1-vip.indiandba.com racnode1-vip

192.168.157.60 racnode2-vip.indiandba.com racnode2-vip

192.168.157.20 scan.indiandba.com

192.168.157.30 scan.indiandba.com

192.168.157.40 scan.indiandba.com



Configure network on Second Machine








change hostname in /etc/hostname file


validate /etc/resolv.conf file




Put the following entry in the /etc/hosts file on Secondnode Node.


192.168.157.111 racnode1.indiandba.com racnode1

192.168.157.222 racnode2.indiandba.com racnode2

192.168.158.11 racnode1-priv.indiandba.com racnode1-priv

192.168.158.22 racnode2-priv.indiandba.com racnode2-priv

192.168.157.50 racnode1-vip.indiandba.com racnode1-vip

192.168.157.60 racnode2-vip.indiandba.com racnode2-vip

192.168.157.20 scan.indiandba.com

192.168.157.30 scan.indiandba.com

192.168.157.40 scan.indiandba.com


Reboot both machine



Start First / Second Machine 



Section: G (Prepare Disk for OCR, Voting and ASM Storage)


1. Run below mention command on first node 


$fdisk -l



2. Log on to RAC1 node and complete bellow mention procedure.


[root@racnode1 ~]# 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 0xb5629e2e.


Command (m for help): n

Partition type:

   p   primary (0 primary, 0 extended, 4 free)

   e   extended

Select (default p): p

Partition number (1-4, default 1):

First sector (2048-52428799, default 2048):

Using default value 2048

Last sector, +sectors or +size{K,M,G} (2048-52428799, default 52428799): +6GB

Partition 1 of type Linux and of size 5.6 GiB is set


Command (m for help): w

The partition table has been altered!


Calling ioctl() to re-read partition table.

Syncing disks.

[root@racnode1 ~]# 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.



Command (m for help): n

Partition type:

   p   primary (1 primary, 0 extended, 3 free)

   e   extended

Select (default p): p

Partition number (2-4, default 2):

First sector (11720704-52428799, default 11720704):

Using default value 11720704

Last sector, +sectors or +size{K,M,G} (11720704-52428799, default 52428799): +10GB

Partition 2 of type Linux and of size 9.3 GiB is set


Command (m for help): w

The partition table has been altered!


Calling ioctl() to re-read partition table.

Syncing disks.

[root@racnode1 ~]#


validate partition on second node




Perform on both node 

Map raw devices for ASM disks. A raw device mapping is required only if you are planning on creating ASM disks using standard Linux I/O. An alternative to creating ASM disks is to use the ASM library driver provided by Oracle. You will configure ASM disks using ASM library driver later.


Perform the following tasks to map the raw devices to the shared partitions created earlier. The raw devices have to bind with the block devices each time a cluster node boots.



To make the mapping effective immediately, execute the following commands as the root user:


/bin/raw /dev/raw/raw1 /dev/sdb1

/bin/raw /dev/raw/raw2 /dev/sdb2



# chown oracle:dba /dev/raw/raw[1-3]

# chmod 660 /dev/raw/raw[1-3]

# ls -lat /dev/raw/raw*

crw-rw---- 1 oracle dba 162, 3 Nov 4 07:04 /dev/raw/raw3

crw-rw---- 1 oracle dba 162, 2 Nov 4 07:04 /dev/raw/raw2

crw-rw---- 1 oracle dba 162, 1 Nov 4 07:04 /dev/raw/raw1




Section: H (Configure SSH)

Step 1 Create .SSH, and Create RSA Keys on Each Node

Log in as an Oracle/CRS user and execute bellow steps


$ mkdir ~/.ssh

$ chmod 700 ~/.ssh

$ cd .ssh

$ /usr/bin/ssh-keygen -t rsa


At the prompts:

Accept the default location for the key file (press Enter).

Enter and confirm a pass phrase unique for this installation user.


Step 2 Add All Keys to a Common authorized_keys File

On the primary node (RAC1), change directories to the .ssh directory. Then, add the RSA key to the authorized_keys file.


$ cd .ssh

$ cat id_rsa.pub >> authorized_keys

$ ls


In the .ssh directory, you should see the id_rsa.pub keys that you have created, and the file authorized_keys.


Step 3 Copy authorized_key file to all cluster node (RAC2) 


$ scp authorized_keys RAC2:/export/home/oracle/.ssh/


The authenticity of host 'rac2 (192.168.0.222)' can't be established.

RSA key fingerprint is c0:1f:20:34:54:b2:cd:9f:42:f2:d6:25:36:2f:3e:db.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added 'rac2,192.168.0.222' (RSA) to the list of known hosts.

Password:

authorized_keys      100% |*****************************|   221       00:00


Step 4 Log in on second node (RAC2) and Add the RSA keys for the second node (RAC2) to the authorized_keys file:


$cd .ssh

$cat id_rsa.pub  >> authorized_keys


Step 5 Copy authorized_key file to all cluster node (RAC2)


$ scp authorized_keys RAC1:/export/home/oracle/.ssh/


Step 6 Enabling SSH User Equivalency on Cluster Member Nodes. On the system where you want to run OUI, log in as the ORACLE/CRS user and execute:


$ ssh racnode1 date

$ ssh racnode2 date

$ ssh racnode1-priv date

$ ssh racnode2-priv date


Validate /etc/resolv.conf


Disable Firewall on both node


systemctl status firewalld

systemctl stop firewalld

systemctl disable firewalld


Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me