Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The IP change procedure in a database that works as a RAC and is then downloaded to a single node due to the necessity of moving the server to a different VLAN is as follows.
Since the database runs on a single node, changes are required in SCAN_IP, VIP on the running node, and Public IP on the running node. For this reason, 3 IPs for Scan, 1 IP for VIP and 1 IP for Public IP were requested from the Network team.
OLD IPs
NEW IPs
172.18.95.12-13-14-15-16 /24 vlan : 2095 gw: .254
This is how we planned the configuration.
Public IP: 172.18.95.12
Virtual IP: 172.18.95.13
Scan IP: 172.18.95.14-15-16
We query the current configuration information.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | [oracle@sbadb01 ~]$ srvctl config scan SCAN name: sbadb-scan, Network: 1 Subnet IPv4: 172.18.197.0/255.255.255.0/bond1, static Subnet IPv6: SCAN 1 IPv4 VIP: 172.18.197.60 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 2 IPv4 VIP: 172.18.197.58 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 3 IPv4 VIP: 172.18.197.59 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: [oracle@sbadb01 ~]$ srvctl config nodeapps Network 1 exists Subnet IPv4: 172.18.197.0/255.255.255.0/bond1, static Subnet IPv6: Ping Targets: Network is enabled Network is individually enabled on nodes: Network is individually disabled on nodes: ONS exists: Local port 6100, remote port 6200, EM port 2016, Uses SSL true ONS is enabled ONS is individually enabled on nodes: ONS is individually disabled on nodes: PRKC-1168 : The supplied IP address "sbadb01-vip" is invalid or specifies an unknown host name [oracle@sbadb01 ~]$ oifcfg getif bond1 172.18.197.0 global public p5p1 192.168.100.0 global cluster_interconnect,asm p5p2 192.168.100.0 global cluster_interconnect,asm |
IP CHANGE PROCESS STARTS.
We are stopping cluster services.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 | [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl stop crs -f CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'sbadb01' CRS-2673: Attempting to stop 'ora.crsd' on 'sbadb01' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'sbadb01' CRS-2673: Attempting to stop 'ora.mhrsdg.db' on 'sbadb01' CRS-2673: Attempting to stop 'ora.qosmserver' on 'sbadb01' CRS-2673: Attempting to stop 'ora.chad' on 'sbadb01' CRS-2677: Stop of 'ora.qosmserver' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.chad' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.mgmtdb' on 'sbadb01' CRS-2677: Stop of 'ora.mgmtdb' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'sbadb01' CRS-2677: Stop of 'ora.MGMTLSNR' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.mhrsdg.db' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.RECO.dg' on 'sbadb01' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.cvu' on 'sbadb01' CRS-2677: Stop of 'ora.DATA.dg' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.RECO.dg' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'sbadb01' CRS-2677: Stop of 'ora.cvu' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'sbadb01' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.sbadb01.vip' on 'sbadb01' CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'sbadb01' CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan3.vip' on 'sbadb01' CRS-2677: Stop of 'ora.asm' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'sbadb01' CRS-2677: Stop of 'ora.scan1.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.scan3.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.sbadb01.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.scan2.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'sbadb01' CRS-2677: Stop of 'ora.ons' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'sbadb01' CRS-2677: Stop of 'ora.net1.network' on 'sbadb01' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'sbadb01' has completed CRS-2677: Stop of 'ora.crsd' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'sbadb01' CRS-2673: Attempting to stop 'ora.crf' on 'sbadb01' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'sbadb01' CRS-2673: Attempting to stop 'ora.gpnpd' on 'sbadb01' CRS-2673: Attempting to stop 'ora.mdnsd' on 'sbadb01' CRS-2677: Stop of 'ora.drivers.acfs' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.crf' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.asm' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'sbadb01' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'sbadb01' CRS-2673: Attempting to stop 'ora.evmd' on 'sbadb01' CRS-2677: Stop of 'ora.evmd' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.ctssd' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'sbadb01' CRS-2677: Stop of 'ora.cssd' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'sbadb01' CRS-2677: Stop of 'ora.gipcd' on 'sbadb01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'sbadb01' has completed CRS-4133: Oracle High Availability Services has been stopped. |
• Public IP change is made. [Public IP was in bond1 in ifconfig]
OLD VALUES
1 2 3 4 5 6 7 8 9 10 11 12 | [root@sbadb01 ~]# cd /etc/sysconfig/network-scripts/ [root@sbadb01 network-scripts]# vi ifcfg-bond1 DEVICE="bond1" IPADDR=172.18.197.61 NETMASK=255.255.255.0 NETWORK=172.18.197.0 GATEWAY=172.18.197.254 BROADCAST=172.18.197.255 ONBOOT=YES BOOTPROTO=NONE USERCTL=NO BONDING_OPTS="mode=0 miimon=100 downdelay=2000 updelay=5000 num_grat_arp=100" |
NEW VALUES
1 2 3 4 5 6 7 8 9 10 11 12 | [root@sbadb01 ~]# cd /etc/sysconfig/network-scripts/ [root@sbadb01 network-scripts]# cat ifcfg-bond1 DEVICE="bond1" IPADDR=172.18.95.12 NETMASK=255.255.255.0 NETWORK=172.18.95.0 GATEWAY=172.18.95.254 BROADCAST=172.18.95.255 ONBOOT=YES BOOTPROTO=NONE USERCTL=NO BONDING_OPTS="mode=0 miimon=100 downdelay=2000 updelay=5000 num_grat_arp=100" |
The hosts file is updated.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | [root@sbadb01 network-scripts]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 172.18.95.12 sbadb01 sbadb01.saglik.lokal 172.18.95.11 sbadb02 sbadb02.saglik.lokal #PRIV 192.168.100.61 sbadb01-priv1 sbadb01-priv1.saglik.lokal 192.168.100.62 sbadb01-priv2 sbadb01-priv2.saglik.lokal 192.168.100.63 sbadb02-priv1 sbadb02-priv1.saglik.lokal 192.168.100.64 sbadb02-priv2 sbadb02-priv2.saglik.lokal 10.124.1.101 ttidcgc.saglik.lokal ttidcgc |
We are stopping the Listener services.
1 2 3 | [oracle@sbadb01 ~]$ srvctl stop listener -node sbadb01 [oracle@sbadb01 ~]$ srvctl stop listener -node sbadb02 PRKO-2006 : Invalid node name: sbadb02 |
Scan listener is stopped.
1 | [oracle@sbadb01 ~]$ srvctl stop scan_listener |
VIP is stopped.
1 2 3 | [oracle@sbadb01 ~]$ srvctl stop vip -n sbadb01 -f [oracle@sbadb01 ~]$ srvctl stop vip -n sbadb02 -f PRKO-3250 : Failed to stop VIPs on node sbadb02 because no VIP was running on the given node |
SCAN is stopped.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | [oracle@sbadb01 ~]$ srvctl stop scan [oracle@sbadb01 ~]$ srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is not running SCAN VIP scan2 is enabled SCAN VIP scan2 is not running SCAN VIP scan3 is enabled SCAN VIP scan3 is not running [oracle@sbadb01 ~]$ srvctl status nodeapps VIP 172.18.197.62 is enabled VIP 172.18.197.62 is not running Network is enabled Network is running on node: sbadb01 ONS is enabled ONS daemon is running on node: sbadb01 |
Bond1 is deleted.
1 2 3 4 5 6 | [oracle@sbadb01 ~]$ oifcfg delif -global bond1 PRIF-33: Failed to set or delete interface because hosts could not be discovered CRS-02325: Unable to get GPnP profile from requested cluster nodes. PRIF-32: Error in checking for profile availability for host sbadb01 CRS: Result: (13) CLSGPNP_NO_DAEMON. Error CLSGPNP_NO_DAEMON (13) occured while trying to get-profile from "tcp://sbadb01:25593" ("mdns:service:gpnp561ae558e._tcp.local.://sbadb01:25593/agent=gpnpd,cname=sbadb,guid=af68e9271a077fb7bfec281561ae558e,host=sbadb01,pid=304376/gpnpd h:sbadb01 c:sbadb u:af68e9271a077fb7bfec281561ae558e") CRS-02331: Error getting GPnP profile from "sbadb01". |
NOTE: The reason we got an error is because the new IP is registered in /etc/hosts. The command is run by typing the old IP again.
1 | [oracle@sbadb01 ~]$ oifcfg delif -global bond1 |
Bond1 is Down.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | [root@sbadb01 ~]# ifdown bond1 [root@sbadb01 ~]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 172.18.95.12 sbadb01 sbadb01.saglik.lokal 172.18.95.11 sbadb02 sbadb02.saglik.lokal #172.18.197.61 sbadb01 sbadb01.saglik.lokal #PRIV 192.168.100.61 sbadb01-priv1 sbadb01-priv1.saglik.lokal 192.168.100.62 sbadb01-priv2 sbadb01-priv2.saglik.lokal 192.168.100.63 sbadb02-priv1 sbadb02-priv1.saglik.lokal 192.168.100.64 sbadb02-priv2 sbadb02-priv2.saglik.lokal 10.124.1.101 ttidcgc.saglik.lokal ttidcgc |
If changes are desired to be made in Private IPs, necessary changes are made in the corresponding bond. In addition, we are making changes to the following.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | [root@sbadb01 ~]# cd /etc/sysconfig/network-scripts/ [root@sbadb01 network-scripts]# ls -ltrh total 268K -rwxr-xr-x. 1 root root 12K Jan 11 2017 ifup-ib -rwxr-xr-x. 1 root root 6.1K Jan 11 2017 ifdown-ib -rw-r--r--. 1 root root 30K Jan 18 2017 network-functions-ipv6 -rw-r--r--. 1 root root 15K Jan 18 2017 network-functions -rwxr-xr-x. 1 root root 1.2K Jan 18 2017 net.hotplug -rwxr-xr-x. 1 root root 4.6K Jan 18 2017 init.ipv6-global -rwxr-xr-x. 1 root root 4.0K Jan 18 2017 ifup-wireless -rwxr-xr-x. 1 root root 2.6K Jan 18 2017 ifup-tunnel -rwxr-xr-x. 1 root root 3.3K Jan 18 2017 ifup-sit -rwxr-xr-x. 1 root root 1.9K Jan 18 2017 ifup-routes -rwxr-xr-x. 1 root root 4.1K Jan 18 2017 ifup-ppp -rwxr-xr-x. 1 root root 2.5K Jan 18 2017 ifup-post -rwxr-xr-x. 1 root root 954 Jan 18 2017 ifup-plusb -rwxr-xr-x. 1 root root 727 Jan 18 2017 ifup-plip -rwxr-xr-x. 1 root root 11K Jan 18 2017 ifup-ipv6 -rwxr-xr-x. 1 root root 12K Jan 18 2017 ifup-ippp -rwxr-xr-x. 1 root root 859 Jan 18 2017 ifup-bnep -rwxr-xr-x. 1 root root 13K Jan 18 2017 ifup-aliases -rwxr-xr-x. 1 root root 1.5K Jan 18 2017 ifdown-tunnel -rwxr-xr-x. 1 root root 1.5K Jan 18 2017 ifdown-sit -rwxr-xr-x. 1 root root 835 Jan 18 2017 ifdown-routes -rwxr-xr-x. 1 root root 1.1K Jan 18 2017 ifdown-ppp -rwxr-xr-x. 1 root root 1.6K Jan 18 2017 ifdown-post -rwxr-xr-x. 1 root root 4.1K Jan 18 2017 ifdown-ipv6 -rwxr-xr-x. 1 root root 781 Jan 18 2017 ifdown-ippp -rwxr-xr-x. 1 root root 5.8K Jan 18 2017 ifdown-eth -rwxr-xr-x. 1 root root 627 Jan 18 2017 ifdown-bnep -rw-r--r--. 1 root root 254 Jan 18 2017 ifcfg-lo -rwxr-xr-x. 1 root root 12K Mar 22 2017 ifup-eth -rw-r--r--. 1 root root 135 Apr 17 2019 ifcfg-em4 -rw-r--r--. 1 root root 135 Apr 17 2019 ifcfg-em3 lrwxrwxrwx. 1 root root 20 Apr 17 2019 ifdown -> ../../../sbin/ifdown lrwxrwxrwx. 1 root root 11 Apr 17 2019 ifdown-isdn -> ifdown-ippp lrwxrwxrwx. 1 root root 18 Apr 17 2019 ifup -> ../../../sbin/ifup lrwxrwxrwx. 1 root root 9 Apr 17 2019 ifup-isdn -> ifup-ippp -rw-r--r--. 1 root root 160 Apr 17 2019 ifcfg-em1 -rw-r--r--. 1 root root 160 Apr 17 2019 ifcfg-em2 -rw-r--r--. 1 root root 161 Apr 17 2019 ifcfg-p2p1 -rw-r--r--. 1 root root 161 Apr 17 2019 ifcfg-p2p2 -rw-r--r--. 1 root root 243 Apr 17 2019 ifcfg-bond0 -rw-r--r--. 1 root root 56 Apr 17 2019 rule-bond0 -rw-r--r--. 1 root root 83 Apr 17 2019 route-bond0 -rw-r--r-- 1 root root 230 Apr 18 2019 ifcfg-p5p1 -rw-r--r-- 1 root root 230 Apr 25 2019 ifcfg-p5p2 -rw-r--r-- 1 root root 238 Jan 27 17:51 ifcfg-bond1 |
Bond1 is UP.
1 2 3 4 5 6 7 8 9 10 11 12 | [root@sbadb01 network-scripts]# ifup bond1 Determining if ip address 172.18.95.12 is already in use for device bond1... [root@sbadb01 network-scripts]# ifconfig bond1 bond1 Link encap:Ethernet HWaddr B0:26:28:30:F5:50 inet addr:172.18.95.12 Bcast:172.18.95.255 Mask:255.255.255.0 inet6 addr: fe80::b226:28ff:fe30:f550/64 Scope:Link UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1 RX packets:36879628374 errors:0 dropped:174 overruns:0 frame:0 TX packets:21395899122 errors:0 dropped:2 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:52673112035954 (47.9 TiB) TX bytes:4288404017953 (3.9 TiB) |
We check if the IP exists elsewhere.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 | [root@sbadb01 network-scripts]# ifconfig -a bond0 Link encap:Ethernet HWaddr 20:04:0F:EC:7E:A0 inet addr:172.18.198.61 Bcast:172.18.198.255 Mask:255.255.255.0 inet6 addr: fe80::2204:fff:feec:7ea0/64 Scope:Link UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1 RX packets:24761250 errors:0 dropped:0 overruns:0 frame:0 TX packets:160790 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:3368938088 (3.1 GiB) TX bytes:15309487 (14.6 MiB) bond1 Link encap:Ethernet HWaddr B0:26:28:30:F5:50 inet addr:172.18.95.12 Bcast:172.18.95.255 Mask:255.255.255.0 inet6 addr: fe80::b226:28ff:fe30:f550/64 Scope:Link UP BROADCAST RUNNING MASTER MULTICAST MTU:1500 Metric:1 RX packets:36879628400 errors:0 dropped:174 overruns:0 frame:0 TX packets:21395899164 errors:0 dropped:2 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:52673112040162 (47.9 TiB) TX bytes:4288404022275 (3.9 TiB) em1 Link encap:Ethernet HWaddr 20:04:0F:EC:7E:A0 UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:12379539 errors:0 dropped:0 overruns:0 frame:0 TX packets:80203 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:1684384402 (1.5 GiB) TX bytes:7660189 (7.3 MiB) Interrupt:166 em2 Link encap:Ethernet HWaddr 20:04:0F:EC:7E:A0 UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:12381767 errors:0 dropped:0 overruns:0 frame:0 TX packets:80587 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:1684561369 (1.5 GiB) TX bytes:7649298 (7.2 MiB) Interrupt:167 em3 Link encap:Ethernet HWaddr 20:04:0F:EC:7E:A2 BROADCAST MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:168 em4 Link encap:Ethernet HWaddr 20:04:0F:EC:7E:A3 BROADCAST MULTICAST MTU:1500 Metric:1 RX packets:0 errors:0 dropped:0 overruns:0 frame:0 TX packets:0 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:0 (0.0 b) TX bytes:0 (0.0 b) Interrupt:169 lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:65536 Metric:1 RX packets:3059267671 errors:0 dropped:0 overruns:0 frame:0 TX packets:3059267671 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:1009979059295 (940.6 GiB) TX bytes:1009979059295 (940.6 GiB) p2p1 Link encap:Ethernet HWaddr B0:26:28:30:F5:50 inet6 addr: fe80::b226:28ff:fe30:f550/64 Scope:Link UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:28 errors:0 dropped:0 overruns:0 frame:0 TX packets:43 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:2350 (2.2 KiB) TX bytes:3701 (3.6 KiB) p2p2 Link encap:Ethernet HWaddr B0:26:28:30:F5:50 inet6 addr: fe80::b226:28ff:fe30:f550/64 Scope:Link UP BROADCAST RUNNING SLAVE MULTICAST MTU:1500 Metric:1 RX packets:23 errors:0 dropped:0 overruns:0 frame:0 TX packets:30 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:3910 (3.8 KiB) TX bytes:3379 (3.2 KiB) p5p1 Link encap:Ethernet HWaddr B0:26:28:31:09:80 inet addr:192.168.100.61 Bcast:192.168.100.255 Mask:255.255.255.0 inet6 addr: fe80::b226:28ff:fe31:980/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:11927169794 errors:0 dropped:0 overruns:0 frame:0 TX packets:11509007226 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:10002256062877 (9.0 TiB) TX bytes:9544709432565 (8.6 TiB) p5p1:1 Link encap:Ethernet HWaddr B0:26:28:31:09:80 inet addr:169.254.105.203 Bcast:169.254.127.255 Mask:255.255.128.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 p5p2 Link encap:Ethernet HWaddr B0:26:28:31:09:81 inet addr:192.168.100.62 Bcast:192.168.100.255 Mask:255.255.255.0 inet6 addr: fe80::b226:28ff:fe31:981/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:321094344 errors:0 dropped:0 overruns:0 frame:0 TX packets:231844055 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:276341592210 (257.3 GiB) TX bytes:149882042530 (139.5 GiB) p5p2:1 Link encap:Ethernet HWaddr B0:26:28:31:09:81 inet addr:169.254.191.131 Bcast:169.254.255.255 Mask:255.255.128.0 UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 |
Bond1 is set with its new IP.
1 2 3 4 5 | [oracle@sbadb01 ~]$ oifcfg setif -global bond1/172.18.95.0:public [oracle@sbadb01 ~]$ oifcfg getif p5p1 192.168.100.0 global cluster_interconnect,asm p5p2 192.168.100.0 global cluster_interconnect,asm bond1 172.18.95.0 global public |
DNS change is made.
sbadb-scan dns record;
172.18.197.58
172.18.197.59
172.18.197.60
In its place
172.18.95.14
172.18.95.15
172.18.95.16
will be updated to
sbadb01 dns record;
172.18.197.61
In its place
172.18.95.12
will be updated to
sbadb01-vip dns record;
172.18.197.62
In its place
172.18.95.13
will be updated to
sbadb02 dns record;
will be deleted as it will not be used
sbadb02-vip dns record:
will be deleted as it will not be used
We’re checking to see if the DNS change has taken place.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | [root@sbadb01 network-scripts]# nslookup sbadb-scan Server: 10.7.131.11 Address: 10.7.131.11#53 Name: sbadb-scan.saglik.lokal Address: 172.18.95.15 Name: sbadb-scan.saglik.lokal Address: 172.18.95.16 Name: sbadb-scan.saglik.lokal Address: 172.18.95.14 [root@sbadb01 network-scripts]# nslookup sbadb01-vip Server: 10.7.131.11 Address: 10.7.131.11#53 Name: sbadb01-vip.saglik.lokal Address: 172.18.95.13 [root@sbadb01 network-scripts]# nslookup sbadb02-vip ;; Got SERVFAIL reply from 10.7.131.12, trying next server Server: 10.7.131.11 Address: 10.7.131.11#53 ** server can't find sbadb02-vip: SERVFAIL [root@sbadb01 network-scripts]# nslookup sbadb02 ;; connection timed out; trying next origin ;; Got SERVFAIL reply from 10.7.131.11, trying next server ;; connection timed out; no servers could be reached [root@sbadb01 network-scripts]# nslookup sbadb01 Server: 10.7.131.12 Address: 10.7.131.12#53 Name: sbadb01.saglik.lokal Address: 172.18.95.12 |
The new IP is modified with srvctl.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/srvctl modify network -netnum 1 -subnet 172.18.95.0/255.255.255.0/bond1 [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/srvctl modify scan -netnum 1 -scanname sbadb-scan [oracle@sbadb01 ~]$ srvctl config scan SCAN name: sbadb-scan, Network: 1 Subnet IPv4: 172.18.95.0/255.255.255.0/bond1, static Subnet IPv6: SCAN 1 IPv4 VIP: 172.18.95.14 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 2 IPv4 VIP: 172.18.95.15 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: SCAN 3 IPv4 VIP: 172.18.95.16 SCAN VIP is enabled. SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes: |
The Listener, SCAN, SCAN_LISTENER services are started.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | [oracle@sbadb01 ~]$ srvctl start vip -node sbadb01 [oracle@sbadb01 ~]$ srvctl start listener [oracle@sbadb01 ~]$ srvctl start scan PRCC-1014 : scan1 was already running PRCR-1004 : Resource ora.scan1.vip is already running PRCR-1079 : Failed to start resource ora.scan1.vip CRS-5702: Resource 'ora.scan1.vip' is already running on 'sbadb01' [oracle@sbadb01 ~]$ srvctl start scan_listener PRCC-1014 : LISTENER_SCAN1 was already running PRCR-1004 : Resource ora.LISTENER_SCAN1.lsnr is already running PRCR-1079 : Failed to start resource ora.LISTENER_SCAN1.lsnr CRS-5702: Resource 'ora.LISTENER_SCAN1.lsnr' is already running on 'sbadb01' [oracle@sbadb01 ~]$ srvctl status nodeapps VIP 172.18.95.13 is enabled VIP 172.18.95.13 is running on node: sbadb01 Network is enabled Network is running on node: sbadb01 ONS is enabled ONS daemon is running on node: sbadb01 [oracle@sbadb01 ~]$ srvctl status scan_listener SCAN Listener LISTENER_SCAN1 is enabled SCAN listener LISTENER_SCAN1 is running on node sbadb01 SCAN Listener LISTENER_SCAN2 is enabled SCAN listener LISTENER_SCAN2 is running on node sbadb01 SCAN Listener LISTENER_SCAN3 is enabled SCAN listener LISTENER_SCAN3 is running on node sbadb01 |
Cluster services are stopped and restarted.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 | [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl stop cluster -all CRS-2673: Attempting to stop 'ora.crsd' on 'sbadb01' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'sbadb01' CRS-2673: Attempting to stop 'ora.chad' on 'sbadb01' CRS-2673: Attempting to stop 'ora.qosmserver' on 'sbadb01' CRS-2673: Attempting to stop 'ora.mhrsdg.db' on 'sbadb01' CRS-2677: Stop of 'ora.qosmserver' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.mhrsdg.db' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'sbadb01' CRS-2673: Attempting to stop 'ora.cvu' on 'sbadb01' CRS-2677: Stop of 'ora.cvu' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'sbadb01' CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan2.vip' on 'sbadb01' CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.scan3.vip' on 'sbadb01' CRS-2677: Stop of 'ora.scan2.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.scan3.vip' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.chad' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.mgmtdb' on 'sbadb01' CRS-2677: Stop of 'ora.mgmtdb' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'sbadb01' CRS-2673: Attempting to stop 'ora.RECO.dg' on 'sbadb01' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'sbadb01' CRS-2677: Stop of 'ora.RECO.dg' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'sbadb01' CRS-2677: Stop of 'ora.asm' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'sbadb01' CRS-2677: Stop of 'ora.MGMTLSNR' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.sbadb01.vip' on 'sbadb01' CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.sbadb01.vip' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'sbadb01' CRS-2677: Stop of 'ora.ons' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'sbadb01' CRS-2677: Stop of 'ora.net1.network' on 'sbadb01' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'sbadb01' has completed CRS-2677: Stop of 'ora.crsd' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'sbadb01' CRS-2673: Attempting to stop 'ora.evmd' on 'sbadb01' CRS-2673: Attempting to stop 'ora.storage' on 'sbadb01' CRS-2677: Stop of 'ora.storage' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'sbadb01' CRS-2677: Stop of 'ora.ctssd' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.evmd' on 'sbadb01' succeeded CRS-2677: Stop of 'ora.asm' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'sbadb01' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'sbadb01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'sbadb01' CRS-2677: Stop of 'ora.cssd' on 'sbadb01' succeeded [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl start cluster -all CRS-2672: Attempting to start 'ora.cssdmonitor' on 'sbadb01' CRS-2672: Attempting to start 'ora.evmd' on 'sbadb01' CRS-2676: Start of 'ora.cssdmonitor' on 'sbadb01' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'sbadb01' CRS-2672: Attempting to start 'ora.diskmon' on 'sbadb01' CRS-2676: Start of 'ora.diskmon' on 'sbadb01' succeeded CRS-2676: Start of 'ora.evmd' on 'sbadb01' succeeded CRS-2676: Start of 'ora.cssd' on 'sbadb01' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'sbadb01' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'sbadb01' CRS-2676: Start of 'ora.ctssd' on 'sbadb01' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'sbadb01' succeeded CRS-2672: Attempting to start 'ora.asm' on 'sbadb01' CRS-2676: Start of 'ora.asm' on 'sbadb01' succeeded CRS-2672: Attempting to start 'ora.storage' on 'sbadb01' CRS-2676: Start of 'ora.storage' on 'sbadb01' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'sbadb01' CRS-2676: Start of 'ora.crsd' on 'sbadb01' succeeded [root@sbadb01 ~]# [root@sbadb01 ~]# [root@sbadb01 ~]# [root@sbadb01 ~]# [root@sbadb01 ~]# [root@sbadb01 ~]# [root@sbadb01 ~]# /u01/app/12.2.0.1/grid/bin/crsctl enable crs CRS-4622: Oracle High Availability Services autostart is enabled. |
