Wednesday 5 November 2014

ORA-28000 the account is Locked/Expired in Oracle SQL Developer

Sometimes when we use SQL Developer after a long time some schemas will get locked as shown in the Image Below. we need to unlock schemas so that we can make use of that schemas.


We can Even observe the status of all the LOCKED and EXPIRED accounts by using the Below Query
select username,account_status from dba_users;


To Unlock the schemas we need  to follow the below procedure
  1. Open SQL*Plus
  2. then login to SYS as SYSDBA with administrators Password.
  3. Then use the following Command
    ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY hr;
    
    
    You Can Even Refer to the below ScreenShot as well.


12 comments :

  1. Pretty section of content. I simply stumbled upon your site and in accession capital to say that I get actually loved to account your blog posts.
    Data Warehousing Training in Chennai

    ReplyDelete
  2. Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website.
    Digital Marketing online training

    full stack developer training in pune

    full stack developer training in annanagar

    full stack developer training in tambaram

    full stack developer training in velachery

    ReplyDelete
  3. Well researched article and I appreciate this. The blog is subscribed and will see new topics soon.
    python training in OMR
    python training in Bangalore
    python training in Bangalore

    ReplyDelete
  4. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    angularjs-Training in pune

    angularjs-Training in chennai

    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    ReplyDelete
  5. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.

    AWS Interview Questions And Answers

    AWS Training in Pune | Best Amazon Web Services Training in Pune

    AWS Training in Chennai |Best Amazon Web Services Training in Chennai


    AWS Training in Chennai | Best AWS Training in Chennai


    Amazon Web Services Training in Pune | Best AWS Training in Pune

    ReplyDelete
  6. I prefer to study this kind of material. Nicely written information in this post, the quality of content is fine and the conclusion is lovely. Things are very open and intensely clear explanation of issues
    Microsoft Azure online training
    Selenium online training
    Java online training
    Java Script online training
    Share Point online training

    ReplyDelete
  7. It's a wonderful post and very helpful, thanks for all this information about Java. You are including better information regarding this topic in an effective way. good luck.
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  8. This is really an awesome post, thanks for it. Keep adding more information to this. oracle training in chennai

    ReplyDelete