- Article Type: General
- Product: Aleph
- Product Version: 18.01
Our version 18 ue_01_z0102 process is stopping after processing 2000 records:
grep -c HANDLING *run_e_01_z0102*
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.
CTXSYS account locked.
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:
alter user CTXSYS identified by CTXSYS account unlock;
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