最新版Oracle数据库的PLSQL安装链接服务器

安装所需软件清单：

PLSQL：http://www.cr173.com/soft/232303.html

instantclient_11_2_64.zip：官网下载

我的oracle client 安装目录为：D:\WorkSoft\instantclient_11_2\

1.首先环境变量配置

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN=D:\WorkSoft\instantclient_11_2\network\admin

2.修改admin下面的tnsnames.ora

(1)

REPORT=
(

DESCRIPTION =

(

ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.0.5)(PORT = 1521)

)

       (

CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = webdb)

)

)

(2)

REPORT=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.139 )

(PORT = 1521))) (CONNECT_DATA =(SERVICE_NAME = ORCL3.sinitek.com) ))

3.设置PLSQL

工具——》首选项

4.开始链接

5.成功！！！