build link to other data base

[yassinemannai]

hi,
I have two Oracle Server ( A and B )
I create table test in B.
I logged to A;
I create database link to B.
create databse link link_127 connect to system identified by manager using 'bibl';
(bibl is in tnsnames.ora )
I try to select data from test ( select * from test@link_127 ) the system generate error
ERREUR à la ligne 1:
ORA-02085: lien de base de données LINK_127 se connecte à ORACLE

 

[karluk]

According to the documentation, Ora 2085 occurs when global_names=true on the remote database, you define a db link, and give it a different name than the remote database's db name.

To fix the error you seem to have two choices: either create the link with the same name as the remote db, or set global_names to false. To find out the db name, run the following query on the remote db:

select * from global_name;

Whatever is returned from this query should be the exact name you use when creating the database link.

If you want to set global_names to false, you should modify your initialization parameter file, then shutdown and restart Oracle. Alternatively, you can temporarily change the value of this parameter with the command

alter system set global_names = false;

 

[yassinemannai]

HI karluk ,
thanks for your help,

the link with other oracle db succeeded

bye