1 去oracle官网下载 绿色客户端压缩包
下载地址: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
2 解压之后 instantclient_12_1文件夹下,新建如下目录
D:\instantclient_12_1\NETWORK\ADMIN\tnsnames.ora
tnsnames.ora 文件内容如下:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
3 设置环境变量:
TNS_ADMIN=D:\instantclient_12_1 (远程地址连接)
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK (中文乱码解决)
4 plsql 菜单栏找到 工具 》首选项:
配置如下:
5 一些ok,重启plsql,输入用户名和密码即可访问远程主机数据库。