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
    Posts
    1

    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
    Location
    California
    Posts
    128
    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.
    alapps

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

  3. #3
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175

    Smile

    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