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-03113: end-of-file on communication channel

by Ed Chen
November 12, 2021October 23, 2022

ORA-03113 Found ORA-03113 when we try to operate with the database. Let's see the case. First of all, we performed a query, meanwhile, the database… Read More »

How to Resolve ORA-65016: FILE_NAME_CONVERT

by Ed Chen
September 3, 2021November 12, 2021

ORA-65016 and ORA-65180 Tried to clone a remote PDB with the same name and path and got ORA-65016 like this. SQL> create pluggable database ORCLPDB… Read More »

How to Resolve ORA-17629: Cannot connect to the remote database server

by Ed Chen
September 1, 2021May 8, 2023

ORA-17629 ORA-17629 means that it cannot connect to the remote database because of some underlying errors occurred, most likely, there're some error returned. In the… 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 »

How to Resolve ORA-01017: invalid username/password; logon denied

by Ed Chen
January 18, 2020April 5, 2023
4 Comments

ORA-01017 ORA-01017 means that you either provided an incorrect pair of username and password, or mismatched authentication protocol, so the database that you tried to… Read More »

How to Resolve ORA-04063: view has errors

by Ed Chen
December 7, 2019May 26, 2023

ORA-04063 ORA-04063 means the view that you want to grant to someone else has compile error, so the database cannot grant it to other users.… Read More »

How to Migrate 9i to 12c via DB Link

by Ed Chen
November 16, 2019March 27, 2023

Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »

How to Resolve ORA-12899: value too large for column

by Ed Chen
November 13, 2019December 10, 2022

ORA-12899 ORA-12899 means that the value of being inserted or updated data is larger than column's allowable length that is defined in the table. What… Read More »

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