Does Managed ODP.NET x64 12.1.0.2 tnsname.ora support using IFILE?? I cannot get it to work.
For example, with the normal "thick client" unmanaged Oracle client that I have had installed for years, I used to have my tnsnames.ora file with one line in it:
IFILE=C:\SQLNET\tnsnames.MAIN
And then the C:\SQLNET\tnsnames.MAIN file contains IFILE references to each of the other Oracle instances within our organization. This helps to keep our config files separate from install files and works with no errors using the full Oracle client install.
However, If I try to do the same with the managed ODP.NET libraries, I get the following error: ORA-12154: TNS:could not resolve the connect identifier specified
I confirmed that no aliases are being retrieved by using the Oracle.ManagedDataAccess.Client.OracleDataSourceEnumerator.GetDataSources() method, which will return a list of all data sources enumerated from tnsnames.ora.
If I try with the IFILE references, I get nothing. If I manually the aliases to the tnsnames.ora file in the TNS_ADMIN settings folder (instead of using IFILE references), then I am able to use the data source correctly.
Is there any way to use IFILE tns names references with ODP.NET?