top of page

Oracle Database 12c Release 1 (12.1) RAC On Oracle Linux 7 Using VirtualBox

This article describes the installation of Oracle Database 12c release 1 (12.1 64-bit) RAC on Linux (Oracle Linux 7 64-bit) using VirtualBox (6.1) with no additional shared disk devices.​​

​

​

​

Introduction:

We are going to see how to install and configure Oracle 12c (12.1 64 bit) RAC on Linux (Oracle Linux 7 64-bit). If this installation is on a personal computer, then the biggest challenge is to set the shared storage. In organisations, its felt easy as there are seperate teams with specific skill sets to provision on what we need. Lets try to ease this with a few work arounds by setting this on a personal computer. 

​

What are Prereqs to setup 12c Database RAC server? 

- 4GB RAM for each VM (This case 8GB only for VM for setting 2 node RAC)

- Minimum 200GB disk space

- Required Softwares

​

Software Downloads: 

Download the following software.

​

- Oracle Virtual Box (v6.1)

- Oracle Linux 7 (Pick the latest stable version)

- Oracle Database and GI 12c (12cR1)

​

​

VirtualBox Installation: 

For OS X Mac book, open the .bmg file and extract for installation. Also for Windows, run the ".exe" file and complete with installation giving appropriate path. 

​

​

VirtualBox Config:

We need to make sure a host-only network is configured and check/modify the IP range for that network. This will be the public network for our RAC installation.

​

Network Setup (Windows & MAC OS X): 

  • Start VirtualBox application

  • Click on "File > Host Network Manager" (Ctrl + H)

  • Click on "Create" to create a network adapter and configure the IP address manually. (By default, it should be 192.168.56.1)

  • Click on "Properties" to change the IP Configuration if needed.

​

Machine Setup:

As we proceed, we are going to create 2 VMs to setup a RAC environment and to save time, we will first create 1 with basic settings and clone it for other. 

​

  • Start VirtualBox --> Click "New"

  • Enter name: "dbgenre_r1" (Choose as you wish)

  • Location where to store your files

  • Type: "Linux" and Version "Oracle (64-bit)"

  • Click "Continue"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

  • Choose Memory size as "4096" MB (4G) as a baseline and if you have luxury of allocating more memory, please do to fasten your VMs performance​

  • Click "Continue"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

  • Leave Hard disk to default "Create a virtual hard disk now"

  • Click "Create"

​

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

  • Choose "VDI" and Click "Continue"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

  • Leave it on default to "Dynamically allocated" hard disk. This will help consuming space slowly as we load data. Fixed size would procure all space right away which is not of use to us for Lab setup. 

  • Click "Continue"

​

​

​

​

​

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

  • Verify location of files being saved (better to leave it to default as you would have already chosen where you wanted to save all VM files at the very beginning.

  • Choose a minimum of 50GB space (recommended 100GB as its dynamically increase in future) 

  • Click "Create"

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Once the VM machine is created, it will appear in the left panel and in the right side each properties section gives us an option to change as we need it. 

​

  • On the right panel, Click "Network"

  • Click here to know more about what all these below network config means in VirtualBox

  • Click on Enable Network Adapter and attach it to "NAT"

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

  • Go to "Adapter 2"

  • Click on Enable Network Adapter and attach it to "Host-only Adapter"

​

​

​

​

 

 

 

 

 

 

 

 

 

 

​

​

​

  • Go to "Adapter 3"

  • Click on Enable Network Adapter and attach it to "Internal Network" (This will help to communicate with VM from your local host by getting IP Address from internal network adapter). If Internal Network doesn't show any adapter to attach, it means network adapter is not created. Click here.

  • Click "OK"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

  • Click on "System" properties

  • Reorder Boot sequence to Optical and Hard Disk

  • Uncheck "Floppy"

  • Click "OK"

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

  • Click on "Storage" properties

  • Choose Empty and edit Attributes and choose the right ".iso" image to install Oracle Linux

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

 

Overall the Machine properties should look like below. 

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

Oracle Linux Guest OS Installation:

Click on "Start" and you will see a Welcome screen to start the installation. Click here to view the step by step guide for installing Oracle Linux 7.8 Server class on a Lab machine.

 

Note: that this will be helpful only for Lab setup and may not be recommended for actual use. 

​

Make sure below configuration is set and is kept consistent throughout the article. Feel free to change IP addresses and hostname as you need. 

​

  • hostname: dbgenre_r1.local

  • enp0s3: DHCP (Enable Connect Automatically)

  • enp0s8: IP=192.168.56.101, Subnet=255.255.255.0, Gateway=192.168.56.1, DNS=192.168.56.1 (Enable Connect Automatically)

  • enp0s9: IP=192.168.1.101, Subnet=255.255.255.0, Gateway=<blank>, DNS=<blank> (Enable Connect Automatically)

​

Installation Prerequisites: 

​

For automatic Oracle prerequisites and , run the below command is root. 

​

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

yum install ntp -y

yum update -y

passwd oracle (Set password as "oracle")

systemctl disable avahi-daemon

systemctl stop avahi-daemon

​

Create necessary directories where software will be installed. 

​

mkdir -p /app/oragrid/product/12.1.0.2/grid

mkdir -p /app/oracle/product/12.1.0.2/dbhome1

chown -R oracle:oinstall /app

chmod -R 775 /app/

​

Setting the bash profile. 

​

[oracle@dbgenre_r1 ~]$ vi .bash_profile

​

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=dbgenre_r1.local

export ORACLE_UNQNAME=RACCDB

export ORACLE_BASE=/app/oracle

export GRID_HOME=/app/oragrid/product/12.1.0.2/grid

export DB_HOME=$ORACLE_BASE/product/12.1.0.2/dbhome1

export ORACLE_HOME=$DB_HOME

export ORACLE_SID=raccdb1

export ORACLE_TERM=xterm

export BASE_PATH=/usr/sbin:$PATH

export PATH=$ORACLE_HOME/bin:$BASE_PATH:$ORACLE_HOME/OPatch

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

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

 

alias oh='cd $ORACLE_BASE/product/12.1.0.2/dbhome1'

alias gh='cd /app/oragrid/product/12.1.0.2/grid'

alias na='cd $GRID_HOME/network/admin'

​

Here, we will be using dnsmasq for doing a round robin of my scan IPs. 

​

yum install dnsmasq

service dnsmasq start

chkconfig dnsmasq on (To make sure dnsmasq starts automatically)

​

The service can be stopped, started and restarted using the following commands.

​

service dnsmasq stop

service dnsmasq start

service dnsmasq restart

​

Not edit the "/etc/hosts" file with Private, Public, Virtual and SCAN IP information. 

​

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
# Public
192.168.56.101   dbgenre_r1.local        dbgenre_r1
192.168.56.102   dbgenre_r2.local        dbgenre_r2
# Private
192.168.1.101   dbgenre_r1-priv.local   dbgenre_r1-priv
192.168.1.102   dbgenre_r2-priv.local   dbgenre_r2-priv
# Virtual
192.168.56.103   dbgenre_r1-vip.local    dbgenre_r1-vip
192.168.56.104   dbgenre_r2-vip.local    dbgenre_r2-vip
# SCAN
192.168.56.105   dbgenre-121-scan.local dbgenre-121-scan
192.168.56.106   dbgenre-121-scan.local dbgenre-121-scan
192.168.56.107   dbgenre-121-scan.local dbgenre-121-scan

​

Make sure "/etc/resolv.conf" is amended with below nameserver IP pointed.

 

$ vi /etc/resolv.conf

 

# Generated by NetworkManager
#domain local
search local
nameserver 192.168.56.101

​

Due to NAT interface, resolve.conf file could be overwritten by the network manager. To overcome this open the file "/etc/sysconfig/network-scripts/ifcfg-enp0s3" and set as below.

​

vi /etc/sysconfig/network-scripts/ifcfg-enp0s3

ONBOOT=no

ifdown enp0s3 - (Keep it down)

​

Note: In case if there is a requirement to use Internet for update or other reasons, you can edit the same file and set it to "ONBOOT=yes". 

​

So at this stage your network configuration should look something like below. 

​

[balaaji@dbgenre_r1 ~]$ ifconfig -a
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        ether 08:00:27:7a:43:df  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.56.101  netmask 255.255.255.0  broadcast 192.168.56.255
        inet6 fe80::ab40:a48e:11bf:1dbf  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:c8:e2:74  txqueuelen 1000  (Ethernet)
        RX packets 60  bytes 6915 (6.7 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 123  bytes 13919 (13.5 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

enp0s9: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.1.101  netmask 255.255.255.0  broadcast 192.168.1.255
        inet6 fe80::2121:75ed:b809:37ec  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:59:7d:3b  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 40  bytes 5012 (4.8 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (Local Loopback)
        RX packets 98  bytes 8062 (7.8 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 98  bytes 8062 (7.8 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

​

Restart dnsmasq ones. 

​

service dnsmasq restart

​

Moving towards next step considering that firewall, sshh and SELinux configuration is taken care. Click here to reconfirm if the setting are put in place. 

​

NTP is very important in RAC installation as cluster synchronization within two nodes happen using either NTP or Oracle Cluster Time Synchronization Service (ctssd). I am going to de-configure NTP in this article as I will be using Oracle's synchronization services. 

​

​

[root@dbgenre_r1 ~]# systemctl stop ntpd
[root@dbgenre_r1 ~]# systemctl disable ntpd
[root@dbgenre_r1 ~]# mv /etc/ntp.conf /etc/ntp.conf.orig

​

In case if you are deciding to use NTP for your RAC nodes, then perform below steps. 

​

[root@dbgenre_r1 ~]# vi /etc/sysconfig/ntpd

​

OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

Ecs : wq!

​

[root@dbgenre_r1 ~]# systemctl enable ntpd
Created symlink from /etc/systemd/system/multi-user.target.wants/ntpd.service to /usr/lib/systemd/system/ntpd.service.

[root@dbgenre_r1 ~]# systemctl restart ntpd

​

​

Create Shared folder from your local machine for software packages.  Note that you will have to install VBoxGuestAdditions to enable shared folder. You can download respective guest addition iso file navigating from here.

​

  • Click Devices --> Shared Folders --> Shared Folders settings

​

​

​

​

​

​

​

​

​

  • Point the "Folder Path" in your local machine where the softwares are downloaded. 

  • Enable "Auto-mount" and "Make Permanent"

  • Mention mount point. Mine is "/app/oracle/softwares"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Note: Sometimes, due to few network restrictions this may not function properly. In that case, just do an scp of installation files to software location. 

​

$ scp linuxamd64_12c_grid_1of2.zip linuxamd64_12c_grid_2of2.zip oracle@192.168.56.101:/app/oracle/softwares

$ scp linuxamd64_12c_database_1of2.zip linuxamd64_12c_database_2of2.zip oracle@192.168.56.101:/app/oracle/softwares

​

Lets do a quick reboot of the server. Im shutting down the VM here to configure shared disks for ASM. 

​

[root@dbgenre_r1 ~]# shutdown -h now
Shutdown scheduled for Sun 2020-06-07 03:36:15 EDT, use 'shutdown -c' to cancel.
[root@dbgenre_r1 ~]#
Broadcast message from root@dbgenre_r1.local (Sun 2020-06-07 03:35:15 EDT):

The system is going down for reboot at Sun 2020-06-07 03:36:15 EDT!

​

[root@dbgenre_r1 ~]# Connection to 192.168.56.101 closed by remote host.
Connection to 192.168.56.101 closed.

​

​

Creating Shared Disks:

​

MAC OS X:

 

$ mkdir -p /Users/balaajidhananjayan/Documents/Virtualbox/shared/dbgenre_r1-121-rac
$ cd /Users/balaajidhananjayan/Documents/Virtualbox/shared/dbgenre_r1-121-rac
$
$ # Create the disks 

$ VBoxManage createhd --filename asm11.vdi --size 5120 --format VDI --variant Fixed
$ VBoxManage createhd --filename asm12.vdi --size 5120 --format VDI --variant Fixed
$ VBoxManage createhd --filename asm13.vdi --size 5120 --format VDI --variant Fixed
$ VBoxManage createhd --filename asm14.vdi --size 5120 --format VDI --variant Fixed
$ VBoxManage createhd --filename asm15.vdi --size 5120 --format VDI --variant Fixed
$ VBoxManage createhd --filename asm16.vdi --size 5120 --format VDI --variant Fixed
$
$ # Connect them to the VM.
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm11.vdi --mtype shareable
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm12.vdi --mtype shareable
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm13.vdi --mtype shareable
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm14.vdi --mtype shareable
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm15.vdi --mtype shareable
$ VBoxManage storageattach dbgenre_r1 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm16.vdi --mtype shareable

$
$ # Make shareable.
$ VBoxManage modifyhd asm11.vdi --type shareable
$ VBoxManage modifyhd asm12.vdi --type shareable
$ VBoxManage modifyhd asm13.vdi --type shareable
$ VBoxManage modifyhd asm14.vdi --type shareable
$ VBoxManage modifyhd asm15.vdi --type shareable
$ VBoxManage modifyhd asm16.vdi --type shareable

​

Windows OS:

​

C:
mkdir C:\VirtualBox\dbgenre_r1-121-rac
cd C:\VirtualBox\dbgenre_r1-121-rac

​

"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm11.vdi --size 5120 --format VDI --variant Fixed
"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm12.vdi --size 5120 --format VDI --variant Fixed
"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm13.vdi --size 5120 --format VDI --variant Fixed
"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm14.vdi --size 5120 --format VDI --variant Fixed
"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm15.vdi --size 5120 --format VDI --variant Fixed
"C:\Program Files\Oracle\VirtualBox\VBoxManage" createhd --filename asm16.vdi --size 5120 --format VDI --variant Fixed

​

"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm11.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm12.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm13.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm14.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm15.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r1 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm16.vdi --mtype shareable

 

"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm11.vdi --type shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm12.vdi --type shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm13.vdi --type shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm14.vdi --type shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm15.vdi --type shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" modifyhd asm16.vdi --type shareable

​

Once this is done. Start the virtual machine to take a look into configured disks inside the server. 

​

[balaaji@dbgenre_r1 dev]$ ls -ltr /dev/sd*
brw-rw----. 1 root disk 8, 48 Jun  7 05:51 /dev/sdd
brw-rw----. 1 root disk 8, 64 Jun  7 05:51 /dev/sde
brw-rw----. 1 root disk 8,  0 Jun  7 05:51 /dev/sda
brw-rw----. 1 root disk 8, 32 Jun  7 05:51 /dev/sdc
brw-rw----. 1 root disk 8, 16 Jun  7 05:51 /dev/sdb
brw-rw----. 1 root disk 8,  2 Jun  7 05:51 /dev/sda2
brw-rw----. 1 root disk 8,  1 Jun  7 05:51 /dev/sda1

​

Use "fdisk" to create and format disk partition for listed disks. Leave /dev/sda as its the default disk. Rest all will be asm disks. 

​

[root@dbgenre_r1 ~]# fdisk /dev/sde
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 0x2c3c1a30.

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): 1
First sector (2048-10485759, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-10485759, default 10485759):
Using default value 10485759
Partition 1 of type Linux and of size 5 GiB is set

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.

​

Configure your UDEV rules. 

​

[root@dbgenre_r1 ~]# vi /etc/scsi_id.config

options=-g

​

Esc : wq!

​

Now lets get the SCSI ID of each allocated disks. 

​

[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VB08403387-0ac24dcd
[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VB1b9dfa49-6659a7f0
[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VB53c3582c-5f7bb843
[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde
1ATA_VBOX_HARDDISK_VBe980899c-ea6950cb
[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf
1ATA_VBOX_HARDDISK_VBb464d587-aa218911
[root@dbgenre_r1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdg
1ATA_VBOX_HARDDISK_VB415e4741-2b6956bc

​

Now lets add these SCSI IDs to asmdevices.rules file. 

​

[root@dbgenre_r1 ~]# vi /etc/udev/rules.d/99-oracle-asmdevices.rules

​

KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB08403387-0ac24dcd", SYMLINK+="oracleasm/asmdisk1", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB1b9dfa49-6659a7f0", SYMLINK+="oracleasm/asmdisk2", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB53c3582c-5f7bb843", SYMLINK+="oracleasm/asmdisk3", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBe980899c-ea6950cb", SYMLINK+="oracleasm/asmdisk4", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBb464d587-aa218911", SYMLINK+="oracleasm/asmdisk5", OWNER="oracle", GROUP="dba", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB415e4741-2b6956bc", SYMLINK+="oracleasm/asmdisk6", OWNER="oracle", GROUP="dba", MODE="0660"

​

[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sdb1
[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sdc1
[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sdd1
[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sde1
[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sdf1
[root@dbgenre_r1 ~]# /sbin/partprobe /dev/sdg1

​

Reload the UDEV Rules. 

​

[root@dbgenre_r1 ~]# /sbin/udevadm control --reload-rules

​

Check if all disks are visible now. 

​

[root@dbgenre_r1 dev]# ls -al /dev/oracleasm/*
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk1 -> ../sdb1
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk2 -> ../sdc1
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk3 -> ../sdd1
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk4 -> ../sde1
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk5 -> ../sdf1
lrwxrwxrwx. 1 root root 7 Jun  7 08:05 /dev/oracleasm/asmdisk6 -> ../sdg1

​

​

Cloning RAC node2: (dbgenre_r2)

​

Shutdown the node 1. 

​

Mac OS X: 

​

mkdir -p /Users/balaajidhananjayan/VirtualBox_VMs/New_group/dbgenre_r2/

​

balaajidhananjayan@balaajidhananjayan-JSS1856 dbgenre_r2 % VBoxManage clonehd /Users/balaajidhananjayan/VirtualBox_VMs/New_group/dbgenre_r1/dbgenre_r1.vdi /Users/balaajidhananjayan/VirtualBox_VMs/New_group/dbgenre_r2/dbgenre_r2.vdi
0%...10%...20%...30%...40%...50%...60%...70%...80%...90%...100%
Clone medium created in format 'VDI'. UUID: 2a10fe3c-7ff9-43f2-be83-e0e937b5c35d

​

​

Windows:

​

mkdir "C:\VirtualBox\dbgenre_r2"

"c:\Program Files\Oracle\VirtualBox\VBoxManage" clonehd "C:\VirtualBox\dbgenre_r1\dbgenre_r1.vdi" "C:\VirtualBox\dbgenre_r2\dbgenre_r2.vdi"

​

​

  • Create a new VM with name "dbgenre_r2". You just have to mention right folder name and use the cloned .vdi file. 

  • Click "Create"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

  • Add all 3 network adapters as you did at very beginning while creating the first VM. 

​

Now attach the shared storage to the 2nd node (dbgenre_r2). 

​

MAC OS X:

​


cd /Users/balaajidhananjayan/Documents/Virtualbox/shared/dbgenre_r1-121-rac

VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm11.vdi --mtype shareable
VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm12.vdi --mtype shareable
VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm13.vdi --mtype shareable
VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm14.vdi --mtype shareable
VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm15.vdi --mtype shareable
VBoxManage storageattach dbgenre_r2 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm16.vdi --mtype shareable

​

​

WINDOWS OS:

​

cd C:\VirtualBox\dbgenre_r1-121-rac

​

"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm11.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm12.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm13.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm14.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm15.vdi --mtype shareable
"C:\Program Files\Oracle\VirtualBox\VBoxManage" storageattach dbgenre_r2 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm16.vdi --mtype shareable

​

​

Let's start dbgenre_r2 VM and configure its network settings. 

​

  • hostname: dbgenre_r2.local

​

[root@dbgenre_r1 ~]# nmcli general hostname
dbgenre_r1.localdomain
[root@dbgenre_r1 ~]# nmcli general hostname dbgenre_r2.local
[root@dbgenre_r1 ~]# nmcli general hostname
dbgenre_r1.localdomain
[root@dbgenre_r1 ~]# service systemd-hostnamed restart
Redirecting to /bin/systemctl restart systemd-hostnamed.service
[root@dbgenre_r1 ~]# hostname
dbgenre_r2.local

​

  • bash_profile

​

[balaaji@dbgenre_r2 ~]$ su - oracle
Password:
Last login: Sun Jun  7 03:30:58 EDT 2020 on pts/0
[oracle@dbgenre_r2 ~]$
[oracle@dbgenre_r2 ~]$ vi .bash_profile

​

export ORACLE_HOSTNAME=dbgenre_r2.local

export ORACLE_SID=raccdb2

​

Esc : wq!

​

Click here to perform the same steps for Node 2 of RAC.  Refer the IP addresses as given above. 

​​

  • enp0s3: DHCP (Disable Connect Automatically)

  • enp0s8: IP=192.168.56.101, Subnet=255.255.255.0, Gateway=192.168.56.1, DNS=192.168.56.1 (Enable Connect Automatically)

  • enp0s9: IP=192.168.1.101, Subnet=255.255.255.0, Gateway=<blank>, DNS=<blank> (Enable Connect Automatically)

​

Ones done, verify IPADDR from ifcfg-enp0s8 and ifcfg-enp0s9 network adapters from "/etc/sysconfig/network-scripts" location. 

​

ASM Disk config in Node2 (dbgenre-r2):

​

Reload the UDEV Rules. 

​

​

[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sdb1
[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sdc1
[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sdd1
[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sde1
[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sdf1
[root@dbgenre_r2 ~]# /sbin/partprobe /dev/sdg1

[root@dbgenre_r2 ~]# /sbin/udevadm control --reload-rules

​

Check if the disks are visible on dbgenre_r2. 

​

[balaaji@dbgenre_r2 ~]$ ls -ltr /dev/oracleasm/*
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk1 -> ../sdb1
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk2 -> ../sdc1
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk3 -> ../sdd1
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk4 -> ../sde1
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk5 -> ../sdf1
lrwxrwxrwx. 1 root root 7 Jun  7 13:11 /dev/oracleasm/asmdisk6 -> ../sdg1

​

Now restart the VM. 

​

[root@dbgenre_r1 network-scripts]# shutdown -r now
Connection to 192.168.56.102 closed by remote host.

​

​

Ones done, this is how it should look like.

 

[balaaji@dbgenre_r2 ~]$ ifconfig
enp0s3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        ether 08:00:27:c4:ec:64  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

enp0s8: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.56.102  netmask 255.255.255.0  broadcast 192.168.56.255
        inet6 fe80::ab40:a48e:11bf:1dbf  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:d0:2a:bc  txqueuelen 1000  (Ethernet)
        RX packets 45  bytes 5673 (5.5 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 110  bytes 12508 (12.2 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

enp0s9: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.1.102  netmask 255.255.255.0  broadcast 192.168.1.255
        inet6 fe80::2121:75ed:b809:37ec  prefixlen 64  scopeid 0x20<link>
        ether 08:00:27:27:b2:70  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 36  bytes 4700 (4.5 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

​

​

Ping all the FQDNs from both the nodes. 

​

ping dbgenre_r1.local

ping dbgenre_r2.local

ping dbgenre_r1-priv.local

ping dbgenre_r2-priv.local

​

Do nslookup multiple times and see if the IPs are doing a round robin. Here, im using my r1 node as DNS. So my nameserver IP is 192.168.56.101

​

[balaaji@dbgenre_r1 ~]$ nslookup dbgenre-121-scan.local
Server:     192.168.56.101
Address:    192.168.56.101#53

Name:    dbgenre-121-scan.local
Address: 192.168.56.105
Name:    dbgenre-121-scan.local
Address: 192.168.56.106
Name:    dbgenre-121-scan.local
Address: 192.168.56.107

​

Take a backup and a snapshot of your dbgenre_r1 and dbgenre_r2 nodes. 

​

  • Click File --> Export Appliance

  • Choose the node and appropriate path to export the Virtual appliance. (This may take a few minutes)

Introduction
Software Downloads
Screen Shot 2020-05-29 at 1.36.15 am.png
Screen Shot 2020-05-18 at 1.29.03 am.png
Screen Shot 2020-05-18 at 1.29.46 am.png
Screen Shot 2020-05-18 at 1.29.54 am.png
Screen Shot 2020-05-29 at 1.47.14 am.png
Screen Shot 2020-05-29 at 1.49.17 am.png
Screen Shot 2020-05-29 at 2.30.50 am.png
Screen Shot 2020-05-29 at 2.30.38 am.png
Screen Shot 2020-05-29 at 2.36.39 am.png
Screen Shot 2020-05-29 at 2.39.02 am.png
Screen Shot 2020-05-29 at 2.03.07 am.png
VM Install
VM Config
Screen Shot 2020-05-18 at 1.33.18 am.png
Network Setup
Screen Shot 2020-06-07 at 5.53.04 pm.png
Screen Shot 2020-06-07 at 5.42.57 pm.png
Screen Shot 2020-06-08 at 12.52.06 am.pn
Machine Setup
Guest OS Install
Installation Prereqs
Create Shared Disks
Clonning RAC node2

Grid Infrastructure Installation:

​

cd /app/oracle/softwares/grid/rpm

rpm -Uvh cvuqdisk*

​

If you are invoking installer from remote machine (local computer's putty), you may have to setup x11 (xming) and you will need to export the display to the local machine to have the UI forwarded to local system. I recommend using mobaxterm here. It is quite easy and handy. 

​

cd /app/oracle/softwares/grid

./runInstaller

​

Click "Next"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Leave on default as "Configure a Standar cluster" and Click "Next"

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

Choose "Advanced Installation" and click "Next"

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

Click "Next"

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

Mention the chosen cluster and SCAN name. Click "Next"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Add node 2. Click on "SSH connectivity" and give oracle password. Then click on setup to enable password-less auth setup.

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

You should see below prompt upon successful setup. 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Choose 192.168.56.0 as "Public" and 192.168.1.0 as "Private". Rest of them set it to "Do Not Use". Click next. 

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

"Use Standard ASM for Storage" 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Allocating DATA disk group with only 2 disks as of now. Rest all I am keeping as candicates to add FRA and future use. 

Click "Next" 

​

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

Set default password for all admin accounts. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Not using IPMI here. Click "Next".

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Keep "dba" group for system authentication. Click "Next"

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

/app/oracle will be ORACLE_BASE

Replace software location to /app/oragrid/product/12.1.0.2/grid - Basically it should be out of ORACLE_BASE. 

Click "Next"

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Inventoey Directory is /app/oraInventory

Click "Next"

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Pre-checks will start

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Use "Fix & Check Again" feature to solve system level issues. This will generate fixup script to be run as root. Please follow instructions. 

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Ignore rest of warnings. Click "Next".

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Run orainstRoot.sh and root.sh on both the node. 

Note: Run these .sh scripts node by node starting from 1st node where installation was initiated. 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Once installation is done, click on close.

Open a new putty to connect to server and check clusterware status

​

[oracle@dbgenre-r2 ~]$ . oraenv
ORACLE_SID = [raccdb1] ? +ASM2
The Oracle base remains unchanged with value /app/oracle
[oracle@dbgenre-r2 ~]$
[oracle@dbgenre-r2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.asm
               ONLINE  ONLINE       dbgenre-r1               Started,STABLE
               ONLINE  ONLINE       dbgenre-r2               Started,STABLE
ora.net1.network
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.ons
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       dbgenre-r1               169.254.167.200 192.
                                                             168.1.101,STABLE
ora.cvu
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.dbgenre-r1.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.dbgenre-r2.vip
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       dbgenre-r1               Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
--------------------------------------------------------------------------------
 

Well done, you should have successfully completed Grid Infrastructure installation now. 

​

Once installation is done. Use asmca utility (invoke after grid installation) to create another Disk Group "+FRA". 

​

1.PNG
2.PNG
3.PNG
4.PNG
5.PNG
6.PNG
7.PNG
8.PNG
9.PNG
10.PNG
11.PNG
12.PNG
13.PNG
14.PNG
16.PNG
17.PNG
18.PNG
19.PNG
20.PNG
21.PNG
22.PNG
23.PNG
Grid Instrastructure Installation

Database Software Installation:

​

[oracle@dbgenre-r1 ~]$ cd /app/oracle/softwares/database
[oracle@dbgenre-r1 database]$ ./runInstaller

​

Please follow below screen shots to get the database software only installation. 

​

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Login from both nodes as root and run the root.sh script as instructed. 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

Create cluster database: 

​

[oracle@dbgenre-r1 dbhome1]$ /app/oracle/product/12.1.0.2/dbhome1/bin/dbca

 

Please follow below screenshots to create a cluster database. 
 

​

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Mention both +DATA and +FRA diskgroup details appropriately.

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

Leave below memory settings to default. 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

 

 

 

 

​

​

​

​

​

Click on close once the database is created. 

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

 

Check overall status: 

​

[oracle@dbgenre-r1 dbhome1]$ crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.FRA.dg
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.asm
               ONLINE  ONLINE       dbgenre-r1               Started,STABLE
               ONLINE  ONLINE       dbgenre-r2               Started,STABLE
ora.net1.network
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
ora.ons
               ONLINE  ONLINE       dbgenre-r1               STABLE
               ONLINE  ONLINE       dbgenre-r2               STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       dbgenre-r1               169.254.167.200 192.
                                                             168.1.101,STABLE
ora.cvu
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.dbgenre-r1.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.dbgenre-r2.vip
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       dbgenre-r1               Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.raccdb.db
      1        ONLINE  ONLINE       dbgenre-r1               Open,STABLE
      2        ONLINE  ONLINE       dbgenre-r2               Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       dbgenre-r2               STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       dbgenre-r1               STABLE
--------------------------------------------------------------------------------
[oracle@dbgenre-r1 dbhome1]$

​

Great!! Hope you have successfully create the RAC database and this article was helpful. 

Database Softwar Intalatin
1.PNG
2.PNG
3.PNG
4.PNG
5.PNG
6.PNG
7.PNG
8.PNG
9.PNG
10.PNG
11.PNG
12.PNG
13.PNG
14.PNG
dbca1.PNG
dbca2.PNG
dbca3.PNG
dbca4.PNG
dbca5.PNG
dbca6.PNG
dbca7.PNG
dbca8.PNG
dbca9.PNG
dbca10.PNG
dbca11.PNG
dbca12.PNG
dbca13.PNG
dbca14.PNG
Create Cluster Database
Check overall status
bottom of page