ORACLE rac11g Change IP address

Environment: Oracle 11.2.0.4 RAC

Pre-Modified IP address

# public IP

192.168.2.71 DB1

192.168.2.72 DB2

192.168.2.76 DB3

#priv IP

200.100.100.11 Db1-priv

200.100.100.12 Db2-priv

200.100.100.13 Db3-priv

#vip IP

192.168.2.73 DB1-VIP

192.168.2.74 DB2-VIP

192.168.2.77 DB3-VIP

#scan IP

192.168.2.75 Db-scan

Modified IP Address

# public IP

192.168.1.71 DB1

192.168.1.72 DB2

192.168.1.76 DB3

#priv IP

100.100.100.11 Db1-priv

100.100.100.12 Db2-priv

100.100.100.13 Db3-priv

#vip IP

192.168.1.73 DB1-VIP

192.168.1.74 DB2-VIP

192.168.1.77 DB3-VIP

#scan IP

192.168.1.75 Db-scan

1. View the backup of OCR

[Email protected] bin]#./ocrconfig-showbackup

2. Backup OCR

[Email protected] bin]#./ocrconfig-manualbackup

DB3 2015/01/29 19:58:22/U01/APP/11.2.0/GRID/CDATA/DB-SCAN/BACKUP_20150129_195822.OCR

3. Close the database

Srvctl Stop database-d DB

4. Modify on any node:

Here, I'm working on Node 1.

[Email protected] ~]# cd/u01/app/11.2.0/grid/bin/

[Email protected] bin]#/oifcfg getif

Eth0 192.168.2.0 Global Public

eth1 200.100.100.0 Global Cluster_interconnect

[Email protected] bin]#/oifcfg delif-global eth0

[Email protected] bin]#/oifcfg Setif-global eth0/192.168.1.0:public

[Email protected] bin]#/oifcfg getif

eth1 200.100.100.0 Global Cluster_interconnect

Eth0 192.168.1.0 Global Public

[Email protected] bin]#/oifcfg Delif-global eth1

prif-31:failed to delete the specified network interface because it's the last private interface

This is not allowed to delete the last private interface, you can first add a private interface to delete

[Email protected] bin]#/oifcfg Setif-global eth1/200.100.100.0:cluster_interconnect

[Email protected] bin]#/oifcfg getif

eth1 100.100.100.0 Global Cluster_interconnect

Eth0 192.168.2.0 Global Public

eth1 200.100.100.0 Global Cluster_interconnect

[Email protected] bin]#/oifcfg Delif-global eth1/100.100.100.0:cluster_interconnect

[Email protected] bin]#/oifcfg getif

Eth0 192.168.2.0 Global Public

eth1 200.100.100.0 Global Cluster_interconnect

Stop Oracle High-potential service at a node

[Email protected] bin]#./crsctl Stop Cluster-all

5. Modify the IP address and/etc/hosts file and test

6. Restart all services at all nodes

[[email protected] bin]#./crsctl start Cluster-all

7. Stop Scan_listener and Scan

[[email protected] bin]#./srvctl Stop Scan_listener

[[email protected] bin]#./srvctl Stop scan

8. Delete Scan_listener and Scan

[Email protected] bin]#./srvctl Remove Scan_listener-f

[Email protected] bin]#./srvctl Remove Scan-f

9. Add Scan and Scan_listener

[Email protected] bin]#./srvctl add scan-n db-scan-k 2-s 192.168.1.0/255.255.255.0/eth0

Note: The above command,-K 1 (network number), will cause an error because it has been used before

[Email protected] bin]#./srvctl Config Scan

SCAN Name:db-scan, Network:2/192.168.1.0/255.255.255.0/eth0

SCAN VIP name:scan1, IP:/db-scan/192.168.1.75

[Email protected] bin]#./srvctl add Scan_listener

10. Start Scan and Scan_listener

[[email protected] bin]#./srvctl start scan

[[email protected] bin]#./srvctl start Scan_listener

11. Stop VIP Resources

[Email protected] bin]#./crsctl Stop Resource Ora.db1.vip-f

[Email protected] bin]#./crsctl Stop Resource Ora.db2.vip-f

[Email protected] bin]#./crsctl Stop Resource Ora.db3.vip-f

Here you can see the status of the VIP through the following command

[Email protected] bin]#/crsctl stat res-t

Ora.db1.vip

1 OFFLINE OFFLINE

Ora.db2.vip

1 OFFLINE OFFLINE

Ora.db3.vip

1 OFFLINE OFFLINE

12. Change VIP Address

[Email protected] bin]#/srvctl modify Nodeapps-a 192.168.1.73/255.255.255.0/eth0-n db1

[Email protected] bin]#/srvctl modify NODEAPPS-A 192.168.1.74/255.255.255.0/eth0-n DB2

[Email protected] bin]#/srvctl modify Nodeapps-a 192.168.1.77/255.255.255.0/eth0-n db3

13. Start VIP resources:

[Email protected] bin]#/crsctl start resource ora.db1.vip-f

Crs-2672:attempting to start ' ora.db1.vip ' on ' db1 '

Crs-2676:start of ' ora.db1.vip ' on ' DB1 ' succeeded

[Email protected] bin]#/crsctl start resource ora.db2.vip-f

Crs-2672:attempting to start ' ora.db2.vip ' on ' DB2 '

Crs-2676:start of ' ora.db2.vip ' on ' DB2 ' succeeded

[Email protected] bin]#/crsctl start resource ora.db3.vip-f

Crs-2672:attempting to start ' ora.db3.vip ' on ' db3 '

Crs-2676:start of ' ora.db3.vip ' on ' db3 ' succeeded

The local listener is started after the VIP resource is started, and the 14th step below can not be performed

14. Start Local monitoring:

[Email protected] bin]#/srvctl start listener-n db1

[Email protected] bin]#/srvctl start listener-n DB2

[Email protected] bin]#/srvctl start listener-n db3

Issue: After the operation is complete, execute oifcfg getif, which appears in the following prompt message

[Email protected] peer]$ oifcfg getif

Eth0 192.168.1.0 Global Public

eth1 100.100.100.0 Global Cluster_interconnect

Only in ocr:eth1:100.100.100.0 global Cluster_interconnect

Prif-30:network information in OCR and GPNP profile differs

said that the network information in the OCR and GPNP inconsistent, here re-configuration can be

[Email protected] peer]$ oifcfg Setif-global eth1/100.100.100.0:cluster_interconnect

[Email protected] peer]$ oifcfg getif

Eth0 192.168.1.0 Global Public

eth1 100.100.100.0 Global Cluster_interconnect

This article is from the "Simon Qing his Little Uncle" blog, please be sure to keep this source http://718693.blog.51cto.com/708693/1610487

ORACLE rac11g Change IP address