Results 1 to 4 of 4
  1. #1
    Join Date
    May 2012
    Posts
    13

    Unanswered: error comes ora-28000: the account is locked

    Hi guys
    Whenever I tried to logon sqlplus from my 32_bit window 7
    Error comes ORA-28000 : the account is locked




    Please help me,

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    What's the question?
    The error message is unambiguous: the account is locked. You have to unlock it.

  3. #3
    Join Date
    May 2012
    Posts
    13
    How to unlock account ?????

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Log in as "system", then run
    Code:
    ALTER USER the_username_you_use ACCOUNT UNLOCK
    More details in the manual:

    http://docs.oracle.com/cd/B28359_01/...3.htm#i2058207

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •