Hi,
I had read this discussion - session still connected even when listener down and something come out in my mind. Whats the port required for client to connect to the database? I was quite confused with some of the reply on that discussion and I dont want derailed that discussion since its already been marked as answered.
Let say if firewall team ask which port required by oracle database so that they will open that port. By default, 1521 is for listener. Is there any other port required?
I also already read this Doc ID 125021.1. Below are some of the contents.
Port redirection is common on Windows platforms prior to 10gR1. Note that it is not typical for the Oracle Net listener to redirect to a new port in versions 10.2.x or newer. However, in the case of shared server, it is possible to see this behavior.
So, is it means that version 10.2.x and newer only require port 1521 only for dedicated server?
I also already check using netstat command. There are many connection established to the port 1521. So, i quite confused because some of the reply in the discussion i mention above said that after the connection established, client will connect to the database using another port.