Microsoft OracleClient to ODP.NET Application Migration: Installation
ODP.NET can be downloaded from the Oracle Technology Network. The ODP.NET software is often be bundled with other Oracle Data Access Components (ODAC) for Windows, such as OLE DB, ODBC, and ASP.NET providers. To download and install ODP.NET, follow this step by step installation outlined in the Installing .NET Products section of the Oracle 2 Day .NET Developer's Guide.
Once installed, you will need to set up an Oracle NET connect alias. The ADO.NET developer sets the ODP.NET connection string Data Source attribute equal to the alias. The alias is used to resolve how to connect to the database server using information in the tnsnames.ora file. Microsoft OracleClient and ODP.NET both use this file to resolve the alias. Copy the the tnsnames.ora file that Microsoft OracleClient uses to the new ODP.NET software install location. Generally, this file is found in the directory ORACLE_BASE\\ORACLE_HOME\network\admin (e.g. C:\app\user\product\11.1.0\client_1\network\admin\). Copy the file to the same directory in the ODP.NET software installation (e.g. C:\app\user\product\11.1.0\client_2\network\admin\).