RAC: CHANGE IP OF CLUSTER INTERCONNECT

17.04.2015
by Kamil Stawiarski

In this article I will show how to change IP address of cluster interconnect.

First we have to define new address of the cluster interconnect before we change network settings.

[root@lodzio ~]# oifcfg setif -global eth1/10.1.0.0:cluster_interconnect

And now stop all cluster resources on both nodes

[root@lodzio ~]# crsctl stop res -all

(...)

[root@lodzio ~]# crsctl stop res -all -init

(...)

[root@lodzio ~]# ssh miodzio 
root@miodzio's password: 
Last login: Fri Apr 17 10:58:04 2015 from 192.168.56.1
[root@miodzio ~]# . oraenv 
ORACLE_SID = [root] ? +ASM2
The Oracle base has been set to /u01/app/oracle
[root@miodzio ~]# crsctl stop res -all -init

Now we can change cluster interconnect ips

[root@lodzio ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth1 
[root@lodzio ~]# ifdown eth1
[root@lodzio ~]# ifup eth1
[root@lodzio ~]# ifconfig eth1
eth1      Link encap:Ethernet  HWaddr 08:00:27:7A:3D:9B  
          inet addr:10.1.0.1  Bcast:10.1.0.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe7a:3d9b/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:225558 errors:0 dropped:0 overruns:0 frame:0
          TX packets:210124 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:152730046 (145.6 MiB)  TX bytes:129642749 (123.6 MiB)
[root@lodzio ~]# ssh miodzio
root@miodzio's password: 
Last login: Fri Apr 17 12:15:40 2015 from lodzio
[root@miodzio ~]# vim /etc/sysconfig/network-scripts/ifcfg-eth1 
[root@miodzio ~]# ifup eth1
[root@miodzio ~]# ifconfig eth1
eth1      Link encap:Ethernet  HWaddr 08:00:27:42:F0:03  
          inet addr:10.1.0.2  Bcast:10.1.0.255  Mask:255.255.255.0
          inet6 addr: fe80::a00:27ff:fe42:f003/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:210059 errors:0 dropped:0 overruns:0 frame:0
          TX packets:225581 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:129641886 (123.6 MiB)  TX bytes:152723224 (145.6 MiB)

Now we can start init cluster resources on both nodes

[root@lodzio ~]# crsctl start res -all -init

(...)

[root@lodzio ~]# crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       lodzio                   Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       lodzio                                       
ora.crf
      1        ONLINE  ONLINE       lodzio                                       
ora.crsd
      1        ONLINE  ONLINE       lodzio                                       
ora.cssd
      1        ONLINE  ONLINE       lodzio                                       
ora.cssdmonitor
      1        ONLINE  ONLINE       lodzio                                       
ora.ctssd
      1        ONLINE  ONLINE       lodzio                   OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       lodzio                                       
ora.gipcd
      1        ONLINE  ONLINE       lodzio                                       
ora.gpnpd
      1        ONLINE  ONLINE       lodzio                                       
ora.mdnsd
      1        ONLINE  ONLINE       lodzio

[root@lodzio ~]# ssh miodzio
root@miodzio's password: 
Last login: Fri Apr 17 12:19:46 2015 from lodzio
[root@miodzio ~]# . oraenv
ORACLE_SID = [root] ? +ASM2
The Oracle base has been set to /u01/app/oracle
[root@miodzio ~]# crsctl start res -all -init

(...)

[root@miodzio ~]# crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
      1        ONLINE  ONLINE       miodzio                  Started             
ora.cluster_interconnect.haip
      1        ONLINE  ONLINE       miodzio                                      
ora.crf
      1        ONLINE  ONLINE       miodzio                                      
ora.crsd
      1        ONLINE  ONLINE       miodzio                                      
ora.cssd
      1        ONLINE  ONLINE       miodzio                                      
ora.cssdmonitor
      1        ONLINE  ONLINE       miodzio                                      
ora.ctssd
      1        ONLINE  ONLINE       miodzio                  OBSERVER            
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       miodzio                                      
ora.gipcd
      1        ONLINE  ONLINE       miodzio                                      
ora.gpnpd
      1        ONLINE  ONLINE       miodzio                                      
ora.mdnsd
      1        ONLINE  ONLINE       miodzio

And now I can remove old interconnect definition from cluster metadata:

[root@miodzio ~]# oifcfg getif
eth1  10.0.0.0  global  cluster_interconnect
eth0  192.168.56.0  global  public
eth1  10.1.0.0  global  cluster_interconnect
[root@miodzio ~]# oifcfg delif -global eth1/10.0.0.0
[root@miodzio ~]# oifcfg getif
eth0  192.168.56.0  global  public
eth1  10.1.0.0  global  cluster_interconnect

OK. Nothing left to do, but starting all cluster resources 🙂

Search:

Category:
choose
All categories 12c Exadata GO internals konferencje Oracle RAC RMAN RUST security tips&tricks tuning

Popular posts

14.06.2016
ORACLE RAC 12c: restore OCR and VOTEDISK

Let’s fuckup the cluster! Of course after this operation, the final state of the processes can look like this: The cssd service will not be able to start, because there are no voting disks: OK, so let’s try to stop the cluster services: Now we will have to start CRS in exclusive mode and start […]

Read more
10.02.2016
How to list files from directory using external table in 12c

I’ve wrote about privilege escalation with external tables in this post: https://blog.ora-600.pl/2014/12/23/simple-technics-of-privilege-escalation-part2-dbasysdba/ This time we will try to list all files within directory object, to which we have no EXECUTE privs. This is possible due to great new feature of database 12c that allows to use metacharacters to match multiple files in external table. I […]

Read more
28.05.2017
How to recover a dropped package from archivelogs – based on research for VOODOO engine

Sorry for long time without post, but we are writing with Marcin Rydz a new heterogenous replication product based on archivelogs and it’s consuming a looooooot of our time 🙂 Yes I know it’s nothing new on the market. There are other cool products and I know they’ll be probably be better. But we want […]

Read more
03.05.2015
12c: Spatial Vector Acceleration

There is a new feature in Oracle Spatial 12c, called "Spatial Vector Acceleration". According to Oracle: One of the most notable improvements with Oracle Spatial and Graph 12c can be seen in performance increases in vector data operations. Enabling the Spatial Vector Acceleration feature (available with the Spatial option) dramatically improves the performance of commonly […]

Read more
01.02.2017
back to the basics: ALTER TABLE MOVE vs SHRINK

It’s time for the next article with ODBV visualisation 🙂 This time let’s examine the difference between move and shrink – this is very common question on a lot of trainings. You can find a lot of great articles in the Internet regarding this subject but I think that visualisation really helps to understand what […]

Read more
30.12.2016
back to the basics: truncate table reuse storage vs drop storage

From time to time I get questions on my trainings, what is the difference between TRUNCATE TABLE and TRUNCATE TABLE DROP STORAGE… well, there is no difference because DROP STORAGE is default 😉 DROP STORAGE Specify DROP STORAGE to deallocate all space from the deleted rows from the table except the space allocated by the […]

Read more
28.10.2017
Visualize your STATSPACK reports with Python Plotly

If you work as a consultant, getting remote access to your customer is sometimes a nightmare! Even when you’ll get one, there a times when you just want to get your job done and finish this nightmare. For example, there are times when it is easier to dump a statspack repo and do offline analyzes. […]

Read more
08.02.2016
Sparc M7 vs Intel and P8

I had a pleasure to work with my colleagues from Oracle – Radosław Kut and Krzysztof Marciniak – at comparing the performance of In-Memory queries between Sparc M7, Intel® Xeon® X5670 and Intel® Xeon® E5-2699. You can find results of our findings in this presentation: https://www.oracle.com/webfolder/s/delivery_production/docs/FY16h1/doc17/DB12c-on-SPARC-M7.pdf Following their methodology I’d like to present appropriate results […]

Read more
29.10.2015
Oracle 12c: PRAGMA UDF – the truth

Let’s check, why PRAGMA UDF makes execution faster, then regular function. C function responsible for calling a PL/SQL code from SQL is called "plsql_run": Now let’s try to create a new HR session and create a simple function which will multiple values by 2: From other terminal I will connect to the HR session with […]

Read more
12.03.2017
ODBV improvements

Thanks to suggestions made by Frits Hoogland, I made some improvements to the ODBV. The new version can be found here: http://ora-600.pl/oinstall/odbv.x86_64 The changes are: Recognition of first, second and third level bitmap block Recognition of pagetable segment header Block number ranges on the left side The blocks will be coloured properly to belonging segment. […]

Read more
03.11.2016
Oracle Database Block Visualizer

Recently I wanted to demonstrate to some people on my training, how Oracle database maintains blocks in a datafile – what happens after truncate, truncate with drop storage clause, delete, regular insert, direct path insert and so on… I didn’t find any tool for that so I’ve written my own. It’s core code is based […]

Read more
09.01.2020
The curious case of enq: TX – row lock contention

So we had a doubtful pleasure of migrating a few databases from Oracle Exadata X3-2 to Oracle Exadata X7-2 Cloud at Customer. Why doubtful? Well, this a material for a whole different story with a lot of beer – let me just say, that CC gen 1 was a bit rough around the edges 😉 […]

Read more

Contact us

Database Whisperers sp. z o. o. sp. k.
al. Jerozolimskie 200, 3rd floor, room 342
02-486 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 661 966 009
info@ora-600.pl

Newsletter Sign up to be updated