Oracle Instant Client 10.2–sequence

An old recipe that was laying around for Oracle Instant Client 10.2.
Prerequisites
Some good things to know;
1. Oracle Client 10.2 contains some defects that requires the user that is running it to have Create global object permissions.
2. The user needs read-access minimum to the directory you will install the application to.
image
Sequence
Installation
Unpack all Oracle-clients to (instantclient-basic-win32-10.2.0.4.zip and instantclient-odbc-win32-10.2.0.4.zip);
C:\instantclient_10_2

Append C:\instantclient_10_2 to the PATH variable

Create tnsnames.ora in c:\instantclient_10_2 with the following content;

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
SERVER.FQDN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (COMMUNITY = tcp.WORLD)(PROTOCOL = TCP)(HOST = FQDN)(PORT = 1531))
    )
    (CONNECT_DATA = (SID = name))
  )

Execute the following command;

C:\instantclient_10_2>odbc_install.exe JA
Oracle ODBC Driver is installed successfully.
C:\instantclient_10_2>

Configuration

Create a new System DSN
Choose Oracle_in_instantclient10_2

Leave a Reply

Your email address will not be published. Required fields are marked *