This discussion is archived
14 Replies Latest reply: Oct 23, 2012 5:33 AM by user10187253 RSS

Oracle RAC server's IP and Subnetmask change

178210 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    I think ML 283684.1 should help you.

    thanks
  • 4. Re: Oracle RAC server's IP and Subnetmask change
    178210 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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
    427906 Explorer
    Currently Being Moderated
    also need to run emca for the amended em config as well ?
  • 7. Re: Oracle RAC server's IP and Subnetmask change
    178210 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks for your reply
  • 10. Re: Oracle RAC server's IP and Subnetmask change
    445103 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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.