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