PL/SQL-免安装客户端

1.下载Oracle Client Package .

http://download.oracle.com/otn/nt/instantclient/112020/instantclient-basic-nt-11.2.0.2.0.zip

 

2.解压到本地，如：D:\software\oracleclient\instantclient_11_1

添加2个文件

sqlnet.ora

写道

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 tnsnames.ora

写道

mydb=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = mydb)
)

)

 

3.添加环境变量

变量名 : TNS_ADMIN

变量值 : D:\software\oracleclient\instantclient_11_1（文件解压后的路径）

 

4安装 pl/sql软件

http://allroundautomations.swmirror.com/plsqldev802.exe

 

5.配置pl/sql连接Oracleclient

   TOOLS->Perferences

在弹出的对话框中添加:

oracle HOME

    D:\software\oracleclient\instantclient_11_1

OCI

    D:\software\oracleclient\instantclient_11_1\oci.dll

 

6.添加环境变量

变量名 : NLS_LANG

变量值 :SIMPLIFIED CHINESE.ZHS16GBK

 

 

打完收工，连接测试一下