I have an issue with my database Oracle 11gR2.
When I try to connect to my database via SQL Developer, it says that my account is locked after too many missed connections due to a wrong password but when I use the query
SELECT username, account_status FROM dba_users
on SQLPlus, the account is OPEN. I tried to unlock/lock/unlock the account without success.
This problem comes after the expiry of passwords. I've changed them via SQLPlus (with the command
ALTER USER <username> IDENTIFIED BY <password>) but when I wanted to connect with my new password on SQL Developer, I had the error message
ORA-01017 Invalid Username/Password.
(and if I put the old password, I had the error message "expired password".)
I would like to know how to unlock the locked account (even though I see it open).