Hi, there:
Usually you should have two ports on the firewall, WAN1 and WAN2, which will support two Internet connections.
About how to separate the traffic between the two connections, there are several ways to do it:
1. Use port forward, there will be two different public address for two connections, use port forward to map different service you have to different connections. For example, you have 128.128.128.1 for conn1, 128.128.128.2 for conn2, you can set up port forward to map Oracle server port 1521 to IP 128.128.128.1; map Web server port 80 to 128.128.128.2
2. Use NAT, on the firewall, set up NAT to map different servers to different public address of different conn. Suppose your Oracle server is 192.168.0.1, web server is 192.168.0.10, then you can NAT 192.168.0.1~9 to 128.128.128.1, NAT 192.168.0.10~192.168.0.20 to 128.128.128.2.
hope this is helpful!