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