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