Account locked but I see it open 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 &lt;username&gt; IDENTIFIED BY &lt;password&gt;) 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).
Try running the following from sqlplus and posting the results.

select username, account_status, lock_date, expiry_date from dba_users where username='&lt;your user name&gt;';
select instance_name, host_name from v$instance;

set term off
set serveroutput on
set long 10000000
set trimspool on
set tab off
set linesize 190
set pagesize  50
set feedback  on
set editfile "/tmp/_USER_CONNECT_IDENTIFIER_PRIVILEGE.buf"
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER _PRIVILEGE&gt; "
set timing on
set term on