2 node rac configuration and DG config

-

============================= 19C RAC INSTALATION ==================================
[root@rac02 oracle]# cat /etc/selinux/config
[root@rac02 oracle]# sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
[root@rac02 oracle]# cat /etc/selinux/config
https://docs.google.com/document/d/15GTD9Wogr4fUg0iPnoKY2S89kbQ_h4-9HxPd2EQ1AVw/edit#
Things need to select:
export CV_ASSUME_DISTID=OEL7.6
https://youtu.be/-zynUdIFW6w




rac01 first machine name
rac02 second machine name


1 NAT. Internet purpose
2 HOSTONLY ADAPTER Public network
3.INTERNAL NETWORK Private Nerwork.


8 optios we need to select.


system administrator tools
devolopment tools
compatability libraries
remote management for linux
performance Tolls
KDE
java platform
Hardware monitoring utilitis.


6 mount points ...


/ 30 gb
/home 5 gb
swap 10 gb
/boot 1 gb
biosboot 1gb
/u01 60 gb
/u02 50 gb


hostname: rac01.oracle.com


rac01#] cat /etc/system-release
#systemctl stop firewalld
systemctl disable firewalld
hostname


vi /etc/hostname


vi /etc/hosts


##public


192.168.56.101 rac01.oracle.com rac01
192.168.56.102 rac02.oracle.com rac02


#Private


10.10.10.101 rac01-priv.oracle.com rac01-priv
10.10.10.102 rac02-priv.oracle.com rac02-priv


##vip


192.168.56.103 rac01-vip.oracle.com rac01-vip
192.168.56.104 rac02-vip.oracle.com rac02-vip




#nslookup prod-scan
#dnsmasq
#rpm -qa|grep dnsmasq


vi /etc/racdns


##scan
192.168.56.105 prod-scan.oracle.com prod-scan
192.168.56.106 prod-scan.oracle.com prod-scan
192.168.56.107 prod-scan.oracle.com prod-scan


vi /etc/dnsmasq.conf


/add- search with this.


addn-hosts=/etc/racdns


:wq!


vi /etc/resolv.conf
nameserver 127.0.0.1


##chattr +i /etc/resolv.conf
#systemctl status dnsmasq
#netstat -tulpn identify the process with dnsmasq
kill -9 pid


systemctl stop dnsmasq
systemctl start dnsmasq
systemctl enable dnsmasq




#nslookup prod-scan


#yum search oracle
yum install -y oracle-database 19c pre-req


id oracle


#cat /etc/group | grep -i asm


#
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin


#cat /etc/group | grep -i asm


#usermod -a -G asmdba,asmoper,asmadmin oracle
#id oracle


#yum search oracleasm
yum install -y oracleasm-support.x86-64
yum install -y https://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.12-1.el7.x86_64.rpm


in google...oel7 oracleasm lib copy the link and apply


passwd oracle
oracle


#oracleasm configure -i
oracle
oinstall
yes
yes


#oracleasm configure
#oracleasm init
#poweroff


==========2 nd Node preparation ==========
click on vm->clone->rac02->location->Generate a new MAC address ->full done->clone.


start the machine ..change the hostname


vi /etc/hostname


rac02.oracle.com


go to applications ->network->chnage the ip's and select.




go to settings->network->identify->change the mac address and ip's off..check the internet and on all ...


#systemctl restart systemd-hostnamed
#bash
#hostname
#poweroff


now both the nodes are down ......and create the shared storage ..


click on node2->file->virtual media manager ->create ->fixed size -> next-> create folder -> shareddisk filename rac-asm-disk1 and rac-asm-disk2 and rac-asm-disk3


make it sharable these 2 disk and apply. 50 gb each of disk.




On node1 .go to storage->non attached devices -select and save start the machine.
On node2 go to settings and select the disks.


now on both the machanies....on node1 fdisk -l


fdisk /dev/sdb
n
p
enter
enter
entrt
w


fdisk /dev/sdc
n
p
enter
enter
entrt
w


oracleasm createdisk ASM_DATA_01 /dev/sdb1
oracleasm createdisk ASM_DATA_02 /dev/sdc1




ls -ltr /dev/oracleasm/disks


oracleasm listdisks


node2..it will not appear....


oracleasm listdisks
now we have to do
oracleasm scandisks
oracleasm listdisks




now login as oracle user and extract the software..


mkdir -p /u01/soft
cd /media/software
ls -ltr
cp 19cgrid /u01/soft
cp db_home /u01/soft
chown -R oracle:oinstall /u01
chmod 775 /u01


on node2 also do the same.


chown -R oracle:oinstall /u01
chmod 775 /u01


login as oracle to rac01 server..


rac01
mkdir -p /u01/app/19.3.0/grid
rac02
mkdir -p /u01/app/19.3.0/grid


cd /u01/soft
ls -ltr
unzip 19cgrid -d /u01/app/19.3.0/grid/


To chekc the progress of the mgmtdb.
[oracle@rac01 dbca]$ pwd
/u01/app/oracle/cfgtoollogs/dbca




[oracle@rac01 dbca]$ cd /u01/app/oracle/cfgtoollogs/dbca/_mgmtdb
[oracle@rac01 _mgmtdb]$ ls -ltr
total 19428
-rw-r-----. 1 oracle oinstall 0 Nov 22 23:26 trace.log_2020-11-22_11-25-31PM.lck
-rw-r-----. 1 oracle oinstall 18628608 Nov 22 23:30 tempControl.ctl
-rw-r-----. 1 oracle oinstall 352 Nov 22 23:30 CloneRmanRestore.log
-rw-r-----. 1 oracle oinstall 2864 Nov 22 23:31 init-MGMTDBTemp.ora
-rw-r-----. 1 oracle oinstall 367 Nov 22 23:34 _mgmtdb.log
-rw-r-----. 1 oracle oinstall 2689 Nov 22 23:41 cloneDBCreation.log
-rw-r-----. 1 oracle oinstall 0 Nov 22 23:42 rmanUtil
-rw-r-----. 1 oracle oinstall 337 Nov 22 23:45 plugDatabase.log
-rw-r-----. 1 oracle oinstall 1238246 Nov 22 23:45 trace.log_2020-11-22_11-25-31PM
[oracle@rac01 _mgmtdb]$ tail -f _mgmtdb.log
[ 2020-11-22 23:26:49.663 IST ] Prepare for db operation
DBCA_PROGRESS : 10%
[ 2020-11-22 23:27:15.718 IST ] Registering database with Oracle Grid Infrastructure
DBCA_PROGRESS : 14%
[ 2020-11-22 23:27:26.041 IST ] Copying database files


# bring down the cluster nodes ===


Node1:
crsctl stop cluster -all --only one 1 node
crsctl stop crs shound be run on node 1 and node 2.
init 0


[oracle@rac01 19.3.0]$ cd /u01/app/19.3.0/grid/
[oracle@rac01 grid]$ cd bin
[oracle@rac01 bin]$ ./oifcfg getif
enp0s3 10.0.2.0 global cluster_interconnect
enp0s8 192.168.56.0 global public
enp0s9 10.10.10.0 global cluster_interconnect,asm
[oracle@rac01 bin]$ ls -ld /u01/app/oracle/product/19.3.0/dbhome_1/
drwxr-xr-x. 69 oracle oinstall 4096 Nov 23 01:11 /u01/app/oracle/product/19.3.0/dbhome_1/
[oracle@rac01 bin]$




[root@rac01 ~]# oifcfg delif -global enp0s3/10.0.2.0
oifcfg getif
9503754679


vi /etc/oratab
+ASM1:/u01/app/19.3.0/grid:N


node2 :
+ASM2:/u01/app/19.3.0/grid:N




create the RECO disk group..


+ASM1
asmcma


===========Oracle database installation ================
on node1


cd /u01/soft
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1




on node2:
mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1


login as a oracle user:


unzip Oraclesoftware -d /u01/app/oracle/product/19.3.0/dbhome_1
cd /u01/app/oracle/product/19.3.0/dbhome_1
./runInstaller


setup the software only.
oracle Real Application cluster database installation.


=========oracle rac one node Database creation ==========


vi /etc/orata
ABC:/u01/app/oracle/product/19.3.0/dbhome_1:N
. oraenv
ABC
dbca To create one node database for one node oracle database .


on rac01 add the below entries
orclone_1:/u01/app/oracle/product/19.3.0/dbhome_1:N
orclone_2:/u01/app/oracle/product/19.3.0/dbhome_1:N






on rac02 add the below entries
orclone_1:/u01/app/oracle/product/19.3.0/dbhome_1:N
orclone_2:/u01/app/oracle/product/19.3.0/dbhome_1:N




orclprod1:/u01/app/oracle/product/19.3.0/dbhome_1:N
orclprod2:/u01/app/oracle/product/19.3.0/dbhome_1:N




== To stop the cluster ====


crsctl stop crs
init 0

 

=================RAC INSTALLATION ==============

Disable the firewall 
systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld
cat /etc/selinux/config
sed -i --follow-symlinks 's/SELINUX=enforcing/SELINUX=disabled/g' /etc/selinux/config
cat /etc/selinux/config
Update the /etc/hosts file with IP address 
vi /etc/hosts
#####Public IP
192.168.56.110  12cnode01.oracle.com  12cnode01
192.168.56.111  12cnode02.oracle.com  12cnode02
#########Virtual IP 
192.168.56.114 12cnode01-vip.oracle.com 12cnode01-vip
192.168.56.115 12cnode02-vip.oracle.com 12cnode02-vip
######Private Ip
10.10.10.101   12cnode01-priv.oracle.com 12cnode01-priv
10.10.10.102   12cnode02-priv.oracle.com 12cnode02-priv
As we dont have DNS server  lets maintain the SCAN ip 
vi /etc/proddns
192.168.56.115  prod-scan.oracle.com prod-scan
192.168.56.116  prod-scan.oracle.com prod-scan
192.168.56.117  prod-scan.oracle.com prod-scan
vi /etc/dnsmasq.conf
addn-hosts= /etc/racdns
:wq
vi /etc/resolv.conf
nameserver 127.0.0.1
:wq
chattr +i /etc/resolv.conf
chattr -i /etc/resolv.conf
netstat -tulpn
kill -9
systemctl stop dnsmasq
systemctl start dnsmasq
systemctl restart dnsmasq


[root@12cnode01 ~]# nslookup prod-scan
Server:         127.0.0.1
Address:        127.0.0.1#53
Name:   prod-scan.oracle.com
Address: 192.168.56.116
Name:   prod-scan.oracle.com
Address: 192.168.56.117
Name:   prod-scan.oracle.com
Address: 192.168.56.115

yum search oracle
https://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.12-1.el7.x86_64.rpm
groupadd -g 54327  asmdba
groupadd -g 54328  asmoper
groupadd -g 54329  asmadmin
usermod -aG asmdba,asmoper,asmadmin oracle
id oracle
passwd oracle
yum search oracleasm
in google get link for asmlib for asm
oracleasm init
oracleasm configure -i
oracle    grid
oinstall  asmadmin
y 
yum
oracleasm configure 
mkdir -p /u01/soft
chown -R oracle:oinstall /u01/soft
chmod -R 775 /u01/soft
init 0 /shutdown /poweroff
clone the node as  node02
==============================

Now start the node02 node on node01
change the hostname and ip address
nmtui
bash
hostname
poweroff
configure the shaed storage
==============================
ASM_server19C_DATA_01  DATA 50 GB
ASM_server19C_FRA_01   FRA 50 GB
ASM_server19C_MGMTDB_01  MGMTDB 50 GB
ASM_server19C_OCRVD_01   10 GB
FIXED and sharable disks
add these disks to the node02 then add to the node01
start the both the nodes 
lsblk
fdisk -l
n
p
enter->enter->enter->w

oracleasm createdisk ASM_server19C_DATA_01  /dev/sdb1
oracleasm createdisk ASM_server19C_FRA_01  /dev/sdc1
oracleasm createdisk ASM_server19C_MGMTDB_01  /dev/sdb1
oracleasm createdisk ASM_server19C_OCRVD_01  /dev/sdb1
on node02 
==================
oracleasm scandisks
do not use
public
asm & private
do  not use
systemctl status avahi-daemon
systemctl stop avahi-daemon
systemctl disable avahi-daemon

cluvfy stage -pre crsinst -n node1,node2 -verbose

stage -post hwos -n server01,server02,server03 -verbose








Comments

Post a Comment

Popular posts from this blog

MY NOTEPAD

-
set lines 200 pages 200; col END_TIME for a20; col ELAPSED_TIME for a25; col START_TIME for a20 SELECT T.SESSION_KEY, T.INPUT_TYPE, T.STATUS, T.SUM_BACKUP_PIECES_IN_GB, T.START_TIME, T.END_TIME, T.SECONDS ELAPSED_TIME FROM ( SELECT SESSION_KEY, INPUT_TYPE, STATUS, OUTPUT_BYTES/1024/1024/1024 SUM_BACKUP_PIECES_IN_GB, TO_CHAR (START_TIME, 'dd/mm/yyyy hh24:mi') START_TIME, TO_CHAR (END_TIME, 'dd/mm/yyyy hh24:mi') END_TIME, TIME_TAKEN_DISPLAY SECONDS FROM V$RMAN_BACKUP_JOB_DETAILS WHERE INPUT_TYPE='ARCHIVELOG' ORDER BY SESSION_KEY DESC) T WHERE ROWNUM <= 1; ================ ASM disk group free space ============== set sqlblanklines on set lines 180 set pages 999le col "Group Name" form a25 col "Disk Name" form a30 col "State" form a15 ...
Read more

Oracle OEM Holistic Patch

-
  Oracle OEM Holistic Patch  The Concept Starting with Oracle Enterprise Manager (OEM) 13.5 RU24 (October 2024), Oracle introduced the Holistic Patch for OEM — a unified patching model that consolidates several separate updates into a single coordinated package. Previously, administrators had to patch: * The OMS and Agents with the quarterly Release Update (RU). * OEM Application via the System Patch Bundle (SPB). * WebLogic CPU and JDK manually. There was an element of complication because of the need to keep the solution homogeneous. With the Holistic Patch, the last two steps are merged into a single patch bundle. Now we have a new Holistic patch for OEM that is released with each new OMS Release Update. Prerequisites Apply RU 24 Patch  PATCH 36761595  /later on all OMSes before applying Oct Holistic Patch   PATCH 37305292             (OR) Apply RU 25 Patch  PATCH 37057635  /later on all OMSes before applying ...
Read more

Upgrade Oracle 19c DB to 21c using Auto Upgrade utility inprogress

-
Image
  Upgrade Oracle 11g to 21c using AutoUpgrade utility: How do I upgrade Oracle database to 21c?  install the 21c oracle binaries into the server . Oracle Virtual Bix  Oracle Linux 7 Oracle Database 19c currently running Upgrading 19c database to 21c directly Oracle Database 19c on premises is available – and one of the key features is the new Auto Upgrade utility. In the following days I will publish several blog posts explaining and showcasing the new Auto Upgrade. What is the Auto Upgrade? The Oracle Database Auto Upgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. The new Auto Upgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong – and then upgrade your databases. And of course, do the post upgrade, recompilation and time zone adjustment. The...
Read more