3 Replies Latest reply: Jul 11, 2013 7:17 AM by PrafullaNath RSS

    RAC 11gr2 Local Listener Question

    1007103
      Hi All,

      We have installed 11gr2 RAC 2-node database with SCAN Listeners.

      On the RDBMS database part, what would be the setting of the listener.ora for local listener. (i.e. database specific listener with port 1525)
      Scan listener is running on 1521. We have tweaked the default listener.ora file like below as we have multiple databse on same node/cluster.

      Our current Settings:

      Local Listener Name : LISTENER_ORAFUS runing on port 1525. Contents of listener.ora

      LISTENER_ORAFUS =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dcstl-trac-20-vip )(PORT = 1523))
      )
      )
      SID_LIST_LISTENER_ORAFUS =
      (SID_LIST =
      (SID_DESC =
      (ORACLE_HOME= /u01/app/oracle/product/rdbms_11202/11.2.0)
      (SID_NAME = ORAFUS1)
      )
      )



      -bash-3.2$ lsnrctl status LISTENER_orafus
      LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 04-MAY-2013 08:57:25
      Copyright (c) 1991, 2010, Oracle. All rights reserved.
      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dcstl-trac-20-vip)(PORT=1523)))
      STATUS of the LISTENER
      ------------------------
      Alias LISTENER_orafus
      Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      Start Date 16-APR-2013 11:38:10
      Uptime 17 days 21 hr. 19 min. 15 sec
      Trace Level off
      Security ON: Local OS Authentication
      SNMP OFF
      Listener Parameter File /u01/app/oracle/product/rdbms_11202/11.2.0/network/admin/listener.ora
      Listener Log File /u01/app/oracle/product/rdbms_11202/diag/tnslsnr/dcstl-trac-20/listener_orafus/alert/log.xml
      Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.185.104)(PORT=1523)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.1.184.190)(PORT=1523)))
      Services Summary...
      Service "orafus" has 1 instance(s).
      Instance "orafus1", status READY, has 1 handler(s) for this service...
      Service "orafus1" has 1 instance(s).
      Instance "orafus1", status UNKNOWN, has 1 handler(s) for this service...
      Service "orafusXDB" has 1 instance(s).
      Instance "orafus1", status READY, has 1 handler(s) for this service...
      The command completed successfully


      On database:

      local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dcstl-trac-20-vip)(PORT=1523))))
      remote_listener string dcstl-trac-scan.lac1.biz:1521

      Can somebody help me if this is the correct settings.

      Regards,
      Pdev
        • 1. Re: RAC 11gr2 Local Listener Question
          Mihael
          We have installed 11gr2 RAC 2-node database with SCAN Listeners.

          On the RDBMS database part, what would be the setting of the listener.ora for local listener. (i.e. database specific listener with port 1525)
          Local listeners are also part of GI and should be configured with srvctl.
          • 2. Re: RAC 11gr2 Local Listener Question
            rarain
            Hi,

            Listener settings seems fine.

            Explanation:-
            In RAC there are two parameters which are basically related with dynamic service registration with Listener. One is LOCAL_LISTENER which is used by PMON to register the database services locally and another is REMOTE_LISTENER which is used to register database services remotely i.e. Listener running on other nodes.

            In your case you have configured a new listener LISTENER_ORAFUS at port 1525 and you have also updated LOCAL_LISTENER parameter so that PMON will now register the database services locally with LISTENER_ORAFUS.

            Thanks
            • 3. Re: RAC 11gr2 Local Listener Question
              PrafullaNath

              In an 11gR2 RAC environment set the LOCAL and REMOTE listener as below.

               

              LOCAL_LISTENER

              alter system set local_listener='VIP_NODE1:1521' scope=both sid='SID_NODE1';

               

              alter system set local_listener='VIP_NODE2:1521' scope=both sid='SID_NODE2';

               

              .....

              .....

               

              REMOTE_LISTENER

               

              alter system set remote_listener='SCAN:1521' scope=both sid='*';