Code Snippet

Just another Code Snippet site

#338

[Oracle] Configure ODBC Client

Olivier | Config, Tips

    1. Download Instant Clients Version 11.2.0.1.0 from Oracle WebSite (http://www.oracle.com/technetwork/topics/winsoft-085727.html)
      • instantclient-basic
      • instantclient-odbc
    2. Extract both ZIP in the same directory.
    3. Run odbc_install.exe
    4. Define following Env. properties :
      • ORACLE_PATH=c:\path\to\instantclient_11_2
      • TNS_ADMIN=%ORACLE_PATH%
      • add “;%ORACLE_PATH%” to the PATH variable
    5. Create TNSNAMES.ORA file in the %ORACLE_PATH% referencing database(s)
      example:

      <TNS_NAME> =
	(DESCRIPTION =
		(ADDRESS = (PROTOCOL = TCP) (HOST = <DB_HOSTNAME>) (PORT = <DB_PORT>))
		(CONNECT_DATA =
			(SERVER = DEDICATED)
			(SERVICE_NAME=<DB_SID>)
		)
	)

, ,

Comments are currently closed.