我想从dbA访问dbB的数据,从网上搜了一下,好像这样写:create database link linka connect to dbBUser identified by dbBPW using 'dbB'; select * from table@linka
但是我这样试了一下连接是可以连上,但是在访问表的时候会出现“ora-12154:TNS:无法解析指定的连接标识符”这样的错误,请问这是什么原因呢
但是我这样试了一下连接是可以连上,但是在访问表的时候会出现“ora-12154:TNS:无法解析指定的连接标识符”这样的错误,请问这是什么原因呢
在cmd窗口执行 sqlplus userid/pwd@dbB 看看能连接上吗?
配置本地服务名 就是在oracle 配置和移植工具 net manager中配置服务名 这样 才能用plsql连接数据库
T =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = t)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)