首页 > 代码库 > pl/sql连接远程服务器

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 =http://www.mamicode.com/
(SERVER = DEDICATED)
(SERVICE_NAME = 数据库名)
)
)