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
Categories: 12c, 19c, Administration, Advanced features, Feature, Monitoring, OEM, ORA errors, Oracle 18c, Scripts
Adityanath's Oracle Blog 
Good blog! I really love how it is easy on my eyes and the data are well written. I am wondering how I might be notified when a new post has been made. I’ve subscribed to your RSS which must do the trick! Have a nice day!
Wonderful site. A lot of useful info here. I am sending it to a few friends ans also sharing in delicious. And obviously, thanks for your sweat!
Hey! Would you mind if I share your blog with my myspace group? There’s a lot of folks that I think would really appreciate your content. Please let me know. Cheers
Hello! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this post to him. Pretty sure he will have a good read. Many thanks for sharing!
I really wanted to compose a brief note to appreciate you for these fantastic tips and hints you are posting at this site. My incredibly long internet search has now been rewarded with sensible knowledge to talk about with my pals. I ‘d admit that most of us visitors are unquestionably fortunate to be in a decent community with so many marvellous people with good hints. I feel rather grateful to have seen your entire site and look forward to really more brilliant minutes reading here. Thank you once again for a lot of things.
Wow! Thank you! I constantly wanted to write on my website something like that. Can I implement a fragment of your post to my blog?
magnificent post, very informative. I wonder why the other experts of this sector do not notice this. You should continue your writing. I’m confident, you’ve a huge readers’ base already!
You got a very superb website, Glad I found it through yahoo.
Enjoyed reading this, very good stuff, appreciate it.
I savor, cause I found exactly what I used to be having a look for. You have ended my four day long hunt! God Bless you man. Have a nice day. Bye