Skip to main content

Change Cluster Interconnect & IP Address in 11gR2 RAC

Change Cluster Interconnect Adapter  & IP Address in 11gR2 RAC


We can change it at any stage, it require full outage.
Step 1: Determine private IP address
[oracle@Jayesh1 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  10.0.0.0  global  cluster_interconnect

Step 2: Determine Ethernet card name
[oracle@Jayesh1 ~]$ oifcfg iflist
eth0  192.168.1.0
eth1  10.0.0.0

Step 3: Add new interface Subnet ID specification:
[oracle@Jayesh1 ~]$ oifcfg setif -global eth1/175.16.0.0:cluster_interconnect

Step 4 : Verify the changes:
[oracle@Jayesh1 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  10.0.0.0  global  cluster_interconnect
eth1  175.16.0.0  global  cluster_interconnect

Step 5: Stop cluster on all node:
[oracle@Jayesh1 ~]# sudo /u01/app/11.2.0/grid/bin/crsctl stop cluster -all

Step 6: Modify netwrok address on network adapter of each box:
[root@Jayesh1 ~]# ifconfig eth1 175.16.0.10 netmask 255.255.0.0 broadcast 175.16.255.255
[root@Jayesh2 ~]# ifconfig eth1 175.16.0.11 netmask 255.255.0.0 broadcast 175.16.255.255

Step 7: Modify /etc/hosts file on each node.

Delete entry of old private interconnect and add new private interconnect on each node.
[root@Jayesh1 ~]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1    localhost.localdomain    localhost

#10.10.10.105    Jayesh1-priv.localdomain    Jayesh1-priv
175.16.0.10    Jayesh1-priv.localdomain    Jayesh1-priv

#10.10.10.107    Jayesh2-priv.localdomain  Jayesh2-priv
175.16.0.11    Jayesh2-priv.localdomain  Jayesh2-priv

Step 8: Start cluster on each node
[root@Jayesh1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -all

Step 9: Delete old entry of private interconnect from cluster registry
[oracle@Jayesh1 ~]$ oifcfg delif -global eth1/10.0.0.0:cluster_interconnect

Step 10: Verify the changes:
[oracle@Jayesh1 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  175.16.0.0  global  cluster_interconnect

You can also verify:
[root@Jayesh1 ~]# ifconfig eth1

Comments

Popular posts from this blog

Hard dependency with ip address Oracle RAC Cluster.

Command error out due to hard dependency with ip address [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource RDBMS_DB -n Node2 CRS-2527: Unable to start 'RDBMS_DB' because it has a 'hard' dependency on 'sDB' CRS-2525: All instances of the resource 'sDB' are already running; relocate is not allowed because the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource sDB  -n Node2 CRS-2529: Unable to act on 'DB' because that would require stopping or relocating 'LISTENER_DB', but the force option was not specified CRS-4000: Command Relocate failed, or completed with errors. [-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate resource LISTENER_DB  -n Node2 CRS-2527: Unable to start 'LISTENER_DB' because it has a 'hard' dependency on 'sD...

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...