This shows how to deal with a locked APPS user (or other user) in oracle.
Make sure the database is started.
Using sqlplus log in as SYSDBA user. (There should be no password.)
run
- 
ALTER USER APPS ACCOUNT UNLOCK;
 - 
commit;
 
Now it should work
References
http://onlineappsdba.com/index.php/2008/05/15/sso-how-to-deal-with-your…
http://download.oracle.com/docs/cd/B10501_01/win.920/a95490/username.htm
http://sabdarsyed.blogspot.com/2008/09/how-we-resolved-account-locked-t…
RJM Article Type
              Quick Reference