| Private Hostname | Private IP | interface name | subnet | netmask | MTU | Steps |
|---|---|---|---|---|---|---|
| Change | No longer recorded in OCR . Change /etc/hosts | |||||
| Change | shutdown crs only that node; /etc/hosts, OS network config ; restart crs | |||||
| Change | $ oifcfg getif ; Add the new cluster_interconnect information with $ oifcfg setif -global stop and disable crs on all nodes; make OS network config ; Enable and restart crs | |||||
| Change | $ oifcfg getif ; Add the new cluster_interconnect information with $ oifcfg setif -global stop and disable crs on all nodes; make OS network config ; Enable and restart crs | |||||
| Change | $ oifcfg getif ; Add the new cluster_interconnect information with $ oifcfg setif -global stop and disable crs on all nodes; make OS network config ; Enable and restart crs | |||||
| Change | shutdown crs on all node; /etc/hosts, OS network config ; restart crs |
Note :
oifcfg' can not update IP address information.
It can be used to find out currently configured interfaces in OCR
Use Grid Infrastructure owner.
oifcfg commands only require to run on 1 of the cluster node, not all.
Network configuration change and oifcfg change should happen at the same time..
All nodes should be up or else remove the down node from cluster.
Oracle Clusterware should be up on the node from where you run this command.
Add new private interface first before deleting the old private interface.
| Public Hostname | Public IP | interface name | subnet | netmask | MTU | Steps |
|---|---|---|---|---|---|---|
| Change | Recorded in OCR. deleting the node, then add the node back with a new hostname, or reinstall the clusterware . Change /etc/hosts | |||||
| Change | 1. Shutdown Oracle Clusterware stack 2. Modify the IP address at network layer, DNS and /etc/hosts file to reflect the change 3. Restart Oracle Clusterware stack | |||||
| Change | delete the existing interface information from OCR and add it back % $CRS_HOME/bin/oifcfg delif -global eth0/10.2.156.0 % $CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public | |||||
| Change | delete the existing interface information from OCR and add it back % $CRS_HOME/bin/oifcfg delif -global eth0/10.2.156.0 % $CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public | |||||
| Change | delete the existing interface information from OCR and add it back % $CRS_HOME/bin/oifcfg delif -global eth0/10.2.156.0 % $CRS_HOME/bin/oifcfg setif -global eth0/10.2.166.0:public.No Oracle clusterware required. Now change VIP and SCAN VIP | |||||
| Change |
Changing VIPs associated with public network change
1. Gather the existing setup
$ srvctl config nodeapps -a // $ srvctl config nodeapps -n racnode1 -a
2. Verify VIP status
$ crsctl stat res -t // $ crs_stat -t
$ ifconfig -a // netstat -in for HP
3.Stop the nodeapps resources
$ srvctl stop instance -d RACDB -n racnode1 // $ srvctl stop instance -d RACDB -i RACDB1 , srvctl stop asm -n racnode1 , srvctl stop nodeapps -n racnode1
$ srvctl stop vip -n racnode1 -f
4.Verify VIP is now OFFLINE and the interface is no longer bound to the public network interface
$ crs_stat -t (or $ crsctl stat res -t for 11gR2)
$ ifconfig -a
(netstat -in for HP and ipconfig /all for windows)
5. Determine the new VIP IP or VIP hostname/ new subnet/ new netmask/ new interface name
make the network change on OS
change in /etc/hosts
6. Modify the VIP resource
root :# srvctl modify nodeapps -n racnode1 -A racnode1-nvip/255.255.255.0/eth2
Since network attributes (subnet/netmask/interface) are recorded with the network resource. OCR only records the VIP hostname or the VIP
if only subnet/netmask/interface change is required : # srvctl modify network -k
7. Verify the change
$ srvctl config nodeapps -a // $ srvctl config nodeapps -n racnode1 -a
8.Start the nodeapps resources
$ srvctl start vip -n racnode1
$ srvctl start listener -n racnode1
$ srvctl start instance -d RACDB -n racnode1 // srvctl start nodeapps -n racnode1 , srvctl start asm -n racnode1 , $ srvctl start instance -d RACDB -i RACDB1
9.Verify VIP is now OFFLINE and the interface is no longer bound to the public network interface
$ crs_stat -t (or $ crsctl stat res -t for 11gR2)
$ ifconfig -a
(netstat -in for HP and ipconfig /all for windows)
Modify listener.ora, tnsnames.ora and LOCAL_LISTENER/REMOTE_LISTENER parameter to reflect the VIP change if necessary.
Hanganalyze :
sqlplus -prelim / as sysdba
1. oradebug setmypid
2. oradebug unlimit
3. oradebug dump systemstate 266
WAIT 60 SECONDS
oradebug dump systemstate 266
4. oradebug -g all hanganalyze 3
Wait 1 minute....
oradebug -g all hanganalyze 3
For ASM Instances
==============
1.oradebug setmypid
2. oradebug unlimit
3. oradebug dump systemstate 265
WAIT 60 SECONDS
oradebug dump systemstate 265
