| 導購 | 订阅 | 在线投稿
分享
 
 
 

ORA-02019:未找到遠程數據庫的連接說明

來源:互聯網  2008-08-06 07:16:28  評論

1. 建立 DATABASE LINK

CREATE PUBLIC DATABASE LINK ABC

CONNECT TO SA IDENTIFIED BY PASSWORD

USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))';

2.測試

select * from test@ABC

3.請注意使用 DBLINK 時,INIT.ORA中 GLOBAL_NAME 的設置:

如果爲 ture , 請使用DBLINK的全稱,可在 all_db_links 中查到,如果爲 FALSE, 不必使用全稱,當出現

「ORA-02019:爲找到遠程數據庫的連接說明」時,請使用全稱,如:

select * from test@ABC.US.ORACLE.COM

4.SQL> select * from global_name;

GLOBAL_NAME

----------------------------------------------------------

LOCALSR

5. update global_name set GLOBAL_NAME = 'LOCALSR.US.ORACLE.COM' where GLOBAL_NAME = 'LOCALSR'

6.重啓例程>>ok

SQL> desc global_name;

Name Type Nullable Default Comments

----------- -------------- -------- ------- ---------------

GLOBAL_NAME VARCHAR2(4000) Y global database name

1. 建立 DATABASE LINK CREATE PUBLIC DATABASE LINK ABC CONNECT TO SA IDENTIFIED BY PASSWORD USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.100)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = AAA)))'; 2.測試 select * from [url=mailto:test@ABC]test@ABC[/url] 3.請注意使用 DBLINK 時,INIT.ORA中 GLOBAL_NAME 的設置: 如果爲 ture , 請使用DBLINK的全稱,可在 all_db_links 中查到,如果爲 FALSE, 不必使用全稱,當出現 「ORA-02019:爲找到遠程數據庫的連接說明」時,請使用全稱,如: select * from [url=mailto:test@ABC.US.ORACLE.COM]test@ABC.US.ORACLE.COM[/url] 4.SQL> select * from global_name; GLOBAL_NAME ---------------------------------------------------------- LOCALSR 5. update global_name set GLOBAL_NAME = 'LOCALSR.US.ORACLE.COM' where GLOBAL_NAME = 'LOCALSR' 6.重啓例程>>ok SQL> desc global_name; Name Type Nullable Default Comments ----------- -------------- -------- ------- --------------- GLOBAL_NAME VARCHAR2(4000) Y global database name
󰈣󰈤
王朝萬家燈火計劃
期待原創作者加盟
 
 
 
>>返回首頁<<
 
 
 
 
 熱帖排行
 
 
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有