1. 下载;
百度云下载地址:http://pan.baidu.com/s/1qWTulOg
提取密码am5x
2. 解压,解压之后保证目录结构如下;
D:\PLSQL
|-- instantclient_11_2
|-- tnsnames.ora
|-- PLSQL Developer
|-- readme.txt
3.新增环境变量
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
TNS_ADMIN = D:\PLSQL\instantclient_11_2
4. 环境设置;
(1)打开plsql,不登录,在如下位置设置
工具 -> 首选项 -> 连接
(2) 设置
Oracle主目录名 = D:\PLSQL\instantclient_11_2
OCI库 = D:\PLSQL\instantclient_11_2\oci.dll
5. 修改tnsnames文件内容;
tnsnames.ora 内容设置
172.17.209.102=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.209.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = biedwshoes)
)
)
6. 然后选择“会话”>“登录”即可;