I got one request to change public, private & vip address in my two nodes oracle cluster. I was thinking this may possible or it will create any other issues.
In test instance just tried to change VIP IP address in one nodes it's working fine. Now i am looking for change public & private IP address change using Oracle Interface Configuration Tool (oifcfg) & I will post this later when i got free time.
I would like to share the below changes with you; If you have any query or suggestion you can reach me any time. Thanks ...
How to change VIP - IP address in Oracle Cluster Node
There are few steps to change VIP IP Address.
1. Check current configuration
E:\oracle\product\10.2.0\crs\BIN>srvctl config nodeapps -h
Usage: srvctl config nodeapps -n [-a] [-g] [-o] [-s] [-l]
-n Node name
-a Display VIP configuration
-g Display GSD configuration
-s Display ONS daemon configuration
-l Display listener configuration
-h Print usage
E:\oracle\product\10.2.0\crs\BIN>srvctl config nodeapps -n babu-node1 -a
VIP exists.: /babu-node1-vip/192.168.200.34/255.255.255.0/public
2. Stop your asm, db instance and other services on node 1
E:\oracle\product\10.2.0\crs\BIN>srvctl stop asm -n babu-node1
E:\oracle\product\10.2.0\crs\BIN>srvctl stop instance -d devdb -i devdb1
E:\oracle\product\10.2.0\crs\BIN>srvctl stop nodeapps -n babu-node1
E:\oracle\product\10.2.0\crs\BIN>crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application OFFLINE OFFLINE
ora....E1.lsnr application OFFLINE OFFLINE
ora....de1.gsd application OFFLINE OFFLINE
ora....de1.ons application OFFLINE OFFLINE
ora....de1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE babu-node2
ora....E2.lsnr application ONLINE ONLINE babu-node2
ora....de2.gsd application ONLINE ONLINE babu-node2
ora....de2.ons application ONLINE ONLINE babu-node2
ora....de2.vip application ONLINE ONLINE babu-node2
ora.devdb.db application ONLINE ONLINE babu-node2
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application ONLINE ONLINE babu-node2
3. Modify your new VIP - IP Address or VIP Host Name in /etc/hosts or C:\WINDOWS\system32\drivers\etc\hosts file ( you should update your new ip on both nodes )
4. Now modify new ip address on node1
E:\oracle\product\10.2.0\crs\BIN>srvctl config nodeapps -n babu-node1 -a
VIP exists.: /babu-node1-vip/192.168.200.34/255.255.255.0/public
E:\oracle\product\10.2.0\crs\BIN>srvctl modify nodeapps -n babu-node1 -A 192.168.200.36/255.255.255.0/"public"
E:\oracle\product\10.2.0\crs\BIN>srvctl config nodeapps -n babu-node1 -a
VIP exists.: /babu-node1-vip/192.168.200.36/255.255.255.0/public
5. Double check VIP modified or not using the above command. If everything fine then start all services & check your new VIP - IP address.
E:\oracle\product\10.2.0\crs\BIN>srvctl start nodeapps -n babu-node1
E:\oracle\product\10.2.0\crs\BIN>srvctl start asm -n babu-node1
E:\oracle\product\10.2.0\crs\BIN>srvctl start instance -d devdb -i devdb1
E:\oracle\product\10.2.0\crs\BIN>ipconfig
Windows IP Configuration
Ethernet adapter public:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 192.168.200.36
Subnet Mask . . . . . . . . . . . : 255.255.255.0
IP Address. . . . . . . . . . . . : 192.168.200.33
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . : 192.168.200.1
Ethernet adapter private:
Connection-specific DNS Suffix . :
IP Address. . . . . . . . . . . . : 10.1.1.1
Subnet Mask . . . . . . . . . . . : 255.255.255.0
Default Gateway . . . . . . . . . :
E:\oracle\product\10.2.0\crs\BIN>crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE ONLINE babu-node1
ora....E1.lsnr application ONLINE ONLINE babu-node1
ora....de1.gsd application ONLINE ONLINE babu-node1
ora....de1.ons application ONLINE ONLINE babu-node1
ora....de1.vip application ONLINE ONLINE babu-node1
ora....SM2.asm application ONLINE ONLINE babu-node2
ora....E2.lsnr application ONLINE ONLINE babu-node2
ora....de2.gsd application ONLINE ONLINE babu-node2
ora....de2.ons application ONLINE ONLINE babu-node2
ora....de2.vip application ONLINE ONLINE babu-node2
ora.devdb.db application ONLINE ONLINE babu-node2
ora....b1.inst application ONLINE ONLINE babu-node1
ora....b2.inst application ONLINE ONLINE babu-node2
No comments:
Post a Comment