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.
Look at the listener configuration to find out on what port ORACLE is listening on. The default port is 1521 but check it out by viewing listener.ora file.
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.
Reply With Quote
Bookmarks