Hi All,
In this post i am going to show you Oracle 19C database 2 node RAC installation .
after OEM 7.* install , do the follow steps :
1. update the yum repository and then update the pre-requisites for oracle 19C database and ASM.
yum update -y
yum install -y oracle-database-preinstall-19c
yum install -y oracleasm-support
yum install -y bind
yum install -y clu*
Now , configure VMbox tools ..
- devices .. > insert Guest Additional CD Image....
enable the screen resolution and font size .. etc ..
after that restart the Linux Machine.
init 6
Update the below configuration :
cat /etc/sysctl.conf
cat /etc/selinux/config
SELINUX=disabled
Ping should be work also add the host file names in /etc/hosts
groups creation :
groupadd -g 5001 oinstall
groupadd -g 5002 dba
groupadd -g 5003 oper
groupadd -g 5004 asmadmin
groupadd -g 5005 asmdba
groupadd -g 5006 asmoper
user creation :
useradd -u 5007 -g oinstall -G dba,oper,asmdba oracle
useradd -u 5008 -g oinstall -G asmadmin,asmdba,asmoper,dba grid
In this screen some of the groups and oracle user already exist so we are seeing that error as well. those are created automatically at the time of 19C database pre-requisites rpm installation .
[root@racs1 ~]# id grid
uid=5008(grid) gid=54321(oinstall) groups=54321(oinstall),54322(dba),5004(asmadmin),5005(asmdba),5006(asmoper)
[root@racs1 ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@racs1 ~]#
Change the password for oracle and grid users
passwd oracle
passwd grid
Create the directories in which the Grid and Oracle database software will be installed.
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/19.0.0/db_home
mkdir -p /u02/app/grid_base
mkdir -p /u02/app/19.0.0/grid_home
mkdir -p /u02/app/oraInventory
chown -Rf grid:oinstall /u02
chown -Rf oracle:oinstall /u01
chmod -Rf 775 /u01
chmod -Rf 775 /u02
Configure Bash Profile of Grid and Oracle Users.
create .bash_profiles for grid
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/u02/app/grid_bas
export ORACLE_HOME=/u02/app/19.0.0/grid_home
export ORACLE_SID=+ASM1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
:wq!
. .bash_profiles
Stop and Disable Firewall - in real time we will re-open the firewall post installation's
====================
systemctl stop firewalld.service
systemctl disable firewalld.service
==========================================
Start DNS configuration :::
====================================
we have installed the bind packages , cross check
Then Edit the Configuration of name server
take the backup of original one .. then update the red marked values as per your IP.
cp /etc/named.conf /etc/named.conf_bkp
vi /etc/named.conf_bkp
options {
listen-on port 53 { 127.0.0.1; 192.168.56.71; };
listen-on-v6 port 53 { ::1; };
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
memstatistics-file "/var/named/data/named_mem_stats.txt";
recursing-file "/var/named/data/named.recursing";
secroots-file "/var/named/data/named.secroots";
allow-query { localhost; 192.168.56.0/24; };
zone "localdomain.com" IN {
type master;
file "localdomain.zone";
allow-update { none; };
};
zone "56.168.192.in-addr.arpa." IN {
type master;
file "56.168.192.in-addr.arpa";
allow-update { none; };
};
Create the Forward and Reserve Zone files as mentioned in named.conf
FORWARD ZONE :
create a forward zone :
cp /var/named/named.localhost /var/named/localdomain.zone
vi /var/named/localdomain.zone
$TTL 86400
@ IN SOA racs1.localdomain.com. root.localdomain.com. (
2014051001 ; serial
3600 ; refresh
1800 ; retry
604800 ; expire
86400 ; minimum
)
@ IN NS racs1.localdomain.
localhost IN A 127.0.0.1
racs1 IN A 192.168.56.71
racs2 IN A 192.168.56.72
racs1-priv IN A 192.168.10.1
racs2-priv IN A 192.168.10.2
racs1-vip IN A 192.168.56.81
racs2-vip IN A 192.168.56.82
racs-scan IN A 192.168.56.91
racs-scan IN A 192.168.56.92
Create a reserve zone :
cp /var/named/named.loopback /var/named/56.168.192.in-addr.arpa
vi /var/named/56.168.192.in-addr.arpa
$TTL 86400
@ IN SOA racs1.localdomain.com. root.localdomain.com. (
2
3H
1H
1W
1H )
@ IN NS racs1.localdomain.com.
@ IN PTR localdomain.com.
racs1 IN A 192.168.56.71
racs-scan IN A 192.168.56.91
racs-scan IN A 192.168.56.92
racs-scan IN A 192.168.56.93
71 IN PTR racs1.localdomain.com.
91 IN PTR racs-scan.localdomain.
92 IN PTR racs-scan.localdomain.
93 IN PTR racs-scan.localdomain.
note : restorecon /etc/named.conf if any changes in the named.conf do this
check the DNS status and start :
systemctl status named.service
systemctl start named.service
Change the Group to named from root :
iptables -A INPUT -i lo -j ACCEPT
add resolv.conf
# Generated by NetworkManager
search localdomain.com.
nameserver 192.168.56.71
nameserver 192.168.56.72
options timeout:1
options attempts:5
nslookup racs1 public ..
nslookup racs-scan .
shut down the Node1 RACS ... then prepare the Node2
Taking the backup of my Node1 ... to build the node2 ..
Click on the File ...> Export Appliance ....
select the Machin and click next
Click on Finish
wait for some time that will take some time 10 to 15 mins .. depends on system speed.
ASM DISK Group Setup :
after taking the backup of your node1 , create disks for ASM Storage ..
Node1 : Racs1
Click on General > Storage > Click on hard disk as mentioned in the snap..
click on Create and select VDI then click on next
Click on next .. keep all values default
select the path , i have created 2 folders for racs1 and racs2 .. for Storage i have created in the Dir... give 25G and create OCR disk group
create second and 3rd groups .. DATA and ARCH
choose those 3 disk to storage SATA :
Now we will prepare the Node2 : from the node1 backup.
Click on the File and Import Appliance ..
Restore the node1 backup which we taken before :
Click on Next ..
Change the name and path for the Node2 hostname : racs2 , path also select where we installed node1 . there we have created one more dir name with : racs2
We can now able to see the node2 machine : racs2
Now we can create the shared disk and we will add those shared disks with node2 storage :
select file from the VM .. > tools ..> select Virtual media manager ..>
Select the disks one by one and type : sharable and click apply .. repeat the same for all 3 disks : DATA , OCR and ARCH
you will get release popup click on release
select node2 and add those disk to that node :
General >>>> Storage >>> Hard disk >>> select the DATA and OCR Disks ..
add to node2 :
start the node2 and change the hostname and network interfaces ... IP'/s
Change Hostname : from racs1 to racs2
nmcli general hostname
nmcli general hostname racs2.localdomain
nmcli general hostname
service systemd-hostnamed restart
Change Network
Select Applications and settings
then update IP's for node2 :
after the run this
systemctl restart network
init 6 .. restart the node2 and node1 .
post restart re-check the nslookup working or not
systemctl start named.service
Node1 :
unzip the oracle 19c grid and oracle software from the shared folder Only One NODE1 ...
cd /media/sf_VM_Softwares/19C_DB_Linux_7.8-SW/19C-Grid_sw
Grid Software :
unzip V982068-01.zip -d /u02/app/19.0.0/grid_home/
Oracle Software Unzip :
[root@racs1 19C_Database]# pwd
/media/sf_VM_Softwares/19C_DB_Linux_7.8-SW/19C_Database
[root@racs1 19C_Database]# ls
V982063-01.zip
[root@racs1 19C_Database]# unzip V982063-01.zip -d /u01/app/oracle/product/19.0.0/db_home/
Install the package cvudisk from the grid home as the “root” user on all nodes.
[root@racs1 19C_Database]# cd /u02/app/19.0.0/grid_home/cv/rpm/
[root@racs1 rpm]# ls
cvuqdisk-1.0.10-1.rpm
[root@racs1 rpm]# pwd
/u02/app/19.0.0/grid_home/cv/rpm
[root@racs1 rpm]# rpm -Uvh cvuqdisk*
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
[root@racs1 rpm]#
Configure Oracle ASM :
all done fdisk /dev/sdf
all partitions are done ..
Configure oracleasm utility.
Initialize the asmlib with the oracleasm init command to load oracleasm module and mount the oracleasm filesystem:-
NODE 2 :
Password less connection :
Oracle user :
Pre-check for RAC Setup
Pre-check for CRS installation using Cluvfy
We use this Cluvfy command to check that our cluster is ready for the Grid install.
[grid@racs1 grid]$ ./runcluvfy.sh stage -pre crsinst -n racs1,racs2 -verbose
Display Config and Start Grid Installation
su –
export DISPLAY=:0.0
xhost +
su – grid
[grid@racs1~]$ DISPLAY=racs1.localdomain:0.0;
export DISPLAY
[root@racs1 ~]# su - grid
Last login: Sat Aug 12 00:35:11 IST 2023 on pts/1
[grid@racs1 ~]$ cd $ORACLE_HOME
[grid@racs1 grid_home]$ pwd
/u02/app/19.0.0/grid_home
[grid@racs1 grid_home]$ ./gridSetup.sh
Accept the Configure an Oracle Standalone Cluster option by clicking the Next button.
Enter the cluster name racs-cluster, SCAN name racs-scan and SCAN port 1521, then click the Next button.
On the “Cluster Node Information” screen, click the Add button.
Enter the details of the second node in the cluster, then click the OK button.
Click the SSH connectivity button and enter the password for the oracle user. Click the Setup button to configure SSH connectivity, and the Test button to test it once it is complete. Once the test is complete, click the Next button.
Check the public and private networks are specified correctly as ASM & Private. Click the Next button.
Accept the Use Oracle Flex ASM for Storage option by clicking the Next button.
First Browse the path /dev/oracleasm/disks* using change discovery path
Set the redundancy to External, click the 12GB DISK for OCR configuration, then click the Next button.
Enter the credentials and click the Next button.
Accept the default IPMI option by clicking the Next button.
un-select EM. Click the Next button. Default value
Set the groups to oinstall and click the Next button. Accept the warnings on the subsequent dialog by clicking the Yes button.
Click the Next button.
Accept the default inventory directory by click the Next button
Default : we will provide run the root.sh manually
pre-requisite checks : check and fixup
[root@racs1 grid]# /tmp/GridSetupActions2023-08-12_00-37-28AM/CVU_19.0.0.0.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@racs1 grid]#
[root@racs2 ~]# /tmp/GridSetupActions2023-08-12_00-37-28AM/CVU_19.0.0.0.0_grid/runfixup.sh
All Fix-up operations were completed successfully.
[root@racs2 ~]#
Check the Ignore All checkbox and click the Next button.
Double check and click the Install button.
When prompted, run the configuration scripts on each node one by one
Node1 :
[root@racs1 grid]# /u02/app/oraInventory/orainstRoot.sh
Changing permissions of /u02/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u02/app/oraInventory to oinstall.
The execution of the script is complete.
[root@racs1 grid]#
Click on Close .
Without any errors Oracle 19C Grid installation completed successfully
Click on Close .
Install and Configure Oracle 19c Software binary
Select the setup software only option, then click the Next button.
Prerequisite Checks :
Creating ASM Diskgroup using ASMCA Tool for database creation
[grid@racs1 ~]$ ps -ef |grep pmon
grid 1273 1065 0 01:21 pts/2 00:00:00 grep --color=auto pmon
grid 6417 1 0 01:11 ? 00:00:00 asm_pmon_+ASM1
[grid@racs1 ~]$
[root@racs2 ~]# ps -ef |grep smon
root 11690 11595 0 01:22 pts/1 00:00:00 grep --color=auto smon
root 21130 1 1 01:14 ? 00:00:05 /u02/app/19.0.0/grid_home/bin/osysmond.bin
grid 22768 1 0 01:15 ? 00:00:00 asm_smon_+ASM2
[root@racs2 ~]#
asmca
Select Disk Groups and create
Set the redundancy to External, click the 25GB DISK for Database configuration, then click the ok button. DATA disk Group
all are mounted by default :
Start Oracle 19C Database Creation :
Click on Close
Post-Checks : RAC Setup
Check the Status of the RAC
Node2 : ASM Instances and database status
DB node :
select INST_NUMBER,INST_NAME FROM v$active_instances;
SELECT instance_name, host_name FROM gv$instance;
[oracle@racs1 db_home]$ pwd
/u01/app/oracle/product/19.0.0/db_home
[oracle@racs1 db_home]$ dbca
[oracle@racs1 db_home]$ srvctl config database -d racsdb
Database unique name: racsdb
Database name: racsdb
Oracle home: /u01/app/oracle/product/19.0.0/db_home
Oracle user: oracle
Spfile: +DATA/RACSDB/PARAMETERFILE/spfile.268.1144635311
Password file: +DATA/RACSDB/PASSWORD/pwdracsdb.256.1144634977
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: racsdb1,racsdb2
Configured nodes: racs1,racs2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@racs1 db_home]$
