Configurating PLSQL using oracle instant client

1. Download oracle instant client

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

For downloading from oracle official website,you need a account first. After you login in, please choose the version you need and begin to download.

when get the oracle instant client package, please decompress it to a directory. For example, my directory is D:\ProgramFiles\instantclient_11_2.

2.Configurate environment variables

 As follow:
    PATH=D:\ProgramFiles\instantclient_11_2
    TNS_ADMIN=D:\ProgramFiles\instantclient_11_2
    LD_LIBRARY_PATH=D:\ProgramFiles\instantclient_11_2
    SQLPATH=D:\ProgramFiles\instantclient_11_2
    NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8

The NLS_LANG need to same as the setting of oracle server. you can select it like this: select * from v$nls_parameters;

3.Copy tnsnames.ora and sqlnet.ora

 Copying tnsnames.ora and sqlnet.ora from oracle server to D:\ProgramFiles\instantclient_11_2

4.Cofigurate PLSQL developer

Runing PLSQL developer, Click cancel at login window, Click Tools->Preferences, add two configurations at Connection item as below:

     Oracle Home：D:\ProgramFiles\instantclient_11_2
     OCI Library：D:\ProgramFiles\instantclient_11_2\oci.dll

Now, All of configurations are ok, Please restart PLSQL to take effect.