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

    After upgrading to Aleph 23 and Oracle 12c the Oracle user ABC50 is regularly locked

    • Product: Aleph
    • Product Version: 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

     

    Description

    After upgrading to Aleph 23 and Oracle 12c the Oracle user ABC50 is regularly locked

     

    Error:

    Oracle error: handle_connection
    ORA-28000: the account is locked

    Resolution

    Cause

    In Oracle 12c the passwords are stored case sensitive (standard: in capital letters)

     

    Resolution

    If your database is accessed from customized scripts, make sure to update the passwords to the correct writing, otherwise the user will be locked after 5 failed attempts

     

    Example

    sqlplus ABC50/ABC50

     

    instead of

    sqlplus abc50/abc50

     

     

     

    Additional Information

    In order to unlock the locked user please execute the following

     

    Identify possible locked users

    > s+ aleph_admin
    SQL> select USERNAME,ACCOUNT_STATUS from dba_users where ACCOUNT_STATUS not like 'OPEN';

     

    Unlock the account

    SQL> alter user ABC50 identified by ABC50 account unlock;

     

    See also article How to identify a locked Oracle user and unlock it

     


    • Article last edited: 19-April-2016
    //Feedback