This article is showing how to resolve issue when query has an issue during its execution with database link.
When the query works with “.world” on the db link name, but it doesn’t work without “.world”.
Example) This has been tested on Oracle Database 12.2
17:14:27 TESTDB> select 1 from dual@SIMPLE;
select 1 from dual@SIMPLE
ERROR at line 1:
ORA-02019: connection description for remote database not found
17:14:40 TESTDB> select 1 from dual@SIMPLE.world;
Then, the global name setting should be checked :
17:20:58 TESTDB> select * from global_name;
There is no “.world” at the end of the global_name. So just this simply can be updated with the following command. (No database bounce required)
17:21:58 TESTDB> ALTER DATABASE RENAME GLOBAL_NAME TO TESTDB.WORLD;
17:21:28 TESTDB> select * from global_name;
17:21:28 TESTDB> select 1 from dual@SIMPLE;
FYI, this is not related with db domain name setting. If db_domain is changed, then you will need to change lots of things such as db service names, listeners, and so on. Please don’t touch db_domain name for only this “.world” on db link name issue.
17:22:03 TESTDB> show parameter domain
NAME TYPE VALUE
———————————— ———- ——————————