Month: May 2017

Legacy users get ORA-01017 in 12.2

Post author By Laurent Schneider
Post date May 22, 2017
3 Comments on Legacy users get ORA-01017 in 12.2

10g value string disappeared

remote transaction timeout

Post author By Laurent Schneider
Post date May 5, 2017

If you access one table via database link and the row is locked, you may get a timeout SQL> update emp@l set sal=sal+1 where ename=’SCOTT’; 1 row updated. SQL> update emp@l set sal=sal+2 where ename=’SCOTT’; update emp@l set sal=sal+2 * ERROR at line 1: ORA-02049: timeout: distributed transaction waiting for lock ORA-02063: preceding line from […]