Dear Readers,
Trust you are doing well & safe!!!
In this post we are going to discuss about weird issue I faced for a user account in Active Data Guard (ADG) environment.
A user was receiving “ORA-28000: the account is locked” while connecting to ADG environment from SQL Developer.
When I checked account_status from DBA_USERS on ADG site, it was in OPEN state. Same case was with PROD site as well.
On Primary:
SQL> select account_status from dba_users where username=’JACK_SPARROW’;
OPEN
On Standby:
SQL> select account_status from dba_users where username=’JACK_SPARROW’;
OPEN
Now this is weird!!! What is the issue & how to resolve it???
After checking in MOS, I found a note explaining similar behavior: DG standby: account-status OPEN but login fails with “ORA-28000: the account is locked” (Doc ID 2718878.1)
According to this note, this is expected behavior wherein user explicitly attempted failed login attempts on ADG environment.
As account_status is in OPEN state, DBA_USERS On Standby DB, will give ACCOUNT_STATUS as OPEN because it is synced from Primary. You may need to query v_$RO_USER_ACCOUNT to get correct information on ADG.
Now you can explicitly run below command to unlock user on ADG:
alter user JACK_SPARROW account unlock;
After this user was able to successfully connect to ADG database.
Hope u will find this post very useful.
Cheers
Regards,
Adityanath
Adityanath's Database & Cloud Blog 
Leave a reply to Anonymous Cancel reply