{"id":216,"date":"2011-11-21T17:59:28","date_gmt":"2011-11-21T16:59:28","guid":{"rendered":"https:\/\/www.carajandb.com\/2011\/11\/21\/changing-the-ip-addresses-in-a-rac-cluster-in-the-oracle-11g-release-2-11-2-0-3-en\/"},"modified":"2018-02-09T16:55:02","modified_gmt":"2018-02-09T15:55:02","slug":"changing-the-ip-addresses-in-a-rac-cluster-in-the-oracle-11g-release-2-11-2-0-3-en","status":"publish","type":"post","link":"https:\/\/carajandb.com\/en\/2011\/11\/21\/changing-the-ip-addresses-in-a-rac-cluster-in-the-oracle-11g-release-2-11-2-0-3-en\/","title":{"rendered":"Changing the IP Addresses in a RAC Cluster in the Oracle 11g Release 2 (11.2.0.3)"},"content":{"rendered":"

Due to moving into the new office I had to change several configurations in my infrastructure. Sure, the Linux and Windows systems were changed very quickly, the virtual machines did not cause any problems either. The switch of my RAC cluster then was a little bit more difficult, because it is not all done by changing the entries in the \/etc\/hosts, there is actually much more required.
\n
\nTo spare you this long lasting and hurtful experience, I stated the important steps for a successful switch in this article. I got great support for it from this article: http:\/\/zhefeng.wordpress.com\/2009\/02\/02\/change-ip-address-for-oracle-rac-public-and-vip-interfaces<\/a><\/p>\n

The base is my database RACVM1 on the cluster gallier with the nodes asterix and obelix (see my blog: “Oracle RAC 11.2.0.3 on VMware ESXi”<\/a>).<\/p>\n

The hosts file originally looked like this:<\/p>\n

\r\n# SCAN\r\n192.168.151.60 gallier.carajandb.com gallier\r\n# Public\r\n192.168.151.61 asterix.carajandb.com asterix\r\n192.168.151.62 obelix.carajandb.com obelix\r\n# VIP\r\n192.168.151.71 asterix-vip.carajandb.com asterix-vip\r\n192.168.151.72 obelix-vip.carajandb.com obelix-vip\r\n# Interconnect\r\n31.10.151.61   asterix-priv.carajandb.com asterix-priv\r\n31.10.151.62   obelix-priv.carajandb.com obelix-priv\r\n<\/pre>\n
Only the public IP addresses shall be changed from 192.168.151.x to 192.168.152.x . The private addresses for the interconnect are kept for now.<\/p>\n
Stop the Applications<\/h3>\n
Before we can start the switch, the database should be shut down first. When working RAC databases you should take care not to use the SQL*Plus for this, but only the command srvctl (even if it is not really telling).<\/p>\n
$ srvctl stop database -d RACVM1<\/pre>\n
Next all other applications (including the VIP addresses) on the nodes are stopped.<\/p>\n
$ srvctl stop nodeapps -n asterix \r\n$ srvctl stop nodeapps -n obelix<\/pre>\n
All applications but ASM and listener should be stopped by that. This can be checked by:<\/p>\n
\r\n$ crs_stat -t\r\nName           Type           Target    State     Host\r\n------------------------------------------------------------\r\nora.DATA.dg    ora....up.type ONLINE    ONLINE    asterix\r\nora....ER.lsnr ora....er.type ONLINE    OFFLINE\r\nora....N1.lsnr ora....er.type OFFLINE   OFFLINE\r\nora.asm        ora.asm.type   ONLINE    ONLINE    asterix\r\nora....SM1.asm application    ONLINE    ONLINE    asterix\r\nora....IX.lsnr application    ONLINE    OFFLINE\r\nora....rix.gsd application    OFFLINE   OFFLINE\r\nora....rix.ons application    OFFLINE   OFFLINE\r\nora....rix.vip ora....t1.type OFFLINE   OFFLINE\r\nora.cvu        ora.cvu.type   OFFLINE   OFFLINE\r\nora.gsd        ora.gsd.type   OFFLINE   OFFLINE\r\nora....network ora....rk.type OFFLINE   OFFLINE\r\nora....SM2.asm application    ONLINE    ONLINE    obelix\r\nora....IX.lsnr application    ONLINE    OFFLINE\r\nora.obelix.gsd application    OFFLINE   OFFLINE\r\nora.obelix.ons application    OFFLINE   OFFLINE\r\nora.obelix.vip ora....t1.type OFFLINE   OFFLINE\r\nora.oc4j       ora.oc4j.type  ONLINE    ONLINE    asterix\r\nora.ons        ora.ons.type   OFFLINE   OFFLINE\r\nora.racvm1.db  ora....se.type OFFLINE   OFFLINE\r\nora....rod.svc ora....ce.type OFFLINE   OFFLINE\r\nora....est.svc ora....ce.type OFFLINE   OFFLINE\r\nora....st1.svc ora....ce.type OFFLINE   OFFLINE\r\nora....st2.svc ora....ce.type OFFLINE   OFFLINE\r\nora....ry.acfs ora....fs.type ONLINE    ONLINE    asterix\r\nora.scan1.vip  ora....ip.type OFFLINE   OFFLINE\r\n<\/pre>\n
Who wants to be completely sure should now make a backup of OCR and voting disk. As there was not yet much to be damaged on my test database I skipped that.<\/p>\n
Change Addresses in the Oracle Configuration<\/h3>\n
Next you should have a look at the current configuration of the adapters (the command vipca does not exist anymore in 11.2 as it is now working with the SCAN address, strangely the file vipca still exists in the $ORACLE_HOME\/bin<\/samp>, though it is empty).<\/p>\n
\r\n$ oifcfg getif\r\neth1  31.10.151.0  global  cluster_interconnect\r\neth0  192.168.151.0  global  public\r\n<\/pre>\n
As I already mentioned the public IP addresses (i.e. asterix, obelix, asterix-vip and obelix-vip) shall be changed. Even though it cost me some negotiation, it actually works to first delete the entry for eth0 and recreate it then:<\/p>\n
$ oifcfg delif -global eth0 \r\n$ oifcfg setif -global eth0\/192.168.152.0:public<\/pre>\n
Now the VIP addresses have to be changed. Of course, after an appropriate check:<\/p>\n
\r\n$ srvctl config nodeapps -a\r\nNetwork exists: 1\/192.168.151.0\/255.255.255.0\/eth0, type static\r\nVIP exists: \/192.168.151.71\/192.168.151.71\/192.168.151.0\/255.255.255.0\/eth0, hosting node asterix\r\nVIP exists: \/192.168.151.72\/192.168.151.72\/192.168.151.0\/255.255.255.0\/eth0, hosting node obelix\r\n<\/pre>\n
… and now the change:<\/p>\n
# srvctl modify nodeapps -n asterix -A 192.168.152.0\/255.255.255.0\/eth0 \r\n# srvctl modify nodeapps -n obelix -A 192.168.152.0\/255.255.255.0\/eth0<\/pre>\n
… and the check, of course:<\/p>\n
\r\n# srvctl config nodeapps -a\r\nNetwork exists: 1\/192.168.152.0\/255.255.255.0\/eth0, type static\r\nVIP exists: \/192.168.152.71\/192.168.152.71\/192.168.152.0\/255.255.255.0\/eth0, hosting node asterix\r\nVIP exists: \/192.168.152.72\/192.168.152.72\/192.168.152.0\/255.255.255.0\/eth0, hosting node obelix\r\n<\/pre>\n
Change the configuration of the operating system.<\/p>\n
Now the\/etc\/hosts<\/samp>file can be modified accordingly, so that they look like this afterwards:<\/p>\n
\r\n# SCAN\r\n192.168.152.60 gallier.carajandb.com gallier\r\n# Public\r\n192.168.152.61 asterix.carajandb.com asterix\r\n192.168.152.62 obelix.carajandb.com obelix\r\n# VIP\r\n192.168.152.71 asterix-vip.carajandb.com asterix-vip\r\n192.168.152.72 obelix-vip.carajandb.com obelix-vip\r\n# Interconnect\r\n31.10.151.61   asterix-priv.carajandb.com asterix-priv\r\n31.10.151.62   obelix-priv.carajandb.com obelix-priv\r\n<\/pre>\n
The last change affects the Linux network settings. It is your choice to either use the toll network connections or to edit the entries in\/etc\/sysconfig\/network-scripts<\/samp>manually.<\/p>\n
This is the example of the entry inifcfg-eth0<\/samp>for asterix:<\/p>\n
\r\nTYPE=Ethernet\r\nBOOTPROTO=none\r\nIPADDR=192.168.152.61\r\nPREFIX=24\r\nGATEWAY=192.168.152.1\r\nDNS1=192.168.152.1\r\nDEFROUTE=yes\r\nIPV4_FAILURE_FATAL=yes\r\nIPV6INIT=no\r\nNAME=eth0\r\nUUID=d04279f7-dd5a-40fa-ace8-d50fd62f50d7\r\nONBOOT=yes\r\nHWADDR=00:0C:29:67:66:D5\r\n<\/pre>\n
When adjusting manually you additionally have to change the default gateway to\/etc\/sysconfig\/network<\/samp>.<\/p>\n
A good advice from the article also was to adjust the file known_host accordingly for the ssh connections between the systems.<\/p>\n
Restart with the new Configuration<\/h3>\n
Now, if you made the changes on the network manually, the network can be started completely on both systems once.<\/p>\n
# service network restart<\/pre>\n
Last but not least the crs daemon is stopped on both nodes and restarted afterwards.<\/p>\n
# crsctl stop crs \r\n# crsctl start crs<\/pre>\n
As a conclusion I would recommend to start completely once with machines to verify that the resources are being started again also after a reboot. As you stopped the database, you may in the end start it again \u2013 but please use the command srvctl!<\/p>\n
$ srvctl start database -d RACVM1<\/pre>\n
Besides that, good luck with you migration and I appreciate your comments.<\/p>\n","protected":false},"excerpt":{"rendered":"
Due to moving into the new office I had to change several configurations in my infrastructure. Sure, the Linux and Windows systems were changed very quickly, the virtual machines did not cause any problems either. The switch of my RAC cluster then was a little bit more difficult, because it is not all done by changing the entries in the \/etc\/hosts, there is actually much more required.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[],"tags":[22,23,434,73,75,74],"class_list":["post-216","post","type-post","status-publish","format-standard","hentry","tag-oracle","tag-oracle-11g","tag-rac-en","tag-rac","tag-real-application-clusters","tag-vmware"],"acf":{"occupation":"Write the Occupation of the Person","person_can-be-speaker":true,"person_is-team":true,"person_related-user-account":null,"person_ordering-number":50,"publication_speakers":null,"publication_content-language":["de"],"publication_files":null,"publication_event":"","publication_date":null},"spectra_custom_meta":{"_fgj2wp_old_id":["216"],"_yoast_wpseo_metadesc":["Cluster IP Addresses change in Oracle 11g"],"_yoast_wpseo_metakeywords":["Oracle 11g, RAC, Real Application Clusters"],"layout_show-author-box":["1"],"_layout_show-author-box":["field_5a64ee9cc6490"],"_edit_lock":["1518191827:3"],"_edit_last":["3"],"_vc_post_settings":["a:1:{s:10:\"vc_grid_id\";a:0:{}}"],"_yoast_wpseo_content_score":["90"],"layout_header":["light"],"_layout_header":["field_5a48111185e5f"],"layout_background":[""],"_layout_background":["field_5a481193c0995"],"layout_hide_services":["0"],"_layout_hide_services":["field_5a4811c5c0996"],"layout_show-categories-tags":["1"],"_layout_show-categories-tags":["field_5a64eee4c6491"],"blogpost_related-publications":[""],"_blogpost_related-publications":["field_5a480debdac62"],"blogpost_related-files":[""],"_blogpost_related-files":["field_5a480f377db29"],"_yoast_wpseo_primary_category":[""],"rank_math_primary_category":[""],"rank_math_description":["Cluster IP Addresses change in Oracle 11g"],"rank_math_news_sitemap_robots":["index"],"rank_math_robots":["a:1:{i:0;s:5:\"index\";}"],"astra_style_timestamp_css":["1773741462"],"rank_math_internal_links_processed":["1"],"wpil_sync_report3":["1"],"wpil_links_inbound_internal_count":["0"],"wpil_links_inbound_internal_count_data":["eJxLtDKwqq4FAAZPAf4="],"wpil_links_outbound_internal_count":["1"],"wpil_links_outbound_internal_count_data":["eJx1kUFrGzEQhf\/KokJuWq\/ktE7GmFJKD4WmhRbS3sR4NWSVaCWh1cYuIf+9o7Vb0kMuQnq8p\/lmBkHBk4Nu+w3UWxA\/k\/PmJlry5osLDwLUGp4m2IDw\/DTOim01T7AGMWcv+KY270AMpSRYrTJ5nEM\/6E5ftj1mvMdg920fx5ULlo5tGtL7mIqLYcei6WMoFMoFjmn76Oiww1xc72kRnN3p7hpiRlYkn1IpqWUn1zIG+TgeMJOk6egkhSXQY6mZDdzHAUOgSeKQKdjpr+FzoZEdatNV8EvGjlOpV80tvM5eHVcgHLPmgNz0HtQpn5b8V37wB8jhmJefNYiLN1da81gX+ub7h4+NUq1uu3bdxNDc3lT65tOPX04sQ+TZo7Vkzf63SX6+c6GW6U6VfaytxVCdvIrz1Bbw7ryZw+CmRNn0mbDQvzUpxdyTwbnEanspFyZ7cOHuxVKrPEY7ezL\/ufW5yFL4WE768\/Mf9oK5zA=="],"wpil_links_outbound_external_count":["1"],"wpil_links_outbound_external_count_data":["eJy9UctuAyEM\/BfuZB\/pK84v9HHsERFwdq0QQMA2baP8e80mrVKp50oI2WZGM4w1dHAkaNcv0N2CeI3k1FOw6NQj+Z2AbgnHDPcgHLeKrFhXcIYliCk5wdXqAcRYSoSm+Rxxi35YHEKyMWHOCxP2Td+2q6bt6zGj9gNKilJbWwFyG5IMSRuHkm8Zp40jI7W38o1R5AumrTaYq9INC4Vcatl3IP5Uq49saCZ6zQY3s12mxpn6zM0dCO3NGNL\/2q\/5Mg+t2nyo6KaB\/Lc99uCC0YWCr0iO2wTm+vNf20v6h5FyxKRMQl3wZxUdZ0FZ6amECrseFza1Iz9cLa6O98FODtUvdH8RmYXfy3l+On0Bx5m1Rw=="],"wpil_sync_report2_time":["2024-08-27T11:47:31+00:00"],"copied_media_ids":["a:0:{}"],"referenced_media_ids":["a:0:{}"],"_uag_css_file_name":["uag-css-216.css"]},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Johannes Ahrends","author_link":"https:\/\/carajandb.com\/en\/author\/9aa6cdb2095bd409\/"},"uagb_comment_info":2,"uagb_excerpt":"Due to moving into the new office I had to change several configurations in my infrastructure. Sure, the Linux and Windows systems were changed very quickly, the virtual machines did not cause any problems either. The switch of my RAC cluster then was a little bit more difficult, because it is not all done by…","_links":{"self":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/comments?post=216"}],"version-history":[{"count":0,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/posts\/216\/revisions"}],"wp:attachment":[{"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/media?parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/categories?post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/carajandb.com\/en\/wp-json\/wp\/v2\/tags?post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}