14 Replies Latest reply: Oct 23, 2012 7:33 AM by user10187253 RSS

    Oracle RAC server's IP and Subnetmask change

    178210
      Oracle DB Version:10.2.0.3.0
      OS version : RedHat linux 4
      Number of Nodes: 2

      We need to move our RAC db servers from Atlanta to NJ. This move requires IP and subnet mask change. How we can do this chanse in for nodeapps / CRS components?
        • 1. Re: Oracle RAC server's IP and Subnetmask change
          516450
          Using srvctl - Check ML Note#276434.1 for more information.

          HTH

          Thanks
          Chandra Pabba
          • 2. Re: Oracle RAC server's IP and Subnetmask change
            178210
            Chandra,

            Thank you for your reply.

            Said document describes VIP or VIP hostname change only. Since we are moving servers from another location. The public IP and its subnet mask also will be changed

            Any document for it?
            • 3. Re: Oracle RAC server's IP and Subnetmask change
              602799
              I think ML 283684.1 should help you.

              thanks
              • 4. Re: Oracle RAC server's IP and Subnetmask change
                178210
                Thanks for your e-mail.

                By executing below command we are changing the subnetmask ONLY for either PUBLIC/PRIVATE network cards globally.

                oifcfg setif -global eth1/subnetmask:public

                I beleive the metalink note is not accurate
                • 5. Re: Oracle RAC server's IP and Subnetmask change
                  445103
                  the note is correct...in addition if you search the ora rac docs you may find:

                  srvctl modify nodeapps -n <node name> -A <new IP>/<new subnet mask>/eth0
                  • 6. Re: Oracle RAC server's IP and Subnetmask change
                    Chris Slattery
                    also need to run emca for the amended em config as well ?
                    • 7. Re: Oracle RAC server's IP and Subnetmask change
                      178210
                      With your command you are changing the VIP refered in nodeapps.
                      Pls refer below help

                      [oracle@accudbnode1 bin]$ ./srvctl modify nodeapps -h
                      Usage: srvctl modify nodeapps -n <node_name> [-o <oracle_home>] [-A <new_vip_address>]
                      -n <node> Node name
                      -A <addr_str> Node level Virtual IP address
                      -o <oracle_home> ORACLE_HOME path
                      -h Print usage
                      [oracle@accudbnode1 bin]$


                      How can change the IP address entries in Voting Disk & OCR File?
                      • 8. Re: Oracle RAC server's IP and Subnetmask change
                        445103
                        How can change the IP address entries in Voting Disk & OCR File?
                        ...I don't think you have a need to change anything in voting disk...and for ocr...srvctl is taking care of it...
                        • 9. Re: Oracle RAC server's IP and Subnetmask change
                          178210
                          Thanks for your reply
                          • 10. Re: Oracle RAC server's IP and Subnetmask change
                            445103
                            the steps should be something like:

                            - stop all db, asm and nodeapps (only clusterware stack is running)
                            - you are suppose to know new public, private and vip address/ip
                            - delete current private and public configuration using oifcfg delif
                            - set new ones with oifcfg setif
                            - redefine vip with srvctl modify nodeapps
                            - stop CRS
                            - make sure that new IP are changed on system level (dns, etc/hosts etc...) and restart server

                            hth
                            • 11. Re: Oracle RAC server's IP and Subnetmask change
                              622380
                              Cluster changes 1st and then OS changes.

                              Exact details: http://orcl-experts.info/index.php?name=FAQ&id_cat=9
                              • 12. Re: Oracle RAC server's IP and Subnetmask change
                                692755
                                I am doing a clean installation of RAC 10g rev.2, and during the installation I set the netmask for the VIP to 255.255.252.0, which is different from the pub netmask of 255.255.255.0.

                                I ran the following:
                                srvctl modify nodeapps -n rachost1 -A 192.168.180.88/255.255.255.0/pub
                                srvctl modify nodeapps -n rachost2 -A 192.168.180.89/255.255.255.0/pub

                                I then stopped the services.

                                C:\oracle\product\10.2.0\crs\BIN>crs_stop -all
                                Attempting to stop `ora.rachost1.gsd` on member `rachost1`
                                Attempting to stop `ora.rachost1.ons` on member `rachost1`
                                Attempting to stop `ora.rachost2.gsd` on member `rachost2`
                                Attempting to stop `ora.rachost2.ons` on member `rachost2`
                                Stop of `ora.rachost1.gsd` on member `rachost1` succeeded.
                                Stop of `ora.rachost2.gsd` on member `rachost2` succeeded.
                                Stop of `ora.rachost1.ons` on member `rachost1` succeeded.
                                Stop of `ora.rachost2.ons` on member `rachost2` succeeded.

                                I restarted the services.

                                C:\oracle\product\10.2.0\crs\BIN>crs_start -all
                                Attempting to start `ora.rachost1.vip` on member `rachost1`
                                Attempting to start `ora.rachost2.vip` on member `rachost2`
                                Start of `ora.rachost1.vip` on member `rachost1` succeeded.
                                Start of `ora.rachost2.vip` on member `rachost2` succeeded.
                                Attempting to start `ora.rachost1.gsd` on member `rachost1`
                                Attempting to start `ora.rachost1.ons` on member `rachost1`
                                Attempting to start `ora.rachost2.gsd` on member `rachost2`
                                Attempting to start `ora.rachost2.ons` on member `rachost2`
                                Start of `ora.rachost2.gsd` on member `rachost2` succeeded.
                                Start of `ora.rachost1.gsd` on member `rachost1` succeeded.
                                Start of `ora.rachost1.ons` on member `rachost1` succeeded.
                                Start of `ora.rachost2.ons` on member `rachost2` succeeded.

                                I checked the status, and I noticed the changes "took".

                                C:\oracle\product\10.2.0\crs\BIN>crs_stat -p ora.rachost1.vip
                                NAME=ora.rachost1.vip
                                TYPE=application
                                ACTION_SCRIPT=C:\oracle\product\10.2.0\crs\bin\racgwrap.bat
                                ACTIVE_PLACEMENT=1
                                AUTO_START=1
                                CHECK_INTERVAL=60
                                DESCRIPTION=CRS application for VIP on a node
                                FAILOVER_DELAY=0
                                FAILURE_INTERVAL=0
                                FAILURE_THRESHOLD=0
                                HOSTING_MEMBERS=rachost1
                                OPTIONAL_RESOURCES=
                                PLACEMENT=favored
                                REQUIRED_RESOURCES=
                                RESTART_ATTEMPTS=0
                                SCRIPT_TIMEOUT=60
                                START_TIMEOUT=0
                                STOP_TIMEOUT=0
                                UPTIME_THRESHOLD=7d
                                USR_ORA_ALERT_NAME=
                                USR_ORA_CHECK_TIMEOUT=0
                                USR_ORA_CONNECT_STR=/ as sysdba
                                USR_ORA_DEBUG=0
                                USR_ORA_DISCONNECT=false
                                USR_ORA_FLAGS=
                                USR_ORA_IF=pub
                                USR_ORA_INST_NOT_SHUTDOWN=
                                USR_ORA_LANG=
                                USR_ORA_NETMASK=255.255.255.0
                                USR_ORA_OPEN_MODE=
                                USR_ORA_OPI=false
                                USR_ORA_PFILE=
                                USR_ORA_PRECONNECT=none
                                USR_ORA_SRV=
                                USR_ORA_START_TIMEOUT=0
                                USR_ORA_STOP_MODE=immediate
                                USR_ORA_STOP_TIMEOUT=0
                                USR_ORA_VIP=192.168.180.88


                                C:\oracle\product\10.2.0\crs\BIN>crs_stat -p ora.rachost2.vip
                                NAME=ora.rachost2.vip
                                TYPE=application
                                ACTION_SCRIPT=C:\oracle\product\10.2.0\crs\bin\racgwrap.bat
                                ACTIVE_PLACEMENT=1
                                AUTO_START=1
                                CHECK_INTERVAL=60
                                DESCRIPTION=CRS application for VIP on a node
                                FAILOVER_DELAY=0
                                FAILURE_INTERVAL=0
                                FAILURE_THRESHOLD=0
                                HOSTING_MEMBERS=rachost2
                                OPTIONAL_RESOURCES=
                                PLACEMENT=favored
                                REQUIRED_RESOURCES=
                                RESTART_ATTEMPTS=0
                                SCRIPT_TIMEOUT=60
                                START_TIMEOUT=0
                                STOP_TIMEOUT=0
                                UPTIME_THRESHOLD=7d
                                USR_ORA_ALERT_NAME=
                                USR_ORA_CHECK_TIMEOUT=0
                                USR_ORA_CONNECT_STR=/ as sysdba
                                USR_ORA_DEBUG=0
                                USR_ORA_DISCONNECT=false
                                USR_ORA_FLAGS=
                                USR_ORA_IF=pub
                                USR_ORA_INST_NOT_SHUTDOWN=
                                USR_ORA_LANG=
                                USR_ORA_NETMASK=255.255.255.0
                                USR_ORA_OPEN_MODE=
                                USR_ORA_OPI=false
                                USR_ORA_PFILE=
                                USR_ORA_PRECONNECT=none
                                USR_ORA_SRV=
                                USR_ORA_START_TIMEOUT=0
                                USR_ORA_STOP_MODE=immediate
                                USR_ORA_STOP_TIMEOUT=0
                                USR_ORA_VIP=192.168.180.89


                                Configuration Assistant
                                Virtual Private IP Configuration Assistant

                                I keep getting "OUI-25031"

                                I am not sure why this is not working.
                                • 13. Re: Oracle RAC server's IP and Subnetmask change
                                  743864
                                  Hi,

                                  You can change the IP later but you can not change the hostname of the system.
                                  You have to install CRS freah if you want to change the hostname of the system.
                                  Please let us know which IP you want to change.

                                  You can see the metalink Note.276434.1 for VIP or VIP hostname change.

                                  Regards,
                                  Naveen
                                  • 14. Re: Oracle RAC server's IP and Subnetmask change
                                    user10187253
                                    I want to post this out here while it is still fresh in my mind. I use this forum when looking for advice and maybe somebody will find this helpful.

                                    Regarding note ID 276434.1

                                    The section for Case III is not clear.

                                    When the subnet mask changes you need to calculate the subnet ID and depending on what the netmask is changing from you may NOT have to make the change to the subnet ID.

                                    Also the command oifcfg is used to change the subnet ID not the subnet mask. The subnet id is in the format of a range of IPs where the last octet is a 0. (i.e. 10.35.24.0)

                                    For example...

                                    I want to change the subnet mask from 255.255.254.0 -> 255.255.252.0. Do I need to make a change in the OCR file using oifcfg? The answer is NO. (the nodeapps is different, you do need to change that)

                                    If you calculate the subnet ID (using an online IP address calculator) when changing the subnet mask you will see that the subnet ID does not change.

                                    Also the syntax "% $CRS_HOME/bin/oifcfg/oifcfg delif -global <if_name>[<subnet>]" is incorrect. <subnet> is not the subnet mask it is the subnet ID. Maybe this is obvious to some people but not to me.

                                    In my case, since the netmask is going from .254 -> .252 (which fits inside the already existing range of IPs) the subnet ID does not have to change.