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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Solomon Yakobson

DBCA must be run either as administrator or as user with administrative privileges.
SY.

1 - 1

Post Details

Added on Jun 16 2022
0 comments
857 views