Firewall ports that should be allowed to enable communication between client and database server
Hello
We have to define firewall rules on a firewall that is between client application and Oracle database server.
The Oracle listener on the database server is configured to listen on port 1521.
The Oracle Database OS is Windows 2008 R2 SP1
Database version is 11.2.0.2.0
Question : what ports have to be opened on the firewall so that client and database server can communicate ?
Is port 1521 enough knowing that tnsnames.ora is configured to use dedicated server mode ?
Best regards
Filip