The ORA-28000 account is locked and unlocked

Today, I forgot my password for an account in the test database. After a dozen attempts, I started to prompt:

ERROR:
ORA-28000: the account is locked

This means that the account is locked. It may be because the user's resource settings limit the number of password retries.

Verification:

SQL> select a. username, B. profile, B. resource_name, B. limit
2 from dba_users a, dba_profiles B
3 where a. username = 'galttest' and a. profile = B. profile;
Galttest default COMPOSITE_LIMIT UNLIMITED
Galttest default SESSIONS_PER_USER UNLIMITED
Galttest default CPU_PER_SESSION UNLIMITED
Galttest default CPU_PER_CALL UNLIMITED
Galttest default LOGICAL_READS_PER_SESSION UNLIMITED
Galttest default LOGICAL_READS_PER_CALL UNLIMITED
Galttest default IDLE_TIME UNLIMITED
Galttest default CONNECT_TIME UNLIMITED
Galttest default PRIVATE_SGA UNLIMITED
Galttest default FAILED_LOGIN_ATTEMPTS 10
Galttest default PASSWORD_LIFE_TIME 180
Galttest default PASSWORD_REUSE_TIME UNLIMITED
Galttest default PASSWORD_REUSE_MAX UNLIMITED
Galttest default PASSWORD_VERIFY_FUNCTION NULL
Galttest default PASSWORD_LOCK_TIME 1
Galttest default PASSWORD_GRACE_TIME 7

In this case, only 10 attempts are allowed, and the account will be locked.

There are many unlocking methods. Unlocking through PLSQL Developer may be the simplest and most intuitive.

1. log on to PLSQL Developer with the Administrator account (the login name can be system, and change Normal to Sysdba when selecting the type ).

2. Select My Objects on the left side to view the Users folder.

3. Select the GALTTEST user and right-click "edit".

4. Remove the "account locked" check box (you can also change the password ).

5. Click "application" and then "close ";

6. Log On again and you will be able to pass the verification;

In fact, it is easy to use the sqlplus command line to unlock. log on to the account sysdba as the administrator and execute alter user GALTTEST account unlock; to unlock the account.

In addition, you can use the following command to modify the FAILED_LOGIN_ATTEMPTS attribute value of profile to limit the number of retries.

Alter profile default LIMITFAILED_LOGIN_ATTEMPTS UNLIMITED

Appendix: SQL statement used to create a profile:

Create profile test limit;