ORA-28000: the account is locked ora error
FranklinFaces.com
FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals
 Home          Members     Calendar     Who's On

Welcome Guest ( Login | Register )
        



ORA-28000: the account is locked ora error Expand / Collapse
Message
Posted 6/11/2010 11:20:00 AM Post #221
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being
ORA-28000: the account is locked

Cause: The user has entered wrong password consequently for maximum number of 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

When you get this ora error and, if you want to unlock account called SCOTT follow these steps.

From your command prompt, type
sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the SCOTT account

SQL> alter user scott account unlock;

Posted 6/22/2010 1:15:42 PM Post #414
 

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

ORA-28000:

the account is locked
Cause:The user has entered wrong password consequently for maximum number of 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
 
ORA 28000
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: silencer

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 2:22pm

Powered By InstantForum.NET v4.1.4 © 2010
Execution: 0.084. 12 queries. Compression Disabled.