Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. After upgrading to Aleph 23 and Oracle 12c the Oracle user ABC50 is regularly locked

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    3. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • After upgrading the GUI to Service Pack 21.1.07 the users cannot connect (Error: global -5 'cannot connect to server')
      • After upgrading to v22: "Order does not exist for this record" error message in GUI
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved