DB LINK 的创建和连接时出现的问题

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod

SQL> show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE

SQL> show parameter instance_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      tid002
SQL> create database link db_tid002 connect to u1 identified by u1 using 'TID002';

Database link created.

SQL> select * from test_01@db_tid002;
select * from test_01@db_tid002
                      *
ERROR at line 1:
ORA-02085: database link DB_TID002 connects to TID002

SQL> drop database link db_tid002;

Database link dropped.

SQL> create database link tid002 connect to u1 identified by u1 using 'TID002';
create database link tid002 connect to u1 identified by u1 using 'TID002'
                            *
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier

SQL> alter system set global_names=false;

System altered.

SQL> show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     FALSE
SQL> drop database link db_tid002;

Database link dropped.

SQL> create database link db_tid002 connect to u1 identified by u1 using 'TID002';

Database link created.

SQL> select * from test_01@db_tid002;

         A
----------
1

 

SQL> show parameter instance_name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
instance_name                        string      tid002
SQL>

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production

SQL>  show parameter global_names

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
global_names                         boolean     TRUE

SQL> create database link db_tid002 connect to scott identified by tiger using '
TID002';

Database link created.

SQL> select count(*) from emp@db_tid002;
select count(*) from emp@db_tid002
                         *
ERROR at line 1:
ORA-02085: database link DB_TID002.US.ORACLE.COM connects to
TID002.US.ORACLE.COM

SQL> drop database link db_tid002;

Database link dropped.

SQL> create database link TID002.US.ORACLE.COM connect to scott identified by ti
ger using 'TID002';
create database link TID002.US.ORACLE.COM connect to scott identified by tiger u
sing 'TID002'
                                          *
ERROR at line 1:
ORA-02082: a loopback database link must have a connection qualifier

SQL> alter system set global_names=false;

System altered.

SQL> create database link db_tid002 connect to scott identified by tiger using '
TID002';

Database link created.

SQL> select count(*) from emp@db_tid002;

  COUNT(*)
----------
14

参考：

Creation of a Loopback DBLINK Yields the Error: ORA-2082 [ID 1381497.1]

OERR: ORA 2085 "database link %s connects to %s" [ID 19367.1]
Database Links: Troubleshooting ORA-2085 "database link %s connects to %s" [ID 210630.1]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24756186/viewspace-742153/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24756186/viewspace-742153/