创建dblink名称很长，TS.REGRESS.RDBMS.DEV.US.ORACLE.COM

来源：互联网发布：中国经济现状知乎编辑：程序博客网时间：2024/05/19 13:42

在做dblink的时候遇到一个问题，不管创建私有link ，还是共有link都会在link名后加很长的一串，非常的烦人。

如下：

create public database link test connect to scott identified by tiger using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.54)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora11g)
    )
)';

CREATE DATABASE LINK ts CONNECT TO scott IDENTIFIED BY tiger USING 'ora11g'

SQL> select * From dba_db_links;

OWNER              DB_LINK                                                                               USERNAME               HOST            CREATED
----------           ----------------------------------------                                          ------------------------------ -------------------------------------------------- ---------
SYS                  TS.REGRESS.RDBMS.DEV.US.ORACLE.COM                  SCOTT      ora11g           29-MAY-13
PUBLIC            DB_LINK.REGRESS.RDBMS.DEV.US.ORACLE.COM         SCOTT      ora11g           28-APR-12
PUBLIC           TEST.REGRESS.RDBMS.DEV.US.ORACLE.COM               SCOTT      (DESCRIPTION =          29-MAY-13
                                                                                                                                                             (ADDRESS_LIST =
                                                                                                                                                (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.8.5
                                                                                                                                                         4)(PORT = 1521))
                                                                                                                                                                                             )
                                                                                                                                                                (CONNECT_DATA =
                                                                                                                                                            (SERVICE_NAME = ora11g)
                                                                                                                                                                             )
                                                                                                                                                                               )

SQL> select * From t1@TS.REGRESS.RDBMS.DEV.US.ORACLE.COM;
select * From t1@TS.REGRESS.RDBMS.DEV.US.ORACLE.COM
                 *
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from TS

修改全局数据库名称：
SQL> alter database rename global_name to test;
SQL> create database link ts connect to scott identified by tiger using 'ora11g';
Database link created.
SQL> select * from dba_db_links;
OWNER          DB_LINK   USERNAME    HOST        CREATED
------------------------------ ---------- ------------------------------ -------------------- ---------
SYS          TS   SCOTT     ora11g        29-MAY-13
SQL> show parameter name
NAME         TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert       string
db_name         string ora11g
db_unique_name        string ora11g
global_names        boolean FALSE
instance_name        string ora11g
lock_name_space        string
log_file_name_convert       string
service_names        string ora11g
SQL> select * from global_name
GLOBAL_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
TEST