oracle 报错：ORA-12169: TNS: 指定为连接标识符的 Net 服务名太长

Question

建立链接
create public database link link3
connect to "system" identified by "manager"

using '

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = 10.103.2.213)
(PORT = 1521)) )

(CONNECT_DATA =
(SERVICE_NAME = SW01)
) )';
之后测试下是否链接成功
select * from cadba.enpsms_temp@link3;

但是出现下面的错误：
ORA-12169: TNS: 指定为连接标识符的 Net 服务名太长

Answer 1

http://blog.csdn.net/stevendbaguo/article/details/51793170