About opening ports for the firewall
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: About opening ports for the firewall

  1. #1
    Join Date
    Jan 2003

    About opening ports for the firewall

    Hi all,

    I'd like to know if there are any ports that I need to open besides 1521 (default port) if I need to connect through a firewall. Does Oracle only use this one port for communications or are there more that I need to open?

    Also, What is SQLnet? What does it do? Does this have to do with communicating with an Oracle server also?

    Thanks in advance!

  2. #2
    Join Date
    Jul 2002
    Port 1521 is used by default (SQLNET/NET8). Additionally, you may change this in the listener and sqlnet configuration files.

    Refer to listener.ora & tnsnames.ora to determine which ports are in use to allow through the firewall.

    Fast, Cheap, Reliable... Pick Two(2)

  3. #3
    Join Date
    May 2002
    California, USA


    There is not simple enough to open port 1521 on the firewall, since Windows sockets are configured to do port forwarding, which causes Oracle to receive the requests on 1521 but to reply back on random ports.

    To make the story short, read about Oracle & Firewalls from Here . You will understand how it's working and what are your options.

    Hope that helps,

    clio_usa - OCP 8/8i/9i DBA

    Visit our Web Site

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