This discussion is archived
5 Replies Latest reply: Jun 27, 2011 4:17 AM by EdStevens RSS

add another listener entry

user13681259 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    Hi;

    Did you try to use netca utulity?

    Regard
    Helios
  • 2. Re: add another listener entry
    CKPT Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points