This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Mar 21, 2013 5:27 AM by EdStevens Go to original post RSS
  • 15. Re: Listener configuration and other questions
    EdStevens Guru
    Currently Being Moderated
    995273 wrote:
    good to know that.
    Thank you for that reply!!!

    Is it better to use different ports for different instances???

    Edited by: 995273 on 21.03.2013 04:32
    It would be pointless to attempt to do so. The port is simply used by the listener to receive connection requests. They are not separated by database/instance. The closest you would come to that would be by configuring the client (tnsnames.ora) to make the distinction, like this:
    abbot =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = abbot)
        )
      )
    #
    costello =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1522))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = costello)
        )
      )
    #
    Note the port difference in the two. But this is really just an illusion. If the listener is listening on both 1521 and 1522, any request that reaches, through any port it is using, will be serviced. You could reverse the ports on the above example, and still be able to connect to both databases.


    ======

    Amazing! I originally used two other names from a famous early 20th-century American comic duo, and was rejected as 'content not allowed' Laural and ...

    Edited by: EdStevens on Mar 21, 2013 7:27 AM
1 2 Previous Next

Legend

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