Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORA-28000 Unlocking an Oracle User

    • Product: Voyager
    • Product Version: All

    Problem Symptoms:

    ORA-28000 error message when starting tomcat:java.sql.SQLException: ORA-28000: the account is locked

    ORA-28000: the account is locked when connecting to database from Prepackaged Reports

    Cause

    Oracle user is locked

     

    Resolution

    1. Note {username} of locked user.
    2. Log into the server as the oracle Unix user
    3. Connect to SQLPlus as the sysdba user: sqlplus '/ as sysdba'
    4. ALTER USER {username} ACCOUNT UNLOCK
    5. quit

    • Article last edited: 19-May-2016