5 Replies Latest reply: Jun 27, 2011 6:17 AM by EdStevens RSS

    add another listener entry

    user13681259
      In oracle 11g, we have the database running with listener port 1521. We would like to cretae another database using the same oracle home and add the new listener entry with different port. Please advise how to add another listener entry in existing listener. thanks
        • 1. Re: add another listener entry
          Helios-GunesEROL
          Hi;

          Did you try to use netca utulity?

          Regard
          Helios
          • 2. Re: add another listener entry
            CKPT
            In oracle 11g, we have the database running with listener port 1521. We would like to cretae another database using the same oracle home and add the new listener entry with different port. Please advise how to add another listener entry in existing listener. thanks
            You can configure multiple listeners with different ports by using the sam home.

            ################### Listener for prod #####################
            NET_prod_ckpt-oracle =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = ckpt-oracle-vip)(PORT = 1521 )(IP = FIRST))
            (ADDRESS = (PROTOCOL = TCP)(HOST = ckpt-oracle)(PORT = 1521)(IP = FIRST))
            )
            )
            SID_LIST_NET_prod_ckpt-oracle =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME =prod)
            (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
            )
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
            (PROGRAM = extproc)
            )
            )
            ################## Listener for dev ####################
            NET_dev_ckpt-oracle =
            (DESCRIPTION_LIST =
            (DESCRIPTION =
            (ADDRESS = (PROTOCOL = TCP)(HOST = ckpt-oracle)(PORT = 60333)(IP = FIRST))
            (ADDRESS = (PROTOCOL = TCP)(HOST = ckpt-oracle-vip)(PORT = 60333)(IP = FIRST))
            )
            )
            SID_LIST_NET_dev_ckpt-oracle =
            (SID_LIST =
            (SID_DESC =
            (SID_NAME =dev)
            (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
            )
            (SID_DESC =
            (SID_NAME = PLSExtProc)
            (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1)
            (PROGRAM = extproc)
            )
            • 3. Re: add another listener entry
              sybrand_b
              Please do not provide such stupid advice.

              The number of listeners required per server is ONE! Not 2,not 100, but ONE.

              Also different ports are not required. No gain is made by setting up different listeners on different ports.

              The listener is a BROKER only, there is NO PERMANENT contact.

              -----------
              Sybrand Bakker
              Senior Oracle DBA
              • 4. Re: add another listener entry
                CKPT
                Please do not provide such stupid advice.
                Thinking can cause stupid, so kill the stupidity.
                The number of listeners required per server is ONE! Not 2,not 100, but ONE.
                Also different ports are not required. No gain is made by setting up different listeners on different ports.
                The listener is a BROKER only, there is NO PERMANENT contact.
                oracle@ckpt-oracle:> ps -ef|grep tns
                root 197 2 0 May21 ? 00:00:00 [netns]
                oracle   14266     1  0 Jun16 ?        00:09:35 /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr <listener1> -inherit
                oracle   24777     1  0 Jun16 ?        00:00:09 /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr <listener2> -inherit
                oracle 40665 10111 0 03:51 pts/2 00:00:00 grep tns
                oracle 46615 1 0 May21 ? 00:01:05 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
                oracle@ckpt-oracle:>
                Then how the two listeners are running of the same home?

                OP question.
                We would like to cretae another database using the same oracle home and add the new listener entry with different port
                Tell that it is not suggestable, ok, Here question of OP is Can it be done or not?
                • 5. Re: add another listener entry
                  EdStevens
                  CKPT wrote:
                  Please do not provide such stupid advice.
                  Thinking can cause stupid, so kill the stupidity.
                  The number of listeners required per server is ONE! Not 2,not 100, but ONE.
                  Also different ports are not required. No gain is made by setting up different listeners on different ports.
                  The listener is a BROKER only, there is NO PERMANENT contact.
                  oracle@ckpt-oracle:> ps -ef|grep tns
                  root 197 2 0 May21 ? 00:00:00 [netns]
                  oracle   14266     1  0 Jun16 ?        00:09:35 /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr <listener1> -inherit
                  oracle   24777     1  0 Jun16 ?        00:00:09 /oracle/app/oracle/product/10.2.0/db_1/bin/tnslsnr <listener2> -inherit
                  oracle 40665 10111 0 03:51 pts/2 00:00:00 grep tns
                  oracle 46615 1 0 May21 ? 00:01:05 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
                  oracle@ckpt-oracle:>
                  Then how the two listeners are running of the same home?
                  They obviously can run from the same home. What they can't do is run on the same port.
                  OP question.
                  We would like to cretae another database using the same oracle home and add the new listener entry with different port
                  Tell that it is not suggestable, ok, Here question of OP is Can it be done or not?
                  And if he had asked how to put diesel fuel in his gasoline powered auto?

                  Sometimes (far too often in this forum) the responsible thing to do is not to give the OP what they asked for, but to try to explain to them why they are asking for the wrong thing.