Tuesday, November 6, 2007

ORACLE ERROR: ORA-28000: The account is locked

One of my colleagues is getting the following error when tried to logging into a business object which using oracle database, and got this error. Finally a quick web search gave the solution.

Cause: The user has entered wrong password consequently for maximum number if times specified by the user’s profile parameter FAILED_LOGIN_ATTEMPTS or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA

DBA must unlock these accounts to make them available to users. Look at the script below to unlock a user:
ALTER USER ejuly ACCOUNT LOCK -- lock a user account

But do take note with a case-sensitive name. Look at the script below then you can see the different more clearly.
SQL> create user "ejuly" identified by ejuly account lock;
User created.

SQL> select username, account_status from dba_users where username='ejuly';
USERNAME ACCOUNT_STATUS
----------------- ---------------------
ejuly LOCKED

SQL> alter user ejuly account unlock;
alter user ejuly account unlock
*
ERROR at line 1:
ORA-01918: user 'EJULY' does not exist

SQL> alter user "ejuly" account unlock;
User altered.

SQL>

1 comments:

truonglv on April 19, 2009 at 2:05 AM said...

I can access isqlplus by account HR, OE, Scott but SYS anf SYSTEM.
ERROR - ORA-01017: invalid username/password; logon denied (when i access by acoount SYS)
ERROR - ORA-28000: the account is locked (when i access by acoount SYSTEM).
'alter user put the name of the user account unlock;'
Error 01031: insufficient privileges
You can help me.
Email:truonglv@yahoo.com

 

Get paid for your opinions! Click on the banner above to join Planet Pulse. Its totally free to sign up, and you can earn UNLIMITED. Find out more by visiting PLANET PULSE.
July Code Blog Copyright © 2010 Blogger Template Designed by Bie Blogger Template