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

    ue_01_z0102 process stops after 2000 records; account is locked; CTXSYS

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Problem Symptoms:
    Our version 18 ue_01_z0102 process is stopping after processing 2000 records:

    cd $data_scratch
    grep -c HANDLING *run_e_01_z0102*

    run_e_01_z0102.12005:2000
    run_e_01_z0102.14552:2000
    run_e_01_z0102.15486:2000

    There's no indication in the log of any error, but util c/1 and "ps -ef / grep z0102" show that the ue_01_z0102 process no longer exists.

    The other two ue_01 processes seem to be working fine.

    Cause:
    CTXSYS account locked.

    Resolution:
    This happens because the CTXSYS account is locked: in each of the run_e_01_z0102 logs we see this after 1000 times HANDLING:

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

    Then, for some reason, it gets stuck the second time (another 1000 times).

    This was an upgrade problem, and did not occur again once it was fixed (unlocked).

    The fix is the following:

    s+ aleph_admin
    alter user CTXSYS identified by CTXSYS account unlock;
    exit;

    Additional Information

    If user aleph_admin doesn't have enough privilege, then use an Oracle log-in which does.

    In another case, the symptom was the same except that the message "invalid username/password" appeared after 1000 lines instead of "account is locked".

    Category: Background processing (500)

    Subject: Ue (500)


    • Article last edited: 10/8/2013