Tuesday, 29 April 2014

How to Configure a Second Listener on a Separate Network in 11.2 Grid Infrastructures

How to Configure a Second Listener on a Separate Network in 11.2 Grid Infrastructures


In Grid Infrastructure, a second back-end listener is required to give access to application developers and other operators. You may configure the same by following these steps.



Node1
1     localhost
127.0.0.1       localhost
#                                                                                                                                                                                                            
10.41.53.101    feDBSER101           feDBSER101.name.domain   loghost
10.49.53.101    feDBSER101-be        feDBSER101-be.name.domain
10.36.193.101   feDBSER101-bkp       feDBSER101-bkp.name.domain
192.168.53.101  feDBSER101-priv      feDBSER101-priv.name.domain
192.169.53.102  feDBSER101-priv1     feDBSER101-priv1.name.domain
                10.49.53.102    feDBSER101-be-vip       feDBSER101-vip.name.domain
#
# Partner Entries
10.41.53.106    feDBSER106           feDBSER106.name.domain
10.49.53.106    feDBSER106-be        feDBSER106-be.name.domain
10.36.193.106   feDBSER106-bkp       feDBSER106-bkp.name.domain
192.168.53.106  feDBSER106-priv      feDBSER106-priv.name.domain
192.169.53.107  feDBSER106-priv1     feDBSER101-priv1.name.domain
                10.49.53.107    feDBSER106-bevip       feDBSER106-vip.name.domain
#
# SCAN Entries
10.41.53.100    grid44h-scan            grid44h-scan.name.domain
10.41.53.105    grid44h-scan            grid44h-scan.name.domain
10.41.53.110    grid44h-scan            grid44h-scan.name.domain



Oifcfg iflist….this command can be use for checking the network entry…

#oifcfg iflist
More /etc/netmask

With root user.

grid/bin
./srvctl add network -k 2 -S 10.49.53.96/255.255.255.224/bge1

Then add vip resource for the 2nd network:
./srvctl add vip -n feDBSER101 -k 2 -A 10.49.53.102/255.255.255.224/bge1
./srvctl add vip -n feDBSER106 -k 2 -A 10.49.53.107/255.255.255.224/bge1



 Create a new RAC listener using 'netca'

As the grid user invoke "netca" from the 11.2 GRID_HOME, the select "Cluster configuration" -> "Listener configuration" -> "Add", enter Listener name as required.  For example: "LISTENER_BE".
On the next page, "Select Subnet",  the 2nd subnet will appear in the drop down list.

Create listner entries in tnsnames for node1
listener_net1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))
  )

listener_net2 =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.102)(PORT = 1555))
   )

remote_net2 =
   (DESCRIPTION_LIST =
     (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.102)(PORT = 1555)))
     (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.107)(PORT = 1555)))

  
Create listner entries in tnsnames for node2
listener_net1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))
  )

listener_net2 =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.107)(PORT = 1555))
   )

remote_net2 =
   (DESCRIPTION_LIST =
     (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.102)(PORT = 1555)))
     (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.49.53.107)(PORT = 1555)))

Then Run the command with sys user

alter system set LISTENER_NETWORKS='((NAME=network1)(LOCAL_LISTENER=listener_net1)(REMOTE_LISTENER=grid9h1-scan.k272.af:1521))','((NAME=network2)(LOCAL_LISTENER=listener_net2)(REMOTE_LISTENER=remote_net2))'


-----------------------------------------------------------------------------------

Visit www.ITWriteups.com for latest Android and IOS articles.