PLSQL远程连接数据库

1、下载oracle客户端：https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html
我下载的是oracle11 压缩包名字：instantclient-basic-windows.x64-11.2.0.4.0.zip

2、解压：解压到任意位置 例如：目录 E:\tools\oracle\

3、新建文件 E:\tools\oracle\instantclient_11_2\network\admin\TNSNAMES.ORA
TNSNAMES.ORA增加配置：
SINODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sinodb)
)
)

如果要添加多个配置的话：
SINODB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sinodb)
)
)

COGNOSDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = cognosdb)
)
)

4、打开PLSQL，不用登陆

数据库选项会显示你所配置的实例

5、进入PLSQL后，工具—>首选项---->连接

把你的主目录和oci.dll文件目录粘贴上去

解决oracle数据库中文乱码问题：
修改客户端的系统环境变量，增加如下内容：变量名：NLS_LANG，变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK