DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sql*net and the listener

  1. #1
    Join Date
    Oct 2000


    I'm sure this is a simple question, but I could not find the answer in any of my books.

    When a message is sent into the server from a sql*net client and my listener is listening on port 1521, does it also send all replies and checks through port 1521 or does it choose another?

    Which ports will I need to open for a firewall?


  2. #2
    Join Date
    Feb 2001
    A search on Metalink for keyword 'firewall' yields a useful article (Oracle note no. 125021.1).

    The client sends a request for a connection to the listener on port 1521 (or whichever port is defined in tnsnames and listener.ora). When the listener spawns a server process, a port redirection takes place, and the spawned server tries to contact the client on a pretty much random port.

    The Oracle note gives a method of verifying that the firewall is indeed what is causing the problem, and several possible solutions.



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