Odi's astoundingly incomplete notes
New entries | CodeOracle hangs on login of one user
I just troubleshooted the strangest Oracle issue. Logon with a certain user simply hangs and eventually returns with
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.
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.
Add comment