Linux

How to Build 18c RAC – 1 of 4 – Preparing Two Database Servers

Posted on
Network Design for RAC Let’s see the network design of our cluster database. [root@primary01 ~]# vi /etc/hosts # Public 192.168.10.11 primary01 primary01.example.com 192.168.10.12 primary02 primary02.example.com # Private 192.168.24.11 primary01-priv primary01-priv.example.com 192.168.24.12 primary02-priv primary02-priv.example.com # VIP 192.168.10.111 primary01-vip primary01-vip.example.com 192.168.10.112 primary02-vip primary02-vip.example.com # SCAN # 192.168.10.81 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.82 primary-cluster-scan primary-cluster-scan.example.com # 192.168.10.83 primary-cluster-scan primary-cluster-scan.example.com […]
Listener

How to Add a Cluster Listener on Second Network to Grid

Posted on
I assume that you have added the second network to the grid infrastructure. Let’s continue our work. Make sure the second network is available in the grid infrastructure. [grid@primary01 admin]$ srvctl config network -k 2 Network 2 exists Subnet IPv4: 10.0.8.0/255.255.255.0/eth2, static Subnet IPv6: Ping Targets: Network is enabled Network is individually enabled on nodes: […]
Network

How to Add a Subnet to Grid

Posted on
Servers that have multiple network interfaces may offload the traffic by adding another subnet to grid infra. In this post, I demonstrate how I add another subnet (i.e. 10.0.8/24) from OS to grid infrastructure.Please note that, network resource object is a synonym of subnet from grid infrastructure’s perspective.First of all, we need to configure the […]
SCAN IP

How to Relocating SCAN VIP and Listeners

Posted on
Sometimes, we may find the scan vip and listeners are all located at one node.[grid@primary01 ~]$ ps -ef | grep lsnrgrid      6077     1  0 14:27 ?        00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inheritgrid      6256     1  0 14:27 ?        00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inheritgrid […]
SCAN IP

How to Add a SCAN VIP to Grid

Posted on
Looking up SCAN name on DNS before adding a SCAN VIP[root@primary01 ~]# nslookup primary-cluster-scanServer:         10.0.0.199Address:        10.0.0.199#53Name:   primary-cluster-scan.example.comAddress: 10.0.0.82Name:   primary-cluster-scan.example.comAddress: 10.0.0.81Name:   primary-cluster-scan.example.comAddress: 10.0.0.83There’re 3 SCAN VIPs for this name.Adding a SCAN VIP to DNS[root@dns ~]# cd /var/named/[root@dns named]# vi example.com.zone[root@dns named]# vi 0.10.zone[root@dns named]# systemctl restart […]
SCAN IP

Why Don’t We Explicitly Bind VIP and SCAN into NIC

Posted on
It’s because Oracle clusterware will bind them automatically and dynamically. I think we should try to figure out the interface configurations.First, let’s see what interfaces we have now.[root@primary01 ~]$ ll /etc/sysconfig/network-scripts/ifcfg-*-rw-r–r–  1 root root 314 May 30  2016 /etc/sysconfig/network-scripts/ifcfg-eth0-rw-r–r–  1 root root 311 May 30  2016 /etc/sysconfig/network-scripts/ifcfg-eth1-rw-r–r–. 1 root root 254 Jul 22  2014 /etc/sysconfig/network-scripts/ifcfg-loBut […]
Network

How to Change Subnet of Grid

Posted on
Oracle 12c uses 4 types of IP addresses to configure network of RAC:Public IPPrivate IPVirtual IPSCAN IPIn which, Public IP, Virtual IP and SCAN IP are in the same subnet. Up to 4 pairs of Private IP can be set in RAC, which should be in another subnet and used for interconnect redundancy to secure […]