Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Bobby DurrettJun 16 2022

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 11.2.0.3 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.
Thanks,
Bobby

Comments
Post Details
Added on Jun 16 2022
0 comments
868 views