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

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