pacemaker搭建oracle ha

ssh-keygen
ssh-copy-id -i root/.ssh/id_rsa root@oracledb2


ssh-keygen
ssh-copy-id -i root/.ssh/id_rsa root@oracledb1

# vi etc/hosts
127.0.0.1       localhost


### public ip/vip for orcl
192.168.2.160   oracledb1
192.168.2.161   oracledb2
192.168.2.162   clust-orcl-vip


### cluster heartbeat ip
10.10.10.1      oracledb1-hb
10.10.10.2      oracledb2-hb

[redhat7.8]
name = redhat 7.8
baseurl=file:///mnt
gpgcheck=0
enabled=1


[HighAvailability]
name=HighAvailability
baseurl=file:///mnt/addons/HighAvailability
gpgcheck=0
enabled=1


[ResilientStorage]
name=ResilientStorage
baseurl=file:///mnt/addons/ResilientStorage
gpgcheck=0
enabled=1

yum install pcs pacemaker corosync -y

systemctl stop firewalld.service
systemctl disable firewalld.service
sed -i 's/SELINUX=enforcing/SELINUX=disabled/g' etc/selinux/config
setenforce 0

yum install -y chrony
systemctl enable chronyd
systemctl start chronyd
systemctl status chronyd
添加时间同步服务器
vi /etc/chrony.conf
server x.x.x.x iburst
重启chronyd服务
systemctl restart chronyd.service
检查同步是否正常
chronyc sources -v

fdisk分区时把分区类型改成lvm
pvcreate /dev/sdb1
vgcreate oradata1_vg dev/sdb1
lvcreate -l 100%VG -n oradata1_lv oradata1_vg
mkfs.xfs /dev/oradata1_vg/oradata1_lv
mkdir /oradata1
chown -R oracle:oinstall oradata1
chmod -R 775 oradata1
mount /dev/oradata1_vg/oradata1_lv /oradata1

echo "redhat"|passwd --stdin hacluster


systemctl start pcsd.service
systemctl enable pcsd.service
systemctl status pcsd.service

pcs cluster auth oracledb1 oracledb2 -u hacluster -p redhat

pcs cluster setup --name dbcluster oracledb1-hb oracledb2-hb
pcs cluster start --all
pcs cluster enable --all
pcs cluster status
pcs status

pcs property set stonith-enabled=false

lvmconf --enable-halvm --services --startstopservices
cp /etc/lvm/lvm.conf /etc/lvm/lvm.conf.bak
vi /etc/lvm/lvm.conf
volume_list = ["rhel"]
dracut -H -f /boot/initramfs-$(uname -r).img $(uname -r)
reboot

pcs resource create ClusterIP1 IPaddr2 ip=192.168.2.162 cidr_netmask=24 nic=ens33 op monitor interval=30s
pcs resource create orcl_lvm  LVM volgrpname=oradata1_vg exclusive=yes  op monitor interval=10s
pcs resource create orcl_fs Filesystem device='/dev/oradata1_vg/oradata1_lv' directory=/oradata1 fstype=xfs op monitor interval=10s
pcs resource create orcllsnr oralsnr sid=orcl home=/u01/app/oracle/product/11.2.0/db_1 user=oracle listener=LISTENER_ORCL  op monitor interval=10s
pcs resource create orcl oracle sid=orcl home=/u01/app/oracle/product/11.2.0/db_1 user=oracle clear_backupmode=1 shutdown_method=immediate  op monitor interval=10s
pcs resource group add orclgroup ClusterIP1 orcl_lvm orcl_fs orcllsnr orcl

pcs resource defaults resource-stickiness=500

pcs resource op defaults timeout=10s

pcs property set no-quorum-policy=ignore

pcs resource defaults migration-threshold=1

# 定义资源依赖
pcs constraint colocation add orcl_lvm with ClusterIP1
pcs constraint colocation add orcl_fs with orcl_lvm
pcs constraint colocation add orcllsnr with orcl_fs
pcs constraint colocation add orcl with orcllsnr


# 定义资源启动顺序
pcs constraint order start ClusterIP1 then orcl_lvm
pcs constraint order start orcl_lvm then start orcl_fs
pcs constraint order start orcl_fs then start orcllsnr
pcs constraint order start orcllsnr then start orcl


# 定义资源粘性
pcs constraint location ClusterIP1 prefers oracledb1-hb=200
pcs constraint location ClusterIP1 prefers oracledb2-hb=50
pcs constraint location orcl_lvm prefers oracledb1-hb=200
pcs constraint location orcl_lvm prefers oracledb2-hb=50
pcs constraint location orcl_fs prefers oracledb1-hb=200
pcs constraint location orcl_fs prefers oracledb2-hb=50
pcs constraint location orcllsnr prefers oracledb1-hb=200
pcs constraint location orcllsnr prefers oracledb2-hb=50
pcs constraint location orcl prefers oracledb1-hb=200
pcs constraint location orcl prefers oracledb2-hb=50


pcs constraint show --full

crm_mon

pcs resource debug-start resource