With user SYS Login in to your DB :
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 25 15:13:25 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Then issue
alter user scott account unlock;
Then you will be able to login as scott.
conn scott/tiger