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, but… Read More »SQLNET.EXPIRE_TIME, How and Why
Database Link
How to Resolve ORA-03113: end-of-file on communication channel
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-03113: end-of-file on communication channel
How to Resolve ORA-65016: FILE_NAME_CONVERT
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-65016: FILE_NAME_CONVERT
How to Resolve ORA-17629: Cannot connect to the remote database server
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-17629: Cannot connect to the remote database server
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
How to Resolve ORA-01017: invalid username/password; logon denied
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-01017: invalid username/password; logon denied
How to Resolve ORA-04063: view has errors
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 Resolve ORA-04063: view has errors
How to Migrate 9i to 12c via DB Link
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 Migrate 9i to 12c via DB Link
How to Resolve ORA-12899: value too large for column
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 »How to Resolve ORA-12899: value too large for column
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