SQL*Net and Firewalls
936749Nov 1 2012 — edited Nov 1 2012Hi,
We've started a discussion with our network team in regards to how SQL*Net behavior is through a firewall.
When working with networks guys several years ago we've always heard that a client may connect to the database on 1521 but the database may open high ports back to the client.
Is this still an issue on Oracle 10g -> or has this never been the case?
The issue is that we run Cisco FWSM (firewall) with inspect SQL*Net witch seems to limit throughput through our firewall.
We're moving a lot of databases with datapump and using network_link to move the data over our network and through the Cisco firewall.
Is it safe to remove SQL*Net inspect in the firewall and will all communication be on port 1521 all the time?
Regards
933746