Oracle 11g password expired locked reporting ORA-28000 the account is locked

Oracle 11g password expired locked reporting ORA-28000 the account is locked

I. Reasons for triggering this error and Related Factors

It is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in Oracle 11g by default. in Oracle 11g, there is a password expiration problem.

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_TIMEUNLIMITED;

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.

5. 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.

--------------------------------------------------------------------------------

Solution to Oracle user password expiration and user lock

Password expired ORA-28002 troubleshooting

ORA-28002 Password Expiration Warning

The ORA-28002 password will expire in 7 days

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

--------------------------------------------------------------------------------