How Can We Help?

Search for answers or browse our knowledge base.

Documentation | Demos | Support

< All Topics

Error: “ORA-28000: the account is locked” in Symantec DLP Enforce

There are two ways to unlock the Oracle database account:

  • From the Oracle Enterprise Manager
  • From the command line using SQL*Plus

Unlock using Oracle Enterprise Manager

  1. From the Oracle Enterprise Manager, select Network > Databases > Security > Users.
  2. Edit the protect user, then select the unlocked radio button.

Unlock from the command line using SQL*Plus

  1. Load SQL*Plus.
  2. Check what is locked and what is not locked with the following command:
    select username,account_status from dba_users;

    Note: Remember to add the semicolon or the command will not execute.

  3. To unlock the [username] (without brackets) account, enter the following command:
    alter user [username] account unlock;
  4. Rerun step 2 to verify success.
Was this article helpful?
5 out of 5 stars
5 Stars 100%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents