Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-28000: the account is locked

772940Aug 1 2010 — edited Aug 3 2010
I am getting this error when trying to login into Oracle SQL * Plus with system user . I tried to connect with a different user as sysdba and executed the following statement.

alter user system identified by <pwd>account unlock;

The statement returns "user altered". In the same window I am able to disconnect the current user and connect with system user.

But when I again start a new Oracle sQL * pLUS window I am not able to login with "system" user. It gives the same account locked error.

Any help is greatly appreciated.

Thank you,
Praveen
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 31 2010
Added on Aug 1 2010
8 comments
1,437 views