Monday 19 August 2019

changing scan and VIP in Rac


I have provided the below steps ,scan and vip address change, IP address for scan should be configured in DNS is round robin fashion and should be added in /etc/hosts.
VIP address should be added in /etc/hosts , needs to be assigned in DNS entry.



Changing Virtual IP / Virtual Host Name

-- CHANGING NODE VIP FROM 192.168.2.220 TO 192.168.2.330 ON ravs1
-- SINCE NODE VIP IS PART OF NODE APPS ONE NEEDS TO MODIFY THE IP ADDRESS ON OS LEVEL AND THEN USE SRVCTL TO MODIFY NODEAPPS

[oracle@ravs1 automation]$ srvctl  config vip -node ravs1
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.220
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[oracle@ravs1 automation]$ srvctl  stop vip -node ravs1
PRCR-1065 : Failed to stop resource ora.ravs1.vip
CRS-2529: Unable to act on 'ora.ravs1.vip' because that would require stopping or relocating 'ora.LISTENER.lsnr', but the force option was not specified

[oracle@ravs1 automation]$ srvctl  stop vip -node ravs1 -force
[oracle@ravs1 automation]$ srvctl  status  vip -node ravs1
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is not running

-- NOW MODIFY THE ADDRESS OF NODE VIP ON OS LEVEL USING EITHER /etc/hosts OR DNS.
-- Once done, use SRVCTL to modify OCR resource.
-- Here I am not changing the name, but only IP

[oracle@ravs1 automation]$ srvctl modify nodeapps -node ravs1 -address ravs1-vip.localdomain/255.255.255.0/eth1
[oracle@ravs1 automation]$ srvctl config   vip -node ravs1
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.330
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[root@ravs2 ~]# srvctl  config nodeapps
Network 1 exists
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
Ping Targets:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
VIP exists: network number 1, hosting node ravs1
VIP Name: ravs1-vip.localdomain
VIP IPv4 Address: 192.168.2.330
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
VIP exists: network number 1, hosting node ravs2
VIP Name: ravs2-vip.localdomain
VIP IPv4 Address: 192.168.2.104
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:
ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL false
ONS is enabled
ONS is individually enabled on nodes:
ONS is individually disabled on nodes:

[oracle@ravs1 automation]$ srvctl  start vip -node ravs1
[root@ravs2 ~]# srvctl  status  nodeapps
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is running on node: ravs1
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is running on node: ravs2
Network is enabled
Network is running on node: ravs1
Network is running on node: ravs2
ONS is enabled
ONS daemon is running on node: ravs1
ONS daemon is running on node: ravs2

-- ON NODE2

[oracle@ravs2 ~]$ srvctl  stop vip -node ravs2 -force
[oracle@ravs2 ~]$ srvctl  status  vip -node ravs2
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is not running

[oracle@ravs2 ~]$ srvctl modify nodeapps -node ravs2 -address ravs2-vip.localdomain/255.255.255.0/eth1

[oracle@ravs2 ~]$ srvctl  config vip  -n ravs2
VIP exists: network number 1, hosting node ravs2
VIP Name: ravs2-vip.localdomain
VIP IPv4 Address: 192.168.2.204
VIP IPv6 Address:
VIP is enabled.
VIP is individually enabled on nodes:
VIP is individually disabled on nodes:

[oracle@ravs2 ~]$ srvctl  start vip -node ravs2

[oracle@ravs2]$ srvctl status  nodeapps
VIP ravs1-vip.localdomain is enabled
VIP ravs1-vip.localdomain is running on node: ravs1
VIP ravs2-vip.localdomain is enabled
VIP ravs2-vip.localdomain is running on node: ravs2
Network is enabled
Network is running on node: ravs1
Network is running on node: ravs2
ONS is enabled
ONS daemon is running on node: ravs1
ONS daemon is running on node: ravs2

[oracle@ravs1 automation]$ crs_stat -t  | grep vip

ora.ravs1.vip ora....t1.type ONLINE    ONLINE    ravs1     
ora.ravs2.vip ora....t1.type ONLINE    ONLINE    ravs2     
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    ravs1


changing of scanip
______________________
**************************************************************************************

So to change to SCAN IP / Name one has to first populate the changes on DNS to take it into effect. Once the changes are in effect, one can modify the SCAN resource in OCR as follows. Remember SCAN acts as cluster entry point and load balancing process , the restart to SCAN will require a brief outage


[oracle@ravs2 ~]$ srvctl  status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node ravs1
[oracle@ravs2 ~]$ srvctl  status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node ravs1

[oracle@ravs2 ~]$ srvctl config  scan
SCAN name: ravs-scan.localdomain, Network: 1
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.2.110
SCAN VIP is enabled.
SCAN VIP is individually enabled on nodes:
SCAN VIP is individually disabled on nodes:

[oracle@ravs2 ~]$ srvctl stop scan_listener
[oracle@ravs2 ~]$ srvctl stop scan
[oracle@ravs2 ~]$ srvctl  status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
[oracle@ravs2 ~]$ srvctl  status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running

-- MODIFY THE SCAN IP AT OS LEVEL

[root@ravs2 ~]$ srvctl  modify scan -scanname ravs-scan.localdomain

[oracle@ravs2 ~]$ srvctl  config scan
SCAN name: ravs-scan.localdomain, Network: 1
Subnet IPv4: 192.168.2.0/255.255.255.0/eth1, static
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.2.120
SCAN VIP is enabled.

[oracle@ravs2 ~]$ srvctl start scan_listener
[oracle@ravs2 ~]$ srvctl start scan

Featured post

Postgres commads

 [oracle@Tesdb ~]$ systemctl status postgresql-15 ● postgresql-15.service - PostgreSQL 15 database server    Loaded: loaded (/usr/lib/system...