WINDOWS8.1 Installing the Oracle client and configuration

1. Official website Download:

Instantclient-basic-win32-11.2.0.1.0.zip

Instantclient-sqlplus-win32-11.2.0.1.0.zip

Instantclient-odbc-win32-11.2.0.1.0.zip

Instantclient-jdbc-win32-11.2.0.1.0.zip

2. Unzip to the same folder. such as C:\OracleInstantClient_11_2

3. New Network\admin folder under folder, new Tnsnames.ora file in folder.

4. Add Environment variables:

Tns_admin=c:\oracleinstantclient_11_2\network\admin
path=%path%; C:\OracleInstantClient_11_2
Oracle_home=c:\oracleinstantclient_11_2
Ld_library_path=c:\oracleinstantclient_11_2

Ora_home=c:\oracleinstantclient_11_2\ (no System.Data.OracleClient required Oracle client software 8.1.7 or later exception)

Path= ...; C:\OracleInstantClient_11_2\ (no System.Data.OracleClient required Oracle client software 8.1.7 or later exception)

5.plsql:

Oracle home:c:\oracleinstantclient_11_2
OCI Library:c:\oracleinstantclient_11_2\oci.dll

OK, now it's ready to use!