Databaselinks suddenly stopped working

Hi to all,

Just a quick question;

I created 4 databaselinks on a vs 8 server - 1 to another vs 8 server and 3 to a vs 9.2 server.

All worled fine for some weeks but suddenly the 3 to to vs 92 server stopped working. . . .

I created them by scripts;
CREATE PUBLIC DATABASE LINK "ORCL" CONNECT TO "USER"
IDENTIFIED BY "password"
USING 'ORCL_servername.EU.domain.COM'

The USING part is the TNS entry on the server where the DBlinks are situated and using it ( SQL*PLUS ) everything works fine.

Any suggestion where to look. . . .

Guus

What error message do you get if you

select sysdate from dual@DB_LINK;

SQL> select sysdate from dual@orcl;
select sysdate from dual@orcl
*
FOUT in regel 1:
.ORA-02085: database link ORCL.US.ORACLE.COM connects to ARUBA.WORLD

this is another domain as the vs 8 server

...Made a small progress myself;

Creating a DB link to a higher version I had to use the global_name from the target server ( select global_name from global_name ).

There is just one slight problem;

If the global_name has NO extention like .WORLD the database link will be automaticly created with de .US.ORACLE.COM in the databaselink-name.
In this case it differs from the glodal_name on the target server and won't match !!

I'd like to know how to get rid of the .US.ORACLE.COM in the databaselink-name ????

Creating the link by script or using OEM doesn't make any differance. . .

Guus

Can you show me the output of

select * from dba_db_links;

Try setting global_names to false.

Quote:

---

Originally Posted by ixion

Try setting global_names to false.

---

True, however he may need this set... and we have global_names set to true and dblinks work just fine, so i'd suggest trying other things before changing this...

Can you also tell me the output of:

sho parameter name
sho parameter dom