Forum Stats

  • 3,836,743 Users
  • 2,262,176 Discussions


Can you add (ENABLE=BROKEN) to database connection with a proxy server?

I have an application (AWS DMS) that does not allow you to enter a full tns string with (ENABLE=BROKEN). It is connecting to an Oracle database through AWS's Gateway Load Balancer which imposes a 350 second timeout. In a Linux virtual machine I just set OS parameter net.ipv4.tcp_keepalive_time=60 and add (ENABLE=BROKEN) and the connections never time out. But I have no control over the DMS service. So, I got the crazy idea of going through a proxy server running on a Linux VM. I could set net.ipv4.tcp_keepalive_time=60 on the proxy server's VM and somehow sneak in (ENABLE=BROKEN) to the connection to the real database even though the connection to the proxy server didn't have it. I'm guessing it isn't possible but thought I would ask.