How to install Oracle client

1.   Download Oracle Client.

2.       Extract the OracleClientODBC-32Bit or OracleClientODBC-64Bit zipped folder
       according to the Machine (32bits or 64bits).

 3.      Now set 4 environment variables at client machine.
       My Computer Properties >> Advanced >> Environment Variables
       ·         PATH: Set the path. Put ‘;’ at the end of existing path and give the path of folder where the
             files are extracted.
       ·         LD_LIBRARY_PATH: New environment variable is created with the path of same folder.
       ·         ORACLE_HOME: New environment variable if not present with same path.
       ·         TNS_ADMIN: New environment variable with same path if not present.

4.        Find ‘tnsnames.ora’ file and then set the parameters according to the remote database which
        is required to connect.

5.        Run the ‘odbc_install.exe’ for installation of new entry in Data Sources (ODBC).

6.        Create the DSN with TNS entry.