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. If you want a babe from the house ofcall girls in jaipurthere are a few things you should know well before making a booking. Firstly our agency here at your city. In simple words is a cut above the rest because of the highly professional services we provide to our clients. Check our other Services...
    russian call girls in jaipur
    housewife call girls in jaipur
    housewife escorts in jaipur
    female escorts in jaipur
    female escorts in agra
    call girls in agra
    escorts service in agra
    hi profile escorts in agra
    russian escorts in agra

  6. We have calls available in the best of categories, according to our need, we are waiting for you, erotic and beautiful call girls in Guwahati, escort
    service Guwahati, you can come on our website and contact us 24x7 hours anytime in Guwahati. I look forward.
    Guwahati Escort Service
    Guwahati Escorts

  7. If you are frustrated in your life and looking for some changes, then it's high time.
    Make a plan and travel to Guwahati escort and choose here Guwahati call girl service.
    It will remove your tension from life and make your life smooth.
    Assamese call girls in Guwahati
    College escorts in Guwahati
    Housewife escorts in Guwahati
    Nepali escorts in Guwahati
    Escort services in Guwahati
    Guwahati escort service

  8. Guwahati Escorts or call girls in Guwahati are those call girl who are rocking and
    amazing in terms of better-quality sexual performance for the customer.
    Escorts in Guwahati
    Call Girls in Guwahati

  9. Порно онлайн на сайте Домашнее порно бесплатно и Порно азиатки