alter system set global_names=false;create PUBLIC database link ASMDB
connect to VDJ identified by VDJ
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.101.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASMDB)
)
)';
select * from LJNC.LJ_VDJ_TB_CLIENTLIST@ASMDB用system 登录执行里面的代码 出现错误 ora-12545 用PL\sQL 能够使用
用户名:VDJ
密码:vdj
连接到 192.168.101.13,1521 的SID ASMDB
connect to VDJ identified by VDJ
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.101.13)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ASMDB)
)
)';
select * from LJNC.LJ_VDJ_TB_CLIENTLIST@ASMDB用system 登录执行里面的代码 出现错误 ora-12545 用PL\sQL 能够使用
用户名:VDJ
密码:vdj
连接到 192.168.101.13,1521 的SID ASMDB
计算机名可以在System Properties下的Computer Name找到
connect to vdj identified by vdj
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = asmdb)
(INSTANCE_NAME = asmdb1)
)
)';select * from LJNC.LJ_VDJ_TB_CLIENTLIST@ASMDB1
成功
能的话,看看TNSNAMES.ORA文件中host name是不是正确!