Hello,
I am getting timeout trying to connect to the database over SSL VPN. I am using VS2017, ASP.Core 2.1, ODP.NET Core 2.1, Oracle 11g.
Our database is on its own enclave so we need to hop on it using SSL VPN ( via HTTPS link ) once we vpn to connect to work. Oracle clients (PLSQL,Toad) work no problem connecting to the database using either TNS Names or direct connection using IP address. There is no client configuration required.
On the other hand, ODP.NET refused to make connection with timeout. I recently found a security parameter in the Oracle document saying that I need to configure on the client side for ODP.NET to talk to the database
SECURITY =( SSL_SERVER_CERT_DN="cn=xxxx,ou=yyy,o=zzz, c=aaa))
And a setting of SQLNET.ora is required.
I was wondering if this is the only solution (that requires a bit of setup) OR the problem has been addressed in the latest version of ODP.NET Core that I just need to upgrade.
Greatly appreciated!