I'd like to interconnect my primary and my standby through ODG and a VPN internet llink between my 2 datacentters.
Is there anybody who has already tried such a thing? What are the pitfalls, constraints , limitations ?
While it is possible to connect to an Oracle database using the Internet it is not a good idea to expose
the database's listener port directly to the Internet.
A VPN might work.
I would consider another solution. SSH tunneling is where I would look.
If you are using Windows search for USE_SHARED_SOCKET, I believe you need to enable it.