PLSQL连接32位Oracle客户端(环境变量配置)
1.下载oracle简易版客户端或instantclient
2.解压到指定⽬录(⾃⼰定)
3.环境变量配置
变量名:
TNS_ADMIN
变量值:
D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
(安装⽬录即可)
变量名:
NLS_LANG
plsql13安装教程及配置
变量值:
AMERICAN_AMERICA.ZHS16GBK
4.配置PL/SQL
进⼊页⾯后选择tools-->preferences
Oracle Home和OCI libarary如下:   
  Oracle Home:
  D:\oracle\product\10.2.0\client_1\(你的安装路径)
OCI : D:\oracle\product\10.2.0\client_1\
oci.dll (加上oci.dll)
Apply-->OK
5.配置Oracle客户端
建⼀个
⽂件,然后向⽂件中添加如下内容:(具体根据⾃⼰的主机和端⼝配置)
该⽂件放在oracle安装⽬录下:d:\oracle\product\10.2.0\client_1\NETWORK\ADMIN
格式如下
s1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora9)
)
)