Install ODP Oracle Client and Configure Tns
Here i'm going to explain how to download Oracle ODP and Install on server or windows system.
Step 1 – Download ODP Oracle Client from oracle web site as per required operating system.
Use this link to download ODAC
http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
Otherwise click below link for direct download from my google drive
https://drive.google.com/file/d/15nWlIlsp97WXRJMmQc25ZaJr18XRtDeF/view?usp=sharing
Step 2 –install ODP Oracle Client on system or Server.
For installing only Click Next Button then it will install
Step 3- After installing restart your system or server
Step 4 – go to your install location ex-
F:\app\Shashi\product\11.2.0\client_1\Network\Admin\Sample
From here copy and paste both file on below location
F:\app\Shashi\product\11.2.0\client_1\Network\Admin
Open tnsnames.ora in note Pad then sample tns will show As below
<data source alias> =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <hostname or IP>)(PORT = <port>))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <database service name>)
)
)
Create TNS as per your required Oracle Database Ex
MMS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.80)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MMS)
)
)