ORA-04054: database link DB2 does not exist

Hi all,

I am stuck with a strange problem.

Basically, I have 3 databases: A, B, C

I have stored procedures stored in a package PK on C. I am trying to run those stored procedures from A, going through B (don't ask me why!).

I have of course a database link going from A to B - DB1 I have another db link from B to C - DB2.

I can call successfully the package/sp of C from B. That works fine, i.e. my db link DB2 works fine. I create a synonym (made it public) on B for the package PK, it works fine.

I am trying to run this synonym on A to run the PK located on C. If I call it directly like synonymofB_at_DB1 or if I create a synonym for the synonym on B, I get the same error:

ORA-04054: database link DB2 does not exist

This suggests for some reason that I cannot use DB2 from A. However, when calling the dual table of C, from A and going through the same path, it works fine. I cannot comprehend what's going on.

Any suggestions to help me? Thousands of thanks in advance.

Vincent Received on Tue Jun 25 2002 - 11:46:30 CEST