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