Oracle Client Installation

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

Installation Steps:

  1. Extract the OracleClientODBC-32Bit or OracleClientODBC-64Bit zipped folder according to the Machine (32bits or 64bits).
  1. Now set 4 environment variables at client machine as System Variable.
  • 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.
  1. Find ‘tnsnames.ora’ file and then set the parameters according to the remote database which is required to connect.
  1. Run the ‘odbc_install.exe’ for installation of new entry in Data Sources (ODBC).

 

Related Posts

, , ,