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:
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
Post a Comment