Probably a simple answer to this - I have servers A and B, both of which are 11g DB servers; there are firewall rules (based on static IP) allowing them to communicate - specifically A can talk to B on 1521. I now have a server C (also 11g) that also needs to connect to B but the firewall rule takes about 2 weeks to set up (server B is hosted, and 2 weeks is the turnaround time for setting up a new firewall rule). Is there a simple way of allowing C to proxy its requests through A in some fashion?
Note that A needs to retain its IP address and continue to connect to B, so I cannot reassign the IP address to C.
I considered remote listeners but my understanding is that after the listener connects the client to the DB the client will subsequently attempt to connect to the DB directly(?) so this would not work.
Thanks for any suggestions