How to Unlock OIM Schema.

To view schema name and status:

SELECT username, account_status FROM dba_users;

Unlock Schema:

ALTER USER <Schema_Name>_OIM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_MDS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_OPSS ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_ORASDPM ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_SOAINFRA ACCOUNT UNLOCK;
ALTER USER <Schema_Name>_BIPLATFORM ACCOUNT UNLOCK;