02085, 00000, "database link %s connects to %s" // *Cause: a database link connected to a database with a different name. // The connection is rejected. // *Action: create a database link with the same name as the database it // connects to, or set global_names=false. // 从...
简介:场景: 出现ORA-02085: database link %s connects to %s 的错误, 具体案例报错如下:ORA-02085:数据库链接ARPDB_41连接到ARPDB41 错误原因: 使用的dblink名称与要连接的数据库名字不相同 解决方法: 第一种:创建与对方数据库名字相同的dblink。 场景: 出现ORA-02085: database link %s connects to %s 的...
Cause: a database link connected to a database with a different name. The connection is rejected. Action: create a database link with the same name as the database it connects to, or set global_names=false. 当数据库GLOBAL_NAMES参数设置为TRUE时,使用DB LINK连接其他库,DB LINK的名称必须与...
创建链接 CREATE DATABASE LINK dblinkname CONNECT TO dbuser IDENTIFIED BY your_password USING 'orcl...
场景: 出现ORA-02085: database link %s connects to %s 的错误, 具体案例报错如下:ORA-02085:数据库链接ARPDB_41连接到ARPDB41 错误原因: 使用的dblin zhangshengdong 8年前 574 ORACLE数据库链接 在ORACLE里面,远程数据访问,像查询、更新等可以通过Database Link来实现。数据库连接需要在建立Database Link的...
> TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = > (SERVICE_NAME = dbname) ) )' ; > > Didn't work. It created the database link just fine but when I try > to use > it I get: > > ORA-02085: database link linkname connects to dbname ...
(CONNECT_DATA =(SERVICE_NAME = dbname) ) )' ;Didn't work. It created the database link just fine but when I try to useit I get:ORA-02085: database link linkname connects to dbnameAnyone know of any work-arounds.--Please see the official ORACLE-L FAQ: http://www.orafaq.com--...
> TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = > (SERVICE_NAME = dbname) ) )' ; > > Didn't work. It created the database link just fine but when I try to use > it I get: > > ORA-02085: database link linkname connects to dbname ...