SQLNET.EXPIRE_TIME, How and Why
Unresponsive DB Link A dead DB link means an unresponsive remote connection between databases. In fact, the db link may have finished his job without… Read More »SQLNET.EXPIRE_TIME, How and Why
Database Link
How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server
ORA-17628 In some situations, you might see errors like the following when cloning a remote pluggable database (PDB): SQL> create pluggable database finance_pdb from finanpdb@link_to_test1… Read More »How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server
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
DB Link, How and Why
What is DB Link? A database link is a kind of schema object in a database that enables users to access and manipulate objects on… Read More »DB Link, How and Why
Create DB Links for Another User, Can We?
The answer is no, at least, not directly. You can see the reason why we can't create database links for another user in this post.… Read More »Create DB Links for Another User, Can We?
How to Resolve ORA-02080: database link is in use
ORA-02080 ORA-02080 means that the open database link you want to close is in use, you have to close the open transaction in a distributed… Read More »How to Resolve ORA-02080: database link is in use
How to Resolve ORA-02020: too many database links in use
ORA-02020 ORA-02020 means that the database limits the number of open database links on every session. You can widen the restrictions for later use. For… Read More »How to Resolve ORA-02020: too many database links in use
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
How to Resolve ORA-01034: ORACLE not available
ORA-01034 ORA-01034 means that the command you want to perform cannot be done in a stop, idle or shutdown database. If you're surprised by the… Read More »How to Resolve ORA-01034: ORACLE not available