Oracle 11g error ORA-28000 the account is locked

I. Reasons for triggering this error and Related Factors

This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle 11g by default.
The password has expired.

Ii. Error:

After the user is locked, A ORA-28000 error is reported, prompting that the user cannot log on to the database
SQL> conn system/oracle
ERROR:
ORA-28000: the account is locked

Warning: You are no longer connected to ORACLE.
SQL>

Iii. solution:

Follow these steps:

1. Check the user's proifle, which is generally default:

SQL> select username, profile from dba_users where username = 'system ';

USERNAME PROFILE
------------------------------------------------------------
SYSTEM DEFAULT

SQL>

2. view the password validity period settings of the specified profile (such as default:

SQL> SELECT * FROM dba_profiles s WHERE s. profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180DAY

3. Change the password validity period from the default 180 days to"Unlimited":

SQL> ALTER PROFILE DEFAULT LIMITPASSWORD_LIFE_TIME UNLIMITED;

After modification, the database does not need to be restarted and takes effect immediately.

4. After modification, the account has not been prompted ORA-28002 warning will not again encounter the same prompt;

You only need to unlock the account that has been prompted.

$ Sqlplus/as sysdba

SQL> alter user system account unlock;

User altered.

If you still cannot log on, execute the configuration again and the password will be OK. (Just like the original password)

SQL> alter user system identified by oracle;

User altered.

Whether set to false or true, the oracle 11g startup parameter resource_limit takes effect for the password validity period. Therefore, you must modify the password in the preceding way. The preceding account name must be changed based on the actual account name.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12