6 Replies Latest reply: Nov 8, 2012 9:21 AM by User447797-OC RSS

    Static Listener

    User447797-OC
      Oracle RDBMS 11.2.0.2 RAC, Host RHEL 5.6

      While creting physical standby using Duplicate from Active databse, it is necessary to use static listener configuration, and it is RAC so need to have static listeners configured for SCAn also

      1)Why do we need to use the static listener?
      2)I have a 3 node primary , 3 node standby, do i need to add static listener on all the 3 nodes on primary and standby? If so, why do i need to add on primary nodes, and on all standby nodes.
      Because standby is built by connecting to only one primary instance and one auxiliary instance,so it is ok to add static listeners only on just one auxiliary node righr? or am i missing something?



      Thanks
        • 1. Re: Static Listener
          mseberg
          Hello;
          1)Why do we need to use the static listener?
          The static listener is needed for the RMAN connection later. Since there is no database to connect to RMAN uses it.

          So the extra entry for the clone database is needed because otherwise RMAN has nothing to connect to.

          You also need an entry for the CLONE in your TNSNAMES.ORA on both servers.

          I also add these : ( To prevent timeouts )

          To listener.ora
          INBOUND_CONNECT_TIMEOUT_ = 120

          To sqlnet.ora
          SQLNET.INBOUND_CONNECT_TIMEOUT = 120


          Then stop and start the listener.


          For question two I don't know the answer as I have never done that setup. That said you don't need it on the Primary nodes. Adding to all Standby nodes is harmless.

          Best Regards

          mseberg
          • 2. Re: Static Listener
            User447797-OC
            I didn't get the line: You also need an entry for the CLONE in your TNSNAMES.ORA on both servers

            u mean to have entries of CLONE database in primary and standby tnsnames.ora file or anything particular of static listener entry that i should have in both primary,clone
            • 3. Re: Static Listener
              mseberg
              OK.

              So for active duplicate you want an entries for the new duplicate in the source and destination. The process needs these because it does not just talk one way.

              So update tnsnames.ora on primary and standby systems. If the Primary was Chicago and the Standby was Boston make sure you have entries for both Chicago and Boston on both servers in the tnsnames.ora

              Best Regards

              mseberg
              • 4. Re: Static Listener
                User447797-OC
                Can anyone help me...

                Do we need to have static listener for all nosed on standby and do we need to have static entry for SCAN also???
                • 5. Re: Static Listener
                  mseberg
                  Hello;

                  It occurs to me for RAC this has to be a requirement cluster-network nodes.


                  I'm having trouble finding the exact document but "Update Network Configuration Files" in the White Paper "Rapid Oracle RAC Standby Deployment: Oracle Database 11g Release 2"

                  States :
                  At this point there are two similarly configured but different Oracle RAC databases, each in the primary role. Before creating the standby database, update the network configuration files on all systems to ensure proper client access to both databases and to create the static service entries used by the Oracle Data Guard observer and broker command line utility, DGMGRL.
                  The problem is I cannot find a quote where "Broker" is not in the picture.

                  There is also a "Listener.ora Files" section to this document which supports this.

                  A search of "static" that document may provide your answer.

                  http://www.oracle.com/technetwork/database/features/availability/dataguard11g-bestpractices-161724.html

                  Best Regards

                  mseberg

                  Edited by: mseberg on Aug 30, 2012 2:32 PM
                  • 6. Re: Static Listener
                    User447797-OC
                    Thanks for the help