Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to change the IP of oracle 11G RAC. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

# host IP

10.165.240.61 pool01

10.165.240.62 pool02

10.165.240.63 pool03

# VIP

10.165.240.64 pool01-vip

10.165.240.65 pool02-vip

10.165.240.66 pool03-vip

# scan IP

10.165.240.67 pool-scan

Ifconfig-a

Rac1 public 192.168.4.211 bond0-> 192.168.0.161

Rac2 public 192.168.4.222 bond0-> 192.168.0.162

Rac1-vip vip 192.168.4.216 eth0-> 192.168.0.165

Rac2-vip vip 192.168.4.217 eth0-> 192.168.0.166

Rac-cluster scan 192.168.4.201 bond0-> 192.168.0.160

Eth2 is private ip and will not be changed.

Prohibit all nodes from starting and stopping the database and listening

Su-grid

Srvctl disable listener-n pool01

Srvctl disable listener-n pool02

Srvctl stop listener-n pool01

Srvctl stop listener-n pool02

Su-root

. / srvctl disable database-d devdb

Su-grid

Srvctl stop database-d devdb-o immediate

Prohibit all nodes from starting and stopping vip, using the vip name of the hosts file

Su-root

. / srvctl disable vip-I "pool01-vip"

. / srvctl disable vip-I "pool02-vip"

Su-grid

Srvctl stop vip-n pool01

Srvctl stop vip-n pool02

Disable and stop the startup of scan_listener on all nodes

Su-grid

Srvctl disable scan_listener

Srvctl stop scan_listener

Disable and stop all node scan

Su-root

. / srvctl disable scan

Su-grid

Srvctl stop scan

The nodes on both sides stop crs

Su-root

. / crsctl stop crs

Modify both sides node / etc/hosts

Modify the configuration of two node network cards

/ etc/sysconfig/network-scripts/ifcfg-eth0

/ etc/init.d/network restart

Both nodes start crs

Su-root

/ u01/app/11.2.0/grid/bin/crsctl start crs

Modify public ip

Su-root

. / oifcfg getif

. / oifcfg delif-global bond0

. / oifcfg setif-global bond0/10.165.240.0:public

. / oifcfg getif

Modify vip

View

Su-root

. / srvctl config vip-n pool01

. / srvctl modify nodeapps-n pool01-A 10.165.240.64/255.255.254.0/bond0

. / srvctl modify nodeapps-n pool02-A 10.165.240.65/255.255.254.0/bond0

. / srvctl config vip-n pool02

Modify scan-ip

Su-grid

View

Srvctl config scan

Su-root

. / srvctl modify scan-n 10.165.240.67

Su-grid

Srvctl config scan

Start vip snooping scan scan_listener database

Su-root

. / srvctl enable listener-n pool01

. / srvctl enable listener-n pool02

. / srvctl enable vip-I "pool01-vip"

. / srvctl enable vip-I "pool02-vip"

. / srvctl start vip-n pool01

. / srvctl start vip-n pool02

. / srvctl start listener-n pool01

. / srvctl start listener-n pool02

. / srvctl enable scan_listener

. / srvctl enable scan

. / srvctl start scan

. / srvctl start scan_listener

. / srvctl enable database-d devdb

. / srvctl start database-d devdb

Modify local_listener

View system parameters

Show parameter local

Alter system set local_listener=''

=

Alter profile default limit PASSWORD_LOCK_TIME 1/24/60/60

Alter profile default limit FAILED_LOGIN_ATTEMPTS 30

This is the end of the article on "how to change oracle 11G RAC IP". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.