Oracle listener with multiple ports issue Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle listener with multiple ports issue

  1. #1
    Join Date
    Mar 2001

    Oracle listener with multiple ports issue

    Hi, I have an listener question that I hope the gurus in this forum can help me out. I have a 9.2 listener on Sun solaris listening on two ports 1521 and 1526. I notice that majority of my remote connections are connected to port 1521 and only a some of them connected via port 1526. My listener is NOT configured for failover or anything like that. My question is, how does this happen? Is there a limit of connections on each dedicated port? Under what circumstance Oracle would force a connection to connect to port 1526 and not 1521? Please advise. Thanks in advance.

    ps: all of my client tnsnames.ora are configured with multiple addresses in the address_list (1521 and 1526 respectively)

  2. #2
    Join Date
    Nov 2000
    Couple things to look at:

    1. Do you have java processes that are using the JDBC Thin driver? Sometimes the developers can use a URL (host:port:sid) that specifically connect to port 1521. These connections will not use the tnsnames.ora.

    2. Do you have load balancing on at the client at the tnsnames.ora.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width