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!

Connect to a Dynamic Changing IP

Yossi NixonSep 2 2018 — edited Sep 3 2018

Hi,

We have a setup of a database link via a VPN to remote site (static IP) and it works fine.

Connection from the remote site to the local site is working ONLY when we use the VPN IP in tnsnames.ora on the remote site (and the listener.ora is configured to listen to 0.0.0.0)

The problem is that VPN IP is dynamic and each reconnection I need to change tnsnames.ora

We want to keep the support of dynamic endpoint IP addresses assigned via Firewall/VPN.

Any idea for a solution?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2018
Added on Sep 2 2018
6 comments
590 views