资料：

ORA-02085 database link string connects to string

Cause: The database link attempted to connect to a database with a different name. The name of the database link must be the same name as the name of the database.

Action: Create a database link with the same name as the database to which it connects.

GLOBAL_NAMES: specifies whether a database link is required to have the same name as the database to which it connects. If the value of GLOBAL_NAMES is false, then no check is performed. If you use or plan to use distributed processing, Oracle Corporation recommends that you set this parameter to true to ensure the use of consistent naming conventions for databases and links in a networked environment.

虽然当GLOBAL_NAMES参数设置为TRUE时，DATABASE LINK的名称必须与被连接库的GLOBAL_NAME一致，但是今天的情况是重新建立DBLink的时候name总是自动增加name.US.ORACLE.COM（PL/SQL Develop）工具，无法达到一致的效果。所以考虑更改系统的Global_Names参数。

查询：select * from global_name;

show parameters global_names;

alter system set global_names= false;

以下资料摘录（http://www.laoxiong.net/database_link_global_names.html）参数设置为FALSE，影响的是创建数据库链接的那个库对数据库链接的使用。也就是说，如果一个库（实例）的global_names参数设值为TRUE，则该库连接其他库的数据库链接，其名称必须要与被连接的库的global_name相同

global_names

SQL> create database linkdmdb@link1connect to test identified by test using ‘dmdb’;

数据库链接已创建。

SQL> create database linkdmdb@link2connect to test identified by test using ‘dmdb’;

也就是在GLOBAL_NAME后面加上@再加上一个标识。这样就能够创建多个数据库链接到同一目标库上了。