What GLOBAL_NAMES do to DB Links
GLOBAL_NAMES Normally, we turned off GLOBAL_NAMES to prevent additional check on remote database before connecting to it. This is because we know where we are… Read More »What GLOBAL_NAMES do to DB Links
GLOBAL_NAMES
How to Configure SID_LIST_LISTENER Static Listener
SID_LIST_LISTENER Dynamic service is a representative which is registered with the listener when the instance is up and running on the server, whereas static service… Read More »How to Configure SID_LIST_LISTENER Static Listener
How to Resolve ORA-02082: a loopback database link must have a connection qualifier
ORA-02082 When I tried to create a database link, it threw ORA-02082. SQL> create public database link BOSTON connect to SCOTT identified by SCOTT using… Read More »How to Resolve ORA-02082: a loopback database link must have a connection qualifier
How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link;… Read More »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE