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)

    )

  )

Leave a Comment