1) Determine the owner name of the user who is having the lockout problem. This example uses MI99AA (not a real user).
2) Load SQL*Plus and connect to the server (UW2) as the system user.
3) Issue the following command to see the status of licenses:
select licensenumber,inuse from MI99AA.camuserlicenses;
4) At least one of the licenses should show InUse as Y. If all of the licenses show InUse as N, then there is no locking problem.
5) To release the locks, use these commands:
update MI99AA.camuserlicenses set inuse = 'N';
commit;
6) To check the change, exit SQL*Plus and then repeat steps 1-3. All values for inuse should now be N.