Yeah, that could work, but ...
is there any better way avaiable? Since under certain circumstances, the clients IP address may not be a fixed one.
Also, will this work for ODBC Connection as well? i.e. Is ODBC connect the same way to the Oracle server as Net8?
Have you ever use connection manager(CMAN) or set USE_SHARED_SOCKET = TRUE?
Thanks all, but the thing is ...
Since we are the software application vendor, we don't really know which OS the customer's Oracle servers are sit on, and we don't want to put a limitation over there. i.e. if they are using dedicated server mode, we don't want to force them change to MTS mode etc.
So I'd like to provide them generic solutions if I can. So far, can I draw a conclusion that:
To make a remote client connect to an Oracle server inside a firewall, your client needs to have a fixed IP address. The firewall should be configured only accept those specified IP addresses. Also, the port 1521 needs to be open on the firewall. Plus
1. If the Oracle server is on Windows Box (which is a multithread server), then you can always make it work by set USE_SHARED_SOCKET = TRUE in registry.
1.1 If their Oracle server is running in MTS mode, then they can simply "fix" the port number through which connection will be established by setting
In this case, you don't have to set USE_SHARED_SOCKETS = TRUE. (is this statement correct?)
2. If the Oracle server is not on a multithreaded OS, then there is no additional requirement besides keep port 1521 open on firewall and configure firewall to only accept predefined IP addresses for the clients.
Is that sounds right to you all?
Is yes, then where can Oracle Connection Manager fit in? Is it true that if you use CMAN, you can skip all above steps? And can you configure firewall to accept all clients' request send to port 1521 instead of only the predefined ones?
Thanks so much for all your help and have a wonderful X'mas!