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
解决方案 »
- 新手求教ORA-06502: PL/SQL: 数字或值错误 : 字符串缓冲区太小
- 数据库还原的基础问题
- 存储过程------局部游标变量
- oemctl start oms time out!!怎么办
- 求Oracle备份和恢复相关的电子书(在线等待)
- 请问哪里有oracle developer2000的下载
- 紧急求救!
- 请教oracle向microsoft SQL Server 移植时需要注意哪些问题?
- 请问:使外键的约束失效的sql语句如何写啊?
- Oracle使用SYS用户SYSDBA权限恢复数据到orcl表空间是EP,新创建的ep用户默认表空间是EP无法访问数据表
- oracle if 问题
- 求教表连接方法
计算机名可以在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是不是正确!