Install Oracle InstantClient basic and instantclient sqlplus on win32

1. Download Oracle Instant Client  from Oracle site

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

e.g

   instantclient-basic-win32-11.1.0.7.0.zip
   instantclient-sqlplus-win32-11.1.0.7.0.zip

2. Create a C:\oracle directory on your C drive (if you don’t already have one)

    move both files into C:\oracle

3. Unzip both files

    i) first unzip instantclient-basic-win32-11.1.0.7.0.zip
   ii) then unzip instantclient-sqlplus-win32-11.1.0.7.0.zip

   End result should be a new folder called instantclient_11_1 in your C:\oracle:

4. Setup your system %PATH% and %TNS_ADMIN% variables

In Windows explorer LEFT pane, right click on “My Computer” icon and click “Properties”
Click “Advanced” tab
Click Environment variables button:

In the “System Variables” panel select “Path” variable and click “Edit” button:

In the “Variable Value” field paste the following:
C:\oracle\instantclient_11_1
BEFORE all other path values

5. Now find a variable called TNS_ADMIN — it could be in either panel (System / User),if you have no such variable, create

In the User panel by clicking “New”:
Variable Name: TNS_ADMIN
Variable Value: C:\oracle\instantclient_11_1
Click Ok

6. click “Ok” on the Environment Variables screen

7. click “Ok” on the System Properties window to close it

8. Setup tnsnames.ora, sqlnet.ora, ldap.ora  files

9. Test connectivity using sqlplus

Hope this help. Regards Rupam