GLOBAL_NAMES Parameter and its impact on oracle database (ORA-02085)

 

 

 

Remote database name: UPGR (database link is made to connect to this database)

On Local database 

set the parameter global_names

 This will make sure that connection to remote db is allowed only if db link name match with global_name of remote database

show parameter

global_names                         boolean     TRUE

Get global name from remote database

select * from global_name;

GLOBAL_NAME
-----------------------
UPGR

Create a test database link on the local database with any name and test

Create a database link with any name

create database link 

a 

connect to 

test identified by *** 

using 'tst:1521/UPGR' ;

Database link created.

SQL> select * from a@a ;
select * from a@a
                *
ERROR at line 1:
ORA-02085: database link A connects to UPGR


SQL> drop database link a ;

Database link dropped.

Create a database link with same name as remote database global_name

SQL> create database link upgr connect to test identified by **** using 'tst:1521/UPGR' ;

Database link created.

select * from a@upgr ;

A
----------
aa
aa
aa

When db link name and remote global name is matching it will allow and you can get result