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