Wednesday, June 30, 2010

Modifying the VIP Address or VIP Hostname in Oracle RAC Node

Oracle 10g or 11g uses Virtual IP address (VIP) in clustered environment for clients to connect to the database. During the installation of Oracle Clusterware users are prompted to enter VIP and VIP hostname for each node in the cluster. The VIP is a static IP with a hostname defined and also resolved through DNS.

The VIP information is stored in OCR (Oracle Cluster Registry) and also in different HA framework. Changing the VIP Address or VIP Hostname involves modification of the nodeapps, which includes the VIP,GSD, Listener, and ONS(Oracle Notification Services).The VIP can be changed while the nodeapps are running, but the changes will take effect only when nodeapps are restated.

Note that stopping nodeapps may cause other resources to be stopped for ex: - ASM, instance or database, so the change should be made during scheduled outage.

Follow the steps to change the VIP address or VIP hostname.

Step 1:- Check the original configuration before change
$ srvctl config nodeapps -n -a
Using '-a' will give you the current VIP hostname, VIP address and interface

# srvctl config nodeapps -n testrac01 -a
VIP exists.: /testrac01-vip/

The VIP Hostname is 'testrac01-vip’
The VIP IP address is ''
The VIP subnet mask is ''
The Interface Name used by the VIP is called 'eth0'

Step 2:- Stop Instance,ASM,Nodeapps resources
$srvctl stop instance -d testdb -i tetdb1
$srvctl stop asm -n testrac01
$srvctl stop nodeapps -n testrac01

Step 3:- Verify the VIP Address is no longer running by using below command
$ifconfig -a

You can also check the resources status using crs_stat command.

Step 4:- Update /etc/hosts file with new VIP Address or VIP hostname on node1 and also update DNS to associate the new IP address with VIP hostname as per /etc/hosts file.

Step 5:- Modify VIP Address or VIP hostname on nodeapps by using srvctl command (Run as root)
#srvctl modify nodeapps -n [-o ] [-A ]
-n < node_name> - Node name.
-o - Oracle Home for the cluster software (CRS-Home).
-A The node level VIP address (/netmask[/if1[|if2|...]]).

Example:- Modify the VIP Address to
#srvctl modify nodeapps -n testrac01 -A

Use below command to change to change VIP address using VIP hostname.The srvctl command will resolve the IP to hostname or the hostname to IP address. You can use the same command to change the VIP hostname from ”testrac01-vip” to “testrac01-v”

#srvctl modify nodeapps -n testrac01 -A testrac01-v/

Step 6:- Verify the change by running below command
$srvctl config nodeapps -n testrac01 –a

Step7:- Start all resources
$srvct start nodeapps -n testrac01
$srvctl start asm -n testrac01
$srvctl start instance -d testdb –i testdb1

Step8:- Repeat the same steps on all remaining nodes in the cluster.

Satishbabu Gunukula


  1. • Thanks for your post! Through your pen I found the problem up interesting! I believe there are many other people who are interested in them just like me! How long does it take to complete this article? I have read through other blogs, but they are cumbersome and confusing. I hope you continue to have such quality articles to share with everyone!* sign in

  2. Candidates who want to apply for JEE Main 2020 must check the eligibility criteria first and then the last date to apply. The closing date to apply for January session is in the month of October while for April session is in the month of March.

  3. من افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل اقوى شركات مكافحة الحشرات بجدة تقدم خدمات تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة

  4. من افضل واقوى الشركات التي تقدم خدمات مكافحة حشرات المنزل البق والصراصير والنمل والعته تلك التي تستخدم مبيدات آمنة وفعالة ومضمونة مثل اقوى شركات مكافحة الحشرات بجدة تقدم خدمات تتعامل في مكافحة الحشرات وتستخدم مبيدات آمنة ومضمونة
    وقد تجدنا في مدينة الطائف التابعة لإمارة مكة المكرمة تحت مسمى شركة مكافحة حشرات بالطائف لديها امكانيات كبيرة في مكافحة الحشرات المنزلية والقضاء على الحشرات
    وفي مدينة جدة عمدنا الى توفير خدمات جيدة في اعمال مكافحة الحشرات بجدة فقمنا بتوفير خدمات شركة مكافحة حشرات بجدة بأيدي فنيين مهرة وعمالة مدربة لكي نضمن سلامة الأعمال في المنازل

  5. تلك الشركات التي تستخدم سيارات مجهزة ومبطنة من الداخل لكي يتم نقل العفش في امان تام بدون خدوش او تكسير مثل الشركات التالية
    شركه نقل عفش بجده
    شركه نقل عفش بمكه
    شركه نقل عفش بالطائف
    وفي منطقة المدينة المنورة تجدنا نمتلك افضل شركات نقل الاثاث مع الفك والتركيب وكذلك في ينبع وينبع البحر مثال عن تلك الشركات
    شركه نقل عفش بالمدينه المنوره
    شركه نقل عفش بينبع
    وفي المنطقة الوسطي نقدم خدمات نقل العفش مع الفك والتركيب والتغليف ويتم النقل في سيارات مجهزة ومؤمنة لتحميل العفش وتفادي التلفيات في الرياض والقصيم والخرج مثل
    - شركات نقل عفش بالرياض
    - شركات نقل عفش بالقصيم
    - شركات نقل عفش بالخرج

  6. If you are looking to know which are the best video games to buy in an Xbox 360 sale, and you want to know when and where to find them, then this article will explain it to you. This will help you know how get a good deal on Xbox 360 video games and save you money.

  7. I had read this question many times on different forums- "The videos on YouTube starts skipping. How do I speed up YouTube?" I am going to share some tweaks and tricks that will help you speed up YouTube without much hard work.

  8. Today, website owners and web developers are realizing the importance of SEO training courses. The truth is, if you want to drive more traffic to your website, you need to learn how to properly optimize your site. In order to do this, you must be fully equipped with the latest SEO techniques and information that will guide you along the way.

  9. While many are limited to the world of console gaming, PC games brings a new level of gaming experience. It can be a bit more work initially, but the rewards are well worth it. Here are some guidelines for buying PC games.

  10. Considering the variety of different games available to us, let alone the type of games; flash, Internet, computer, video game, it's really hard to be able to say what makes a good game a good game. However, no matter how hard of a question this is, many people are still asking it.

  11. There’s an art to DMCA ignored hosting. The best ones know exactly how to avoid the takedown notices, lawyering their way around and making the bureaucracy and red tape work in your favor.