Questions re LOCAL_LISTENER & REMOTE

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Thu, 15 Nov 2007 16:52:22 -0800
Message-ID: <FE043305B38A0F448F3924429D650C2A053B4DFB@VEXBE2.ex.ad3.ucdavis.edu>

Greetings,

I am still trying to get my head around this issue of LOCAL_LISTENER & REMOTE_LISTENER parameters. I am running a two node RAC cluster on RHEL4, Oracle 10.2.0.3.0 EE. ASM and DBMS are installed in separate oracle homes and the listener is running out of the $ASM_HOME. When pointing at the DBMS instance on each node show parameter listener returns the following...

SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
local_listener                       string      (ADDRESS = (PROTOCOL =
TCP)(HO
                                                 ST =
brownshoe-vip.ucdavis.edu
                                                  )(PORT = 1521 ))
remote_listener                      string      LISTENERS_MOTHRA

On each node local_listener points to brownshoe-vip. The name of the second node is tenspeed (remember, old detectives?) and so I think on that node it should *instead* look like this...

SQL> show parameter listener

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
local_listener                       string      (ADDRESS = (PROTOCOL =
TCP)(HO
                                                 ST =
tenspeed-vip.ucdavis.edu
                                                  )(PORT = 1521 ))
remote_listener                      string      LISTENERS_MOTHRA

The tnsnames.ora on each machine looks like this...

# tnsnames.ora Network Configuration File: /opt/pkg/oracle/product/10.2.0/dbms/network/admin/tnsnames.ora # Generated by Oracle configuration tools.

LISTENERS_MOTHRA =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brownshoe-vip.ucdavis.edu)(PORT =
1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = tenspeed-vip.ucdavis.edu)(PORT =
1521))
)

MOTHRA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = brownshoe-vip.ucdavis.edu)(PORT =
1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = tenspeed-vip.ucdavis.edu)(PORT =
1521))

(LOAD_BALANCE = yes)
(CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = mothra.ucdavis.edu)

)
)

MOTHR2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tenspeed-vip.ucdavis.edu)(PORT =
1521))

(CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = mothra.ucdavis.edu)
      (INSTANCE_NAME = mothr2)

)
)

MOTHR1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = brownshoe-vip.ucdavis.edu)(PORT =
1521))

(CONNECT_DATA =

      (SERVER = SHARED)
      (SERVICE_NAME = mothra.ucdavis.edu)
      (INSTANCE_NAME = mothr1)

)
)

The issue I am seeing is that the majority of connections are going to node 1 (brownshoe) and I think this has something to do with it but I'm still puzzled. Oracle is also telling me that I should change the tnsnames.ora so it looks like this on node 1...

LOCAL_LISTENER_BROWNSHOE =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = brownshoe-vip.ucdavis.edu)(PORT =
1521))
  )
REMOTE_LISTENER_BROWNSHOE =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = tenspeed-vip.ucdavis.edu)(PORT =
1521))
  )

And the mirror image on node 2. This is puzzling to me as the tnsnames.ora listed in example 9.1 of the Real Application Clusters Installation guide looks like the one I currently have. I think my lack of understanding has to do with how the local and remote listener parameters function so if someone could help me in my understanding I would be most grateful.

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 15 2007 - 18:52:22 CST

Questions re LOCAL_LISTENER & REMOTE_LISTENER