Please bare with me here, but I am a novice at Oracle and would like someone to please help with the following question.
I have 2 Windows NT domains, 1 domain has oracle server and the other domain has a client that wishes to access the oracle server. Between these domains their is a firewall, and I would like to know the best way to find out the ports I need to open and what would be the best to get this connection to work.
I have checked the listener.ora and it is using port 1521, when I check the log on the server I can see the client connecting but for some reason the client is not able to connect to the server even when I use ODBC test. If I put the client on the same domain as the server I can get connectivity, thus proving the db is okay.