Odi's astoundingly incomplete notes

New entries | Code

Oracle hangs on login of one user

I just troubleshooted the strangest Oracle issue. Logon with a certain user simply hangs and eventually returns with ORA-03135. In v$session you can see many sessions waiting on library cache lock. Their current sql statement is a select from sysauth$.

DBA and Oracle consultants were unable to find the problem.

Until I noticed that the password in my datasource was simply wrong. The application tried to open many connections at the same time (to populate its pool). Probably it's a deadlock in Oracle's Auditing for failed logons.

posted on 2016-06-28 10:59 UTC in Code | 0 comments | permalink