Database command to unlock an user in OIM

When a user administrator is locked it needs another administrator to unlock the account from the admin console.

If there is only one admin user and it it is locked or disabled,the only possible way to enable the account is by executing the query in the OIM

Login to database machine and exxecute the SQL query

SQL> UPDATE USR SET USR_LOCKED=0,USR_LOGIN_ATTEMPTS_CTR=0 WHERE USR_LOGIN='XELSYSADM';
SQL> update USR set usr_status='Active' where USR_LOGIN='XELSYSADM';
SQL> update USR set usr_end_date='' where USR_LOGIN='XELSYSADM';
SQL> update USR set usr_disabled='0' where USR_LOGIN='XELSYSADM';
SQL> commit;