How to Resolve DB Link Hang or Die
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 »How to Resolve DB Link Hang or Die
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 Error Message
ORA-17628: Oracle error 1031 returned by remote Oracle server In some situations, you might see errors like the following when cloning a remote pluggable database… Read More »How to Resolve ORA-17628 Error Message
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. Let's… 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