DG standby: account-status OPEN but login fails with “ORA-28000: the account is locked”
top of page
To see this working, head to your live site.
“ORA-28000: the account is locked” though user account is in OPEN state in ADG – Active Data Guard Environment
“ORA-28000: the account is locked” though user account is in OPEN state in ADG – Active Data Guard Environment
1 answer0 replies
Like
1 Comment
bottom of page
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.