Recovering locked accounts or forgotten password accounts in oracle

1. Find the service ID from command line CMD=> type lsnrctl status
2. Find the active instance
3. set oracle_sid = "<SID>"
4. log as sqlplus "/as sysdba"
5. Then connect => conn <user_name>@<sid>
6. Alter user <user_name>;
7. Alter password identified by <user_name>;

simple as that...