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.