This is an attempt at familiarizing with the installation and configuration of Oracle RAC 18.3.0 in a lab environment. The system built here is not suitable for any production use. While it is a cluster, the underlying hardware resources are not redundant.
Home network serviced by pfSense appliance for DHCP and DNS
DNS Entries
cos7-db183-rac1: 192.168.102.151
cos7-db183-rac2: 192.168.102.152
cos7-db183-rac3: 192.168.102.153
cos7-db183-rac1-vip: 192.168.102.154
cos7-db183-rac2-vip: 192.168.102.155
cos7-db183-rac3-vip: 192.168.102.156
cos7-db183-scan: 192.168.102.157, 192.168.102.158, 192.168.102.159
Private / local entries
cos7-db183-rac1-priv: 192.168.56.151
cos7-db183-rac2-priv: 192.168.56.152
cos7-db183-rac3-priv: 192.168.56.153
This VM will be configured, and then cloned to make the remaining nodes.
Name and operating system
Name: cos7-db183-rac1
Type: Linux
Version: Red Hat (64-bit)
Next >
Memory size
12288 MB
Next >
Hard Disk
Create a virtual hard disk now
Next >
Hard disk file type
VDI (VirtualBox Disk Image)
Next >
Storage on physical hard disk
Dynamically allocated
Next >
File location and size
cos7-db183-rac1
80gb
Create
The machine has now been created, but needs further configuration before installing the OS. Select the machine in the VirtualBox GUI and click Settings.
System/Motherboard
Deselect Floppy
System/Processor
Increase Processor from 1 to 4
Storage
Attach CentOS media to Optical drive
Modify "Controller: SATA" to increase the number of ports from 1 to 16 and to use host IO controller cache.
Audio
De-select Enable Audio
Network
Adapter 1
Attach to Bridged Adapter
Adapter 2
Attach to Host-only Adapter vboxnet0
Shared Folders
Add share that contains the Oracle media, select Auto-mount
Click OK
Power on Virtual machine
Select language and keyboard layout and click Continue
NETWORK & HOST NAME
Enter host name cos7-db183-rac1.arda.org
Select Ethernet (enp0s3) and click Configure
General
Select Automatically connect to this network when it is available
Click Save
Select Ethernet (enps0s8) and click Configure
General
Select Automatically connect to this network when it is available
IPv4 Settings
Select method Manual
In Addresses section, Click Add
Enter address 192.168.56.151 and Netmask 24.
Click Save
Click Done
KDUMP
De-select Enable kdump
Click Done
INSTALLATION
Select I will configure partitioning
Click Done
Add three mount points:
Click Done
When prompted, select Accept Changes
DATE & TIME
Select desired time zone
Click Done
Click Begin Installation
CONFIGURATION
Set a password for root
Optionally, create a non-root administrative user
Wait for the installation to complete
Log in as root
yum install deltarpm bzip2 kernel-devel gcc make perl
yum update
shutdown -r now
Log in as root
Mount VirtualBox Guest Additions CD and run VBoxLinuxAdditions.run
Append line to /etc/sysconfig/network:
NOZEROCONF=yes
Create file /etc/security/limits.d/99-oracle_security_limits.conf and populate with this block:
grid soft nofile 1024
grid hard nofile 65536
grid soft nproc 16384
grid hard nproc 16384
grid soft stack 10240
grid hard stack 32768
grid hard memlock 134217728
grid soft memlock 134217728
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft nproc 262144
oracle hard nproc 262144
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
Create file /etc/sysctl.d/90-oracle.conf and populate with this block:
Add to /etc/sysctl.conf:
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmall = 1073741824
kernel.shmmni = 4096
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 16384 65500
Disable transparent hugepages:
mkdir /etc/tuned/nothp_profile
Create file /etc/tuned/nothp_profile/tuned.conf and populate it with this:
[main]
include= throughput-performance
[vm]
transparent_hugepages=never
Activate profile with tuned-adm
/sbin/tuned-adm profile nothp_profile
Add needed packages
sudo yum install nscd bc binutils compat-libcap1 \
compat-libstdc++-33.i686 \
compat-libstdc++-33.x86_64 glibc.i686 glibc.x86_64 glibc-devel.i686 \
glibc-devel.x86_64 ksh libaio.i686 libaio.x86_64 libaio-devel.i686 \
libaio-devel.x86_64 libX11.i686 libX11.x86_64 libXau.i686 \
libXau.x86_64 libXi.i686 libXi.x86_64 libXtst.i686 libXtst.x86_64 \
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 \
libstdc++-devel.i686 libstdc++-devel.x86_64 libxcb.i686 \
libxcb.x86_64 make nfs-utils net-tools python gcc-c++ zip unzip \
python-configshell python-rtslib python-six smartmontools \
sysstat targetcli xorg-x11-apps xorg-x11-utils xorg-x11-xauth
Set SELinux to permissive
[root@cos7-db122-rac1 ~]# cat /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=permissive
# SELINUXTYPE= can take one of three two values:
# targeted - Targeted processes are protected,
# minimum - Modification of targeted policy. Only selected processes are protected.
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
Enable and start NSCD
systemctl status nscd
systemctl start nscd
systemctl enable nscd
Set RemoveIPC=no by uncommenting line in /etc/systemd/logind.conf
Explicitly configure /dev/shm by adding
tmpfs /dev/shm tmpfs size=6g 0 0
to /etc/fstab
Add groups for Oracle
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 dgdba
groupadd -g 54325 kmdba
groupadd -g 54326 backupdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmadmin
groupadd -g 54329 asmoper
Create oracle user:
useradd -u 54321 -g oinstall -G dba,oper,dgdba,kmdba,backupdba,asmdba,wheel,vboxsf oracle
passwd oracle
Create grid user:
useradd -u 54322 -g oinstall -G asmdba,asmadmin,asmoper,wheel,vboxsf grid
passwd grid
Create base directory structure for Oracle
mkdir -p /u01/app/oracle/product/18.3.0/dbhome_1
chown -R oracle:oinstall /u01/app
chmod -R 775 /u01/app
Create base directory structure for Grid Infrastructure
mkdir -p /u01/app/18.3.0/grid
chown -R grid:oinstall /u01/app/18.3.0
Add cvuqdisk package
CVUQDISK_GRP=oinstall; export CVUQDISK_GRP
yum install cvuqdisk-1.0.10-1.rpm
Make SCSI devices trusted
[root@cos7-db122-rac1 ~]# cat /etc/scsi_id.config
options=-g
[root@cos7-db122-rac1 ~]#
Disable firewalld. It should be possible to open specific ports. Play with that another day.
[root@cos7-db122-rac1 ~]# systemctl disable firewalld
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
Update /etc/hosts to include addresses for nodes in cluster. RAC requires addresses be available via both DNS and /etc/hosts. Add this block:
# Public addresses
192.168.102.151 cos7-db183-rac1.arda.org cos7-db183-rac1
192.168.102.152 cos7-db183-rac2.arda.org cos7-db183-rac2
192.168.102.153 cos7-db183-rac3.arda.org cos7-db183-rac3
# VIP addresses
192.168.102.154 cos7-db183-rac1-vip.arda.org cos7-db183-rac1-vip
192.168.102.155 cos7-db183-rac2-vip.arda.org cos7-db183-rac2-vip
192.168.102.156 cos7-db183-rac3-vip.arda.org cos7-db183-rac3-vip
# SCAN addresses
192.168.102.157 cos7-db183-scan.arda.org cos7-db183-scan
192.168.102.158 cos7-db183-scan.arda.org cos7-db183-scan
192.168.102.159 cos7-db183-scan.arda.org cos7-db183-scan
# Private addresses
192.168.56.151 cos7-db183-rac1-priv.arda.org cos7-db183-rac1-priv
192.168.56.152 cos7-db183-rac2-priv.arda.org cos7-db183-rac2-priv
192.168.56.153 cos7-db183-rac3-priv.arda.org cos7-db183-rac3-priv
Modify .bash_profile for oracle and grid users to include
if [ -t 0 ]; then
stty intr ^C
fi
Shut down system
From the VirtualBox GUI, select cos7-db183, right-click and choose Clone
Specify cos7-db183-rac2 as New machine name
Select Reinitialize the MAC address of all network cards
Click Next >
Select Full Clone
Click Clone
Power on the new machine
Log in as root
Update /etc/hostname, changing rac1 to rac2
Update /etc/sysconfig/network-scripts/ifcfg-enp0s3 to specify new UUID
update /etc/sysconfig/network-scripts/ifcfg-enp0s8 to specify new UUID and change 192.168.56.151 to 192.168.56.152
Shut down
Creating this clone for a subsequent exercise--increasing the cluster from two nodes to three nodes. So once this clone is made, we will not use it for the remainder of the exercise.
From the VirtualBox GUI, select cos7-db183, right-click and choose Clone
Specify cos7-db183-rac3 as New machine name
Select Reinitialize the MAC address of all network cards
Click Next >
Select Full Clone
Click Clone
Power on the new machine
Log in as root
Update /etc/hostname, changing rac1 to rac3
Update /etc/sysconfig/network-scripts/ifcfg-enp0s3 to specify new UUID
update /etc/sysconfig/network-scripts/ifcfg-enp0s8 to specify new UUID and change 192.168.56.151 to 192.168.56.153
Shut down
Let’s plan on four disk groups. The different disk sizes are so that we can differentiate at the OS level when working on UDEV rules & whatnot.
DATA: for database files. External redundancy. 2x20gb disk files.
FRA: for fast recovery area files. External redundancy. 2x25gb disk files.
OCR: for OCR and voting files. Normal redundancy. 3x10gb disk files.
MGMT: for mgmtdb database files. External redundancy. 2x30gb disk files.
[ttaylor@t2 ~]$ cd /vms/ttaylor/vms/
[ttaylor@t2 vms]$ df -h .
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/vgvms-lv_vms 512G 200G 313G 39% /vms
[ttaylor@t2 vms]$
[ttaylor@t2 vms]$ mkdir cos7-db183-rac
[ttaylor@t2 vms]$ cd cos7-db183-rac
Use the VBoxManage utility to create the shared disks.
VBoxManage createhd --filename asm_data_01.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename asm_data_02.vdi --size 20480 --format VDI --variant Fixed
VBoxManage createhd --filename asm_fra_01.vdi --size 25600 --format VDI --variant Fixed
VBoxManage createhd --filename asm_fra_02.vdi --size 25600 --format VDI --variant Fixed
VBoxManage createhd --filename asm_ocr_01.vdi --size 10240 --format VDI --variant Fixed
VBoxManage createhd --filename asm_ocr_02.vdi --size 10240 --format VDI --variant Fixed
VBoxManage createhd --filename asm_ocr_03.vdi --size 10240 --format VDI --variant Fixed
VBoxManage createhd --filename asm_mgmt_01.vdi --size 31720 --format VDI --variant Fixed
VBoxManage createhd --filename asm_mgmt_02.vdi --size 31720 --format VDI --variant Fixed
Confirm the file names & storage allocation.
[ttaylor@t2 cos7-db183-rac]$ du -hs .
182G .
[ttaylor@t2 cos7-db183-rac]$ ls -l
total 190810112
-rw-------. 1 ttaylor ttaylor 21476933632 Jul 29 12:18 asm_data_01.vdi
-rw-------. 1 ttaylor ttaylor 21476933632 Jul 29 12:18 asm_data_02.vdi
-rw-------. 1 ttaylor ttaylor 26845642752 Jul 29 12:18 asm_fra_01.vdi
-rw-------. 1 ttaylor ttaylor 26845642752 Jul 29 12:18 asm_fra_02.vdi
-rw-------. 1 ttaylor ttaylor 33262927872 Jul 29 12:18 asm_mgmt_01.vdi
-rw-------. 1 ttaylor ttaylor 33262927872 Jul 29 12:18 asm_mgmt_02.vdi
-rw-------. 1 ttaylor ttaylor 10739515392 Jul 29 12:18 asm_ocr_01.vdi
-rw-------. 1 ttaylor ttaylor 10739515392 Jul 29 12:18 asm_ocr_02.vdi
-rw-------. 1 ttaylor ttaylor 10739515392 Jul 29 12:18 asm_ocr_03.vdi
[ttaylor@t2 cos7-db183-rac]$
Attach the disks to nodes one and two. NOT attaching to node three yet, as a later exercise will be to expand the cluster.
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm_data_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm_data_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm_fra_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm_fra_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm_ocr_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm_ocr_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 7 --device 0 --type hdd --medium asm_ocr_03.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 8 --device 0 --type hdd --medium asm_mgmt_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac1 --storagectl "SATA" --port 9 --device 0 --type hdd --medium asm_mgmt_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 1 --device 0 --type hdd --medium asm_data_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 2 --device 0 --type hdd --medium asm_data_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 3 --device 0 --type hdd --medium asm_fra_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 4 --device 0 --type hdd --medium asm_fra_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 5 --device 0 --type hdd --medium asm_ocr_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 6 --device 0 --type hdd --medium asm_ocr_02.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 7 --device 0 --type hdd --medium asm_ocr_03.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 8 --device 0 --type hdd --medium asm_mgmt_01.vdi --mtype shareable
VBoxManage storageattach cos7-db183-rac2 --storagectl "SATA" --port 9 --device 0 --type hdd --medium asm_mgmt_02.vdi --mtype shareable
Power on node 1 and confirm disks are present.
[ttaylor@cos7-db183-rac1 ~]$ lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 80G 0 disk
├─sda1 8:1 0 1G 0 part /boot
└─sda2 8:2 0 79G 0 part
├─centos_cos7--db183--rac1-root 253:0 0 67G 0 lvm /
└─centos_cos7--db183--rac1-swap 253:1 0 12G 0 lvm [SWAP]
sdb 8:16 0 20G 0 disk
sdc 8:32 0 20G 0 disk
sdd 8:48 0 25G 0 disk
sde 8:64 0 25G 0 disk
sdf 8:80 0 10G 0 disk
sdg 8:96 0 10G 0 disk
sdh 8:112 0 10G 0 disk
sdi 8:128 0 31G 0 disk
sdj 8:144 0 31G 0 disk
sr0 11:0 1 55.3M 0 rom
Partition the ASM devices. This should be done on only one node.
[root@cos7-db183-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 0xe5b0b744.
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-41943039, default 2048):
Using default value 2048
Last sector, +sectors or +size{K,M,G} (2048-41943039, default 41943039):
Using default value 41943039
Partition 1 of type Linux and of size 20 GiB is set
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
<snip, for brevity. Devices through sdj have been partitioned>
Verify all devices have partitions
[root@cos7-db183-rac1 ~]# lsblk
NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT
sda 8:0 0 80G 0 disk
├─sda1 8:1 0 1G 0 part /boot
└─sda2 8:2 0 79G 0 part
├─centos_cos7--db183--rac1-root 253:0 0 67G 0 lvm /
└─centos_cos7--db183--rac1-swap 253:1 0 12G 0 lvm [SWAP]
sdb 8:16 0 20G 0 disk
└─sdb1 8:17 0 20G 0 part
sdc 8:32 0 20G 0 disk
└─sdc1 8:33 0 20G 0 part
sdd 8:48 0 25G 0 disk
└─sdd1 8:49 0 25G 0 part
sde 8:64 0 25G 0 disk
└─sde1 8:65 0 25G 0 part
sdf 8:80 0 10G 0 disk
└─sdf1 8:81 0 10G 0 part
sdg 8:96 0 10G 0 disk
└─sdg1 8:97 0 10G 0 part
sdh 8:112 0 10G 0 disk
└─sdh1 8:113 0 10G 0 part
sdi 8:128 0 31G 0 disk
└─sdi1 8:129 0 31G 0 part
sdj 8:144 0 31G 0 disk
└─sdj1 8:145 0 31G 0 part
sr0 11:0 1 55.3M 0 rom
Configure UDEV rules
Reference https://oracle-base.com/articles/linux/udev-scsi-rules-configuration-in-oracle-linux
Get the SCSI IDs that we will need
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb
1ATA_VBOX_HARDDISK_VBb6be56c0-8cb8a379
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc
1ATA_VBOX_HARDDISK_VB14b73b1e-a6c00374
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdd
1ATA_VBOX_HARDDISK_VB4e3d3dbd-d41a5524
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sde
1ATA_VBOX_HARDDISK_VBe92b4b84-b30cb0ea
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdf
1ATA_VBOX_HARDDISK_VBa320b455-08224064
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdg
1ATA_VBOX_HARDDISK_VBf0f07ba7-d5a70672
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdh
1ATA_VBOX_HARDDISK_VB6ca06a66-36cb287c
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdi
1ATA_VBOX_HARDDISK_VBf6b595c9-717ffb62
[root@cos7-db183-rac1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdj
1ATA_VBOX_HARDDISK_VB9d16f7ef-55ee2daa
Updated UDEV rules file.
[root@cos7-db183-rac1 rules.d]# cat 99-oracle-asmdevices.rules
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBb6be56c0-8cb8a379", SYMLINK+="asmdisks/data-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB14b73b1e-a6c00374", SYMLINK+="asmdisks/data-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB4e3d3dbd-d41a5524", SYMLINK+="asmdisks/fra-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBe92b4b84-b30cb0ea", SYMLINK+="asmdisks/fra-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBa320b455-08224064", SYMLINK+="asmdisks/ocr-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBf0f07ba7-d5a70672", SYMLINK+="asmdisks/ocr-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB6ca06a66-36cb287c", SYMLINK+="asmdisks/ocr-disk3", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBf6b595c9-717ffb62", SYMLINK+="asmdisks/mgmt-disk1", OWNER="grid", GROUP="asmadmin", MODE="0660"
KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB9d16f7ef-55ee2daa", SYMLINK+="asmdisks/mgmt-disk2", OWNER="grid", GROUP="asmadmin", MODE="0660"
Run partprobe to apply rules to devices individually.
partprobe /dev/sdb
partprobe /dev/sdc
partprobe /dev/sdd
partprobe /dev/sde
partprobe /dev/sdf
partprobe /dev/sdg
partprobe /dev/sdh
partprobe /dev/sdi
partprobe /dev/sdj
And confirm that ownership has been changed.
[root@cos7-db183-rac1 rules.d]# ls -lL /dev/asmdisks
total 0
brw-rw----. 1 grid asmadmin 8, 17 Jul 29 12:43 data-disk1
brw-rw----. 1 grid asmadmin 8, 33 Jul 29 12:43 data-disk2
brw-rw----. 1 grid asmadmin 8, 49 Jul 29 12:43 fra-disk1
brw-rw----. 1 grid asmadmin 8, 65 Jul 29 12:43 fra-disk2
brw-rw----. 1 grid asmadmin 8, 129 Jul 29 12:43 mgmt-disk1
brw-rw----. 1 grid asmadmin 8, 145 Jul 29 12:43 mgmt-disk2
brw-rw----. 1 grid asmadmin 8, 81 Jul 29 12:43 ocr-disk1
brw-rw----. 1 grid asmadmin 8, 97 Jul 29 12:43 ocr-disk2
brw-rw----. 1 grid asmadmin 8, 113 Jul 29 12:43 ocr-disk3
[root@cos7-db183-rac1 rules.d]#
Power on node 2
Copy UDEV rules from node 1
[root@cos7-db183-rac2 ~]# cd /etc/udev/rules.d/
[root@cos7-db183-rac2 rules.d]# scp root@cos7-db183-rac1:/etc/udev/rules.d/99*.rules .
root@cos7-db183-rac1's password:
99-oracle-asmdevices.rules 100% 1958 909.7KB/s 00:00
Use partprobe to apply UDEV rules to devices
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdb
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdc
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdd
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sde
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdf
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdg
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdh
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdi
[root@cos7-db183-rac2 rules.d]# partprobe /dev/sdj
Verify that ownership has changed
[root@cos7-db183-rac2 rules.d]# ls -lL /dev/asmdisks
total 0
brw-rw----. 1 grid asmadmin 8, 17 Jul 29 12:46 data-disk1
brw-rw----. 1 grid asmadmin 8, 33 Jul 29 12:46 data-disk2
brw-rw----. 1 grid asmadmin 8, 49 Jul 29 12:46 fra-disk1
brw-rw----. 1 grid asmadmin 8, 65 Jul 29 12:46 fra-disk2
brw-rw----. 1 grid asmadmin 8, 129 Jul 29 12:47 mgmt-disk1
brw-rw----. 1 grid asmadmin 8, 145 Jul 29 12:47 mgmt-disk2
brw-rw----. 1 grid asmadmin 8, 81 Jul 29 12:47 ocr-disk1
brw-rw----. 1 grid asmadmin 8, 97 Jul 29 12:47 ocr-disk2
brw-rw----. 1 grid asmadmin 8, 113 Jul 29 12:47 ocr-disk3
[root@cos7-db183-rac2 rules.d]#
[root@cos7-db183-rac1 rules.d]# chown -R grid:oinstall /u01/app/18.3.0/grid
[root@cos7-db183-rac1 rules.d]#
[root@cos7-db183-rac1 rules.d]# su - grid
[grid@cos7-db183-rac1 ~]$ unzip -d /u01/app/18.3.0/grid /media/sf_OracleDatabase/Oracle18.3/LINUX.X64_180000_grid_home.zip
<snip>
finishing deferred symbolic links:
/u01/app/18.3.0/grid/bin/lbuilder -> ../nls/lbuilder/lbuilder
/u01/app/18.3.0/grid/lib/libocci.so -> libocci.so.18.1
/u01/app/18.3.0/grid/lib/libodm18.so -> libodmd18.so
/u01/app/18.3.0/grid/lib/libagtsh.so -> libagtsh.so.1.0
/u01/app/18.3.0/grid/lib/libclntsh.so -> libclntsh.so.18.1
/u01/app/18.3.0/grid/lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
/u01/app/18.3.0/grid/javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
/u01/app/18.3.0/grid/javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
/u01/app/18.3.0/grid/lib/libclntshcore.so -> libclntshcore.so.18.1
/u01/app/18.3.0/grid/lib/libclntsh.so.11.1 -> libclntsh.so
/u01/app/18.3.0/grid/lib/libclntsh.so.10.1 -> libclntsh.so
/u01/app/18.3.0/grid/javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
/u01/app/18.3.0/grid/javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
/u01/app/18.3.0/grid/javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
/u01/app/18.3.0/grid/javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
/u01/app/18.3.0/grid/javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
/u01/app/18.3.0/grid/javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
/u01/app/18.3.0/grid/javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
/u01/app/18.3.0/grid/javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
[grid@cos7-db183-rac1 ~]$
As root, initialize devices for ASM
[grid@cos7-db183-rac1 ~]$ export ORACLE_HOME=/u01/app/18.3.0/grid
[grid@cos7-db183-rac1 ~]$ export ORACLE_BASE=/tmp
[grid@cos7-db183-rac1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
Apply labels
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label DATA1 /dev/asmdisks/data-disk1 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label DATA2 /dev/asmdisks/data-disk2 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label FRA1 /dev/asmdisks/fra-disk1 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label FRA2 /dev/asmdisks/fra-disk2 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label MGMT1 /dev/asmdisks/mgmt-disk1 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label MGMT2 /dev/asmdisks/mgmt-disk2 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label OCR1 /dev/asmdisks/ocr-disk1 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label OCR2 /dev/asmdisks/ocr-disk2 --init
[grid@cos7-db183-rac1 ~]$ asmcmd afd_label OCR3 /dev/asmdisks/ocr-disk3 --init
[grid@cos7-db183-rac1 ~]$
To confirm labels
[grid@cos7-db183-rac1 ~]$ asmcmd afd_lslbl '/dev/asmdisks/*'
--------------------------------------------------------------------------------
Label Duplicate Path
================================================================================
DATA1 /dev/asmdisks/data-disk1
DATA2 /dev/asmdisks/data-disk2
FRA1 /dev/asmdisks/fra-disk1
FRA2 /dev/asmdisks/fra-disk2
MGMT1 /dev/asmdisks/mgmt-disk1
MGMT2 /dev/asmdisks/mgmt-disk2
OCR1 /dev/asmdisks/ocr-disk1
OCR2 /dev/asmdisks/ocr-disk2
OCR3 /dev/asmdisks/ocr-disk3
[grid@cos7-db183-rac1 ~]$
[grid@cos7-db183-rac1 ~]$ export ORACLE_HOME=/u01/app/18.3.0/grid
[grid@cos7-db183-rac1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[grid@cos7-db183-rac1 ~]$ cd $ORACLE_HOME
[grid@cos7-db183-rac1 grid]$ ./gridSetup.sh
Configuration Option
Select Configure Oracle Grid Infrastructure for a New Cluster
Click Next >
Cluster Configuration
Select Configure an Oracle Standalone Cluster
click Next >
Grid Plug and Play
Select create Local SCAN
Cluster Name: cos7-db183
SCAN Name: cos7-db183-scan
SCAN Port: 1521
Click Next
Cluster Node Information
Click Add
Select Add a single node
Public Hostname: cos7-db183-rac2.arda.org
Node Role: HUB
Virtual Hostname: cos7-db183-rac2-vip.arda.org
Click OK
Click SSH Connectivity
Enter the password for the grid user
Click Setup
Wait for the Success message and click OK
Click Next >
Network Interface Usage
enp0s3: Public
enps0s8: ASM & Private
Click Next >
Storage Option
Select Configure ASM using block devices
Grid Infrastructure Management Repository Option
Select Yes
Create ASM Disk Group
Click Change Discovery Path
Disk Discovery Path: /dev/asmdisks/*
Click OK
Disk group name: OCR
Redundancy Normal
Allocation Unit Size: 4MB
Select /dev/asmdisks/ocr-disk1 /dev/asmdisks/ocr-disk2 and /dev/asmdisks/ocr-disk3
Click Next >
GIMR Data Disk Group
Disk group name: MGMT
Redundancy: External
Allocation Unit Size: 4MB
Select /dev/asmdisks/mgmt-disk1 and /dev/asmdisks/mgmt-disk2
Click Next >
ASM Password
Enter passwords for SYS and ASMSNMP
Click Next >
Failure Isolation
Select Do not use Intelligent Platform Management Interface (IPMI)
Click Next >
Management Options
Do not select Register with Enterprise Manager (EM) Cloud Control
Click Next >
Operating System Groups
Oracle ASM Administrator (OSASM) Group: asmadmin
Oracle ASMDBA (OSDBA for ASM) Group: asmdba
Oracle ASM Operator (OSOPER for ASM) Group (Optional): asmoper
Click Next >
Installation Options
Oracle base: /u01/app/18.3.0/grid_base
Click Next >
Create Inventory
Inventory Directory: /u01/app/18.3.0/oraInventory
Click Next >
Root script execution
Select Automatically run configuration scripts
Select Use sudo
Enter password for grid
Click Next >
Prerequisite Checks
If everything was done correctly, the prerequisite checks should have all passed. If not, take this opportunity to address.
Summary
Review the settings
Click Install
The installer will now display a progress page.
When it is ready to run the steps that need privileged access, it will display a prompt "Configuration scripts generated by the installer need to be run as a privileged user (root). Installer will run these scripts user credentials provided earlier. Are you sure you want to continue?"
Click Yes
The installer will continue.
Finish
Click close
Check the status of the cluster.
[grid@cos7-db183-rac1 grid]$ crsctl check cluster -all
**************************************************************
cos7-db183-rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
cos7-db183-rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@cos7-db183-rac1 grid]$
[grid@cos7-db183-rac1 grid]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.OCR.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.chad
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.net1.network
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.ons
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE cos7-db183-rac1 169.254.3.98 192.168
.56.151,STABLE
ora.asm
1 ONLINE ONLINE cos7-db183-rac1 Started,STABLE
2 ONLINE ONLINE cos7-db183-rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cos7-db183-rac1.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.cos7-db183-rac2.vip
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.cvu
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE cos7-db183-rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
--------------------------------------------------------------------------------
[grid@cos7-db183-rac1 grid]$
The installation process created the OCR and MGMT disk groups used for the cluster. Now create DATA and FRA disk groups that will be used for hosted databases.
[grid@cos7-db183-rac1 ~]$ export ORACLE_HOME=/u01/app/18.3.0/grid
[grid@cos7-db183-rac1 ~]$ export PATH=$PATH:$ORACLE_HOME/bin
[grid@cos7-db183-rac1 grid]$ asmca &
[1] 733
Select Disk Groups in the tree view
Click Create
Disk Group Name: DATA
Redundancy: External
Select /dev/asmdisks/data-disk1 and /dev/asmdisks/data-disk2
Click OK
Click Create
Disk Group Name: FRA
Redundancy: External
Select /dev/asmdisks/fra-disk1 and /dev/asmdisks/fra-disk2
Click OK
Click Exit
Show the disk groups:
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 40952 40808 0 40808 0 N DATA/
MOUNTED EXTERN N 512 512 4096 4194304 51192 51048 0 51048 0 N FRA/
MOUNTED EXTERN N 512 512 4096 4194304 63432 39640 0 39640 0 N MGMT/
MOUNTED NORMAL N 512 512 4096 4194304 30708 29792 10236 9778 0 Y OCR/
[oracle@cos7-db183-rac1 ~]$ unzip -d /u01/app/oracle/product/18.3.0/dbhome_1 /media/sf_OracleDatabase/Oracle18.3/LINUX.X64_180000_db_home.zip
<snip>
finishing deferred symbolic links:
/u01/app/oracle/product/18.3.0/dbhome_1/bin/lbuilder -> ../nls/lbuilder/lbuilder
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libocci.so -> libocci.so.18.1
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libodm18.so -> libodmd18.so
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libagtsh.so -> libagtsh.so.1.0
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libclntsh.so -> libclntsh.so.18.1
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libjavavm18.a -> ../javavm/jdk/jdk8/lib/libjavavm18.a
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/jce.jar -> ../../javavm/jdk/jdk8/lib/jce.jar
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/admin/cbp.jar -> ../../javavm/jdk/jdk8/admin/cbp.jar
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libclntshcore.so -> libclntshcore.so.18.1
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libclntsh.so.11.1 -> libclntsh.so
/u01/app/oracle/product/18.3.0/dbhome_1/lib/libclntsh.so.10.1 -> libclntsh.so
/u01/app/oracle/product/18.3.0/dbhome_1/precomp/public/ORACA.H -> oraca.h
/u01/app/oracle/product/18.3.0/dbhome_1/precomp/public/SQLCA.H -> sqlca.h
/u01/app/oracle/product/18.3.0/dbhome_1/precomp/public/SQLDA.H -> sqlda.h
/u01/app/oracle/product/18.3.0/dbhome_1/precomp/public/ORACA.COB -> oraca.cob
/u01/app/oracle/product/18.3.0/dbhome_1/precomp/public/SQLCA.COB -> sqlca.cob
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/admin/classes.bin -> ../../javavm/jdk/jdk8/admin/classes.bin
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/admin/libjtcjt.so -> ../../javavm/jdk/jdk8/admin/libjtcjt.so
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/admin/lfclasses.bin -> ../../javavm/jdk/jdk8/admin/lfclasses.bin
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/security/cacerts -> ../../../javavm/jdk/jdk8/lib/security/cacerts
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/sunjce_provider.jar -> ../../javavm/jdk/jdk8/lib/sunjce_provider.jar
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/security/java.security -> ../../../javavm/jdk/jdk8/lib/security/java.security
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/security/local_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/local_policy.jar
/u01/app/oracle/product/18.3.0/dbhome_1/javavm/lib/security/US_export_policy.jar -> ../../../javavm/jdk/jdk8/lib/security/US_export_policy.jar
[oracle@cos7-db183-rac1 ~]$
[oracle@cos7-db183-rac1 ~]$ cd /u01/app/oracle/product/18.3.0/dbhome_1/
[oracle@cos7-db183-rac1 dbhome_1]$ ./runInstaller
Configuration Option
Select Set Up Software Only
Click Next >
Database Installation Options
Select Oracle Real Application Clusters database installation
Click Next >
Nodes Selection
Select cos7-db183-rac1 and cos7-db183-rac2
Click SSH connectivity
Enter oracle password
Click Setup
When prompted that SSH connectivity has been established, click OK
Click Next >
Database Edition
Select Enterprise Edition
Click Next >
Installation Location
Oracle base: /u01/app/oracle
Click Next >
Operating System Groups
Database Administrator (OSDBA) group: dba
Database Operator (OSOPER) group (Optional): oper
Database Backup and Recovery (OSBACKUPDBA) group: backupdba
Data Guard administrative (OSDGDBA) group: dgdba
Encryption Key Management administrative (OSKMDBA) group: kmdba
Real Application Cluster administrative (OSRACDBA) group: dba
Click Next >
Prerequisite Checks
All checks should pass, and the installation process automatically proceed.
Summary
Review the information
Click Install
The installer will continue until the root script needs to be run.
On each node, su to root or use sudo to run /u01/app/oracle/product/18.3.0/dbhome_1/root.sh.
Click OK.
Finish
Click Close
[oracle@cos7-db183-rac1 dbhome_1]$ export ORACLE_HOME=/u01/app/oracle/product/18.3.0/dbhome_1
[oracle@cos7-db183-rac1 dbhome_1]$ export ORACLE_BASE=/u01/app/oracle
[oracle@cos7-db183-rac1 dbhome_1]$ export PATH=$PATH:$ORACLE_HOME/bin
[oracle@cos7-db183-rac1 dbhome_1]$
[oracle@cos7-db183-rac1 dbhome_1]$ dbca &
[1] 30965
Database Operation
Select Create a database
Click Next >
Creation Mode
Select Advanced configuration
Click Next >
Deployment Type
Database Type: Oracle Real Application Cluster (RAC) Database
Configuration Type: Admin Managed
Select Custom Database
Click Next >
Nodes Selection
Select cos7-db183-rac1 and cos7-db183-rac2
Click Next >
Database Identification
Global database name: t2orcl.arda.org
SID Prefix: t2orcl
Select Create as Container database
Select Use Local Undo tablespace for PDBS
Select Create an empty Container database
Click Next >
Storage Option
Select Use following for the database storage attributes
Database files storage type: Automatic Storage Management (ASM)
Database files location: +DATA/{DB_UNIQUE_NAME}
Select Use Oracle-Managed Files (OMF)
Click Next >
Fast Recovery Option
Select Specify Fast Recovery Area
Recovery files storage type: Automatic Storage Management (ASM)
Fast Recovery Area: +FRA
Fast Recovery Area Size: 25600 MB
Select Enable archiving
Click Next >
Database Options
Click Next >
Configuration Options
Select Use Automatic Shared Memory Management
SGA Size: 3603 MB
PGA Size: 1201 MB
Click Next >
Management Options
Select Run Cluster Verification Utility (CVU) checks periodically
Select Configure Enterprise Manager (EM) database express
EM database express port: 5500
Click Next >
User Credentials
Enter passwords for SYS, SYSTEM, and DBSNMP
Click Next >
Creation Option
Select Create database
Click Next >
Prerequisite Checks
All checks should pass and the installer continue to Summary
Summary
Click Finish
The installation process will take quite some time.
When it completes, click Close
[grid@cos7-db183-rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.DATA.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.FRA.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.OCR.dg
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.chad
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.net1.network
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
ora.ons
ONLINE ONLINE cos7-db183-rac1 STABLE
ONLINE ONLINE cos7-db183-rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE cos7-db183-rac1 169.254.3.98 192.168
.56.151,STABLE
ora.asm
1 ONLINE ONLINE cos7-db183-rac1 Started,STABLE
2 ONLINE ONLINE cos7-db183-rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cos7-db183-rac1.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.cos7-db183-rac2.vip
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.cvu
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.mgmtdb
1 ONLINE ONLINE cos7-db183-rac1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.scan1.vip
1 ONLINE ONLINE cos7-db183-rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE cos7-db183-rac1 STABLE
ora.t2orcl.db
1 ONLINE ONLINE cos7-db183-rac1 Open,HOME=/u01/app/o
racle/product/18.3.0
/dbhome_1,STABLE
2 ONLINE ONLINE cos7-db183-rac2 Open,HOME=/u01/app/o
racle/product/18.3.0
/dbhome_1,STABLE
--------------------------------------------------------------------------------
[grid@cos7-db183-rac1 ~]$
[oracle@cos7-db183-rac1 dbhome_1]$ dbca &
[1] 7662
Database Operation
Select Manage Pluggable Databases
Click Next >
Manage Pluggable Databases
Select Create a Pluggable Database
Click Next >
Select Database
Select t2orcl
Click Next >
Create Pluggable Database
Select Create a new Pluggable database from another PDB
Select Pluggable database: PDB$SEED
Click Next >
PDB Identification
Pluggable database name: pdba
Administrator name: adminpdba
Enter and confirm a password
Click Next >
Pluggable Database Options
Select Create default user tablespace
Click Next >
Summary
Review, then click Finish
Progress Page
Creating the database will take a few minutes. The installer will then move to the Finish page
Finish
Click Close
SQL> select banner_full from v$version;
BANNER_FULL
--------------------------------------------------------------------------------
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> select inst_id, host_name from gv$instance order by inst_id;
INST_ID HOST_NAME
---------- ----------------------------------------
1 cos7-db183-rac1.arda.org
2 cos7-db183-rac2.arda.org
SQL>