Installing and configuring Oracle client under Windows Plsql

1, first download PL/SQL, installation, cracking;

Here to provide a self-made plsql11 version of the Green Chinese cracked version:

Http://down.51cto.com/data/2075386

http://download.csdn.net/detail/abc2536465230/8939917

The two are the same.

2, download the Oracle INSTANCT client base version of the file;

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

Here I choose to be 32 system, although I am 64 win7. The online data says that Plsql does not support the 64 Oracle client, and after the test it was found that Plsql is not supported by the Oracle client of 64.

3, decompression instanct client to any disk, such as (D:\instanctClient), in the decompression file under the path of a new file network, and then build a file under the network Admin,ok;

The name of the D:\instanctlient\network\admin//new folder can be uppercase or lowercase.

4, with the TXT software to write Tnsnames.ora, content is required to connect to the remote database address information, such as:

TEST =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = xxx.xxx.xxx.xxx) (PORT = 1521))
)
(Connect_data =
(SID = test)
)
)
You can also find the Tnsnames.ora file directly from the Oracle client, copy it directly under the Admin file, or copy the Tnsname.ora file from the Linux installation Oracle to Windows Network\admin.

5. Configure environment variables and create two new variables under System variables:

Character coded variable configuration to prevent garbled characters

nls_lang=
Simplified Chinese_china. Zhs16gbk

Load Tnsnames.ora information, so write the path of Tnsnames.ora

tns_admin=
D:\instancClient\network\admin

6, open PL/SQL, the first time opened, direct point cancellation, you can directly enter the software interface, in the menu, as follows: tool (Tools), set (Perference)

Locate the connection option under Oracle in this window to configure the path of the Oracle Home =admin folder, the path where the OCI library= Oci.dll (the INSTANCT Client of Oracle Files under the base decompression package)

Oracle Home:

D:\instancClient\network\admin

OCI Library:

D:\instancClient\network\admin\oci.dll//The oci.dll here must be specified, or the start will be error.

7, re-open Plsql, enter the user password, select the library configured in Tnsnames.ora, complete

PS: Although can not be completely original, but also installs the experience, hoped can help to need the person.

Reference Address: http://blog.csdn.net/evildog/article/details/7959920

Installing and configuring Oracle client under Windows Plsql