使用oracle的时候,有时候碰到 tns 无法处理服务名的问题.其实很简单.
例如我用workflow登陆mecon数据库的时候就报这个错误.
第一 找到tnsnames.ora文件.
例如
GSXYDJ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.102)(PORT = 1521))
)
(CONNECT_DATA = (SID = gsxydj)(SERVER = DEDICATED))
)
第二:
增加
databasename =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = databaseip)(PORT = 1521))
)
(CONNECT_DATA = (SID = databasesid)(SERVER = DEDICATED))
)