Database Link

How to Resolve ORA-01729: database link name expected

by Ed Chen
May 23, 2023May 26, 2023

ORA-01729 Tried to create a database link wich is able to connect to a remote database, but it failed with ORA-01729. Reserved Word SQL> create… Read More »

SQLNET.EXPIRE_TIME, How and Why

by Ed Chen
April 27, 2022April 26, 2023

Unresponsive DB Link A dead DB link means an unresponsive remote connection between databases. In fact, the db link may have finished his job, but… Read More »

How to Resolve ORA-17628: Oracle error 1031 returned by remote Oracle server

by Ed Chen
November 16, 2020April 14, 2023
2 Comments

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 »

What GLOBAL_NAMES do to DB Links

by Ed Chen
July 2, 2019December 10, 2022

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 »

DB Link, How and Why

by Ed Chen
March 30, 2019May 9, 2023

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 »

Create DB Links for Another User, Can We?

by Ed Chen
July 27, 2018December 10, 2022

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 »

How to Resolve ORA-02080: database link is in use

by Ed Chen
January 3, 2018August 27, 2021

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-02020: too many database links in use

by Ed Chen
January 3, 2018August 1, 2022

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-02085: database link SOURCE_LINK connects to SOURCE_DATABASE

by Ed Chen
December 19, 2016May 18, 2023
4 Comments

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-01034: ORACLE not available

by Ed Chen
June 21, 2014March 29, 2022

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 »

JavaScript is not enabled. Please enable it and reload the page.