We are looking into upgrading a web service connecting to Oracle using the unmanaged ODP to the managed ODP (12c release 3).
We are using tnsnames, and have the following configuration in the sqlnet.ora file: NAMES.DIRECTORY_PATH= (TNSNAMES, EZConnect).
The EZConnect resolver is needed because we are using a OracleDependency object for database update notifications.
When moving to the managed driver,a SocketException is thrown when trying to open a new connection. By looking at the call stack, I can see that the Oracle managed driver, actually a "OracleInternal.Network.EZConnect" object, is calling System.Net.Dns.GetAddrInfo to get an IP address, but with the tns alias as parameter ! This of course fails, with this "No such host is known" exception.
So it looks to me like there is an issue combining tnsnames and ezconnect with the managed ODP driver !
Anybody else that has experienced this, and found a solution, or could this be an error in the driver ?