Installing 64 Bit Oracle Client : Windows 10 – 64 Bit

Scenario : You want to install Oracle Client and ODBC driver in Windows 10 – 64 Bit

Files Required :

Oracle Instant Client Basic :

http://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-windows.x64-12.2.0.1.0.zip

Instant Client Package – ODBC : http://download.oracle.com/otn/nt/instantclient/122010/instantclient-odbc-windows.x64-12.2.0.1.0.zip

Step 1 : Download Above 2 Packages.

Step 2: Copy all the contents to a single folder and name the folder as “oracle”

Step 3: Now copy the folder to c:\

So now the content of c drive should like below

Step 4: Now create a folder called tns inside c:\oracle => this folder will be used to save tnsnames.ora file

Step 5 : Add TNS_ADMIN variable in Environment Variables

TNS_ADMIN  => c:\oracle\tns\

Step 6: Add c:\oracle to the path variable

Step 7 :

Right click the file c:\oracle\

Step 8 : Now create a sample tns file and save in c:\oracle\tns\

PROD=

(DESCRIPTION=

(ADDRESS=

(PROTOCOL=TCP)

(HOST=xxx.oracle.haneefputtur.com

(PORT=1521)

)

(CONNECT_DATA=

(SERVER=dedicated)

(SERVICE_NAME=xxx.haneefputtur.com

)

)

….

Now your oracle client and odbc driver is ready to use.

Step 9 : Create ODBC DSN as follows

 

Note For 32 Bit Clients

Link  for 32 bit Instant Client : http://download.oracle.com/otn/nt/instantclient/122010/instantclient-basic-nt-12.2.0.1.0.zip

Link for 32 Bit ODBC Driver :

http://download.oracle.com/otn/nt/instantclient/122010/instantclient-odbc-nt-12.2.0.1.0.zip