RAC installation on OEL 9.2 and

-

RAC installation on OEL 7.9 


Dissable 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

Add the below entries into the /etc/hosts file 

vi /etc/hosts

Public Ip
192.168.56.120  19crac01.oracle.com  19crac01
192.168.56.121  19crac02.oracle.com  19crac02

10.10.10.101   19crac0-priv.oracle.com 19crac01-priv
10.10.10.102   19crac02-priv.oracle.com 19crac02-priv

192.168.56.123  19crac01-vip.oracle.com 19crac01-vip
192.168.56.124  19crac02-vip.oracle.com 19crac02-vip

Add the scan ip entries into the dns

vi /etc/racdns


192.168.56.127  prod-scan.oracle.com rac-scan
192.168.56.128  prod-scan.oracle.com rac-scan
192.168.56.129  prod-scan.oracle.com rac-scan

vi /etc/dnsmasq.conf

addn-hosts= /etc/racdns

:wq

vi /etc/resolv.conf
nameserver 127.0.0.1


chattr +i /etc/resolv.conf
chattr -i /etc/resolv.conf

netstat -tulpn


kill -9

systemctl restart dnsmasq

nslookup rac-scan


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

sermod -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




















































yum install -y oracleasm

rpm -qa | grep -i oracleasm

yum install -y oracleasm-support

yum install oracleasmlib

wget https://download.oracle.com/otn_software/asmlib/oracleasmlib-2.0.17-1.el8.x86_64.rpm

wget https://public-yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/getPackage/oracleasm-support-2.1.12-1.el8.x86_64.rpm

ls -ltr *.rpm
yum localinstall ./oracleasm-support-2.1.12-1.el8.x86_64.rpm ./oracleasmlib-2.0.17-1.el8.x86_64.rpm


============= 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
















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