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.
Previous Converting your LOB tables from BasicFiles to SecureFiles format in Symantec Data Loss Prevention 14.6 and 15.x:
Next How to change the “protect” user password in the Oracle database for Symantec DLP
Table of Contents