pl/sql连接远程服务器

配置系统变量

 

 

 

NLS_LANG：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

TNS_ADMIN：D:\PLSQL Developer\instantclient_11_2\NETWORK\ADMIN

tnsnames.ora 文件

ORCL@IP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库名)
)
)

 

将pl/sql中的 oci库 配置为oci.dll