create public database link ASMDB
connect to xw identified by xuwei
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.100.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASMDB)
)
)' select * from test@ASMDB
ora-12541: Tns: 无监听程序上面的代码有错误吗?192.168.100.55 的 GLOBAL_NAME 是 192.168.100.55 ASMDB执行 select * from v$option where PARAMETER='Advanced replication' 的结果是 TRUE
connect to xw identified by xuwei
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.100.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASMDB)
)
)' select * from test@ASMDB
ora-12541: Tns: 无监听程序上面的代码有错误吗?192.168.100.55 的 GLOBAL_NAME 是 192.168.100.55 ASMDB执行 select * from v$option where PARAMETER='Advanced replication' 的结果是 TRUE
test =
DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.100.55)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASMDB)
)
)