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

在做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