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
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?
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
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
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
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