Some times we may encounter with below error while we are trying to login to oracle database account.
We can unlock the account by using alter command, before that first we check the account status of DB users is as follows.
Step-1 : Login as sys/sysdba user
Step-2 : Execute the below command to know the account status of database users.
Step-3 : Execute the below command to unlock the database user account.
Account is unlocked and now you can able to login to account. Hope this helps.
We can unlock the account by using alter command, before that first we check the account status of DB users is as follows.
Step-1 : Login as sys/sysdba user
SQL> connect / as sysdba |
Step-2 : Execute the below command to know the account status of database users.
SQL> select username, account_status from dba_users; |
Step-3 : Execute the below command to unlock the database user account.
SQL> Alter user <User_Name> account unlock; //Here <User_Name> -Name of the oracle user |
No comments:
Post a Comment