| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dblink problem ( ORA-02019 )
Hi ratnesh,
try this checks first :
1.Check if the GLOBAL_NAMES=TRUE in init.ora parameter.
2.In the sqlnet.ora check whether the WORLD domain is mentioned in both.
3.Tnsnames.ora file ,the database name should be test.world like that.
4.How are you creating the database link with which qualifier you are using?Are you using the world domain or simply creating the link with a particular domain.
This is not clear.
IF you can send me exactly how you are creating the database link in both the databases we can know where you went wrong.
Anyway frist try the above check steps first.
Regards
Amjad.
PS: hey give my regards to Murtuza Chitalwala working in ur company (New Bombay). thanx.
-----Original Message-----
Kumar Singh
Sent: Wednesday, July 10, 2002 4:53 PM
To: Multiple recipients of list ORACLE-L
hi
i have 3 databases(A,B,X) on 3 diff boxes. i have created 1 dblink each from A to X & from B to X. The syntax for dblink creation is exactly same for both dblinks.
I am able to query from dblink A-X as "select * from user.table_at_dblinkAX"
but when i try to query from dblink B-X as "select * from
user.table_at_dblinkBX"
i get the foll error
Error: ORA-02019: connection description for remote database not found
When i modify my query by suffixing '.world' as "select * from user.table_at_dblinkBX.world" , the query works fine.
I have compared the entries in init,sqlnet,tnsnmames,listener files on both
A & B
databases and they are absolutely similar .
i was thinking that the domain or globalnames parameters might be diff on A
& B ,
but they are absolutely same .
any suggestions are most welcome ...
thanks in advance
ratnesh
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ratnesh Kumar Singh INET: ratnesh.singh_at_patni.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Wed Jul 10 2002 - 09:43:23 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amjad INET: amjad_at_medicomsoft.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |