建立指令碼：

create public database link test
connect to oms identified by "oms"
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS =
        (PROTOCOL = TCP)
        (HOST = 10.148.73.47)
        (PORT = 1521)
      )
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
)';

可會測試通不過，這裡就修改global_names的值

查詢global_names的名稱：select * from global_names;

查詢global_names的值：show parameter global_names;

修改：

alter system set global_names=false/true;

DBLINK 設定

相關文章