Oracle 11g Client and plsql developer configuration

Oracle 11g ClientResources

Download resources, direct decompression for configuration

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

since Plsql developer is a 32-bit software, 32-bit Oracle clients need to be downloaded.

The project packaging client addresses are as follows:

(Version 11.2.0.3.0) Link: http://pan.baidu.com/s/1qW7e1di Password: kzye

Note: Sqlplus is included, but the directory structure is the continuation of the original Oracle 10g client, without affecting the use.

Windows operating system environment variable configuration

To configure environment variables:

Oracle_home=d:\oralce\client_10_2

Tns_admin=d:\oralce\client_10_2\network\admin

Nls_lang=american_america. UTF8

Note: The language is configured according to the actual situation, for example Chinese is nls_lang=american_china. Zhs16gbk

Oracle Network Connection Configuration

(1) Create folders and files

Create the following folder D:\Oralce\client_10_2\NETWORK\ADMIN on the D disk.

among them, "\network\admin" is new.

(2) Create and configure the Tnsnames.ora configuration

120 =
(DESCRIPTION =
(address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.64.52.120) (PORT = 1521))
     )
(Connect_data =
(service_name = ORCL)
     )
     )

(3) Sqlnet.ora

sqlnet. Authentication_services= (NTS)
NAMES. Directory_path= (TNSNames, Ezconnect)

The above content can be obtained directly from the project self-created resources download.

plsql Developer Configuration

as shown, Operation Plsql Developer Menu "Tools", select the Preferences function in the drop-down menu, pop up the following window, respectively, configure the following options:

Oracle home:d:\oralce\client_10_2

OCI Library:d:\oralce\client_10_2\oci.dll

about the use of Plsql developer can refer to online resources, such as: Baidu Library, Plsqldeveloper tool use tutorial.

Plsql Developer Download resources can use the following temporary resources, three days after cancellation: Link: http://pan.baidu.com/s/1rrUF0 Password: zazv

Oracle 11g Client and plsql developer configuration