The period for changing the Oracle password is unlimited.

The period for changing the Oracle password is unlimited.

Oracle error message ORA-28001: the password has expired, due to new features of Oracle11G, the default password expiration limit for Oracle 11g User Creation is 180 days (6 months ), if the user password is not modified for more than 180 days, the user cannot log on.

Oracle introduces this default function in 11 GB by default for database security. However, this default function is easily neglected by DBAs or developers. Once the password is not modified for 180 days, this problem occurs.

Solution:

Use the following statement to view the proifle

SELECT username, profile from dba_users;

You can use the following SQL statement to query the password validity period settings. The LIMIT field is the password validity period.

SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME ';

When the password is about to expire or has expired, use the following statement to modify the password. After the password is changed, the user can connect to the database normally.

Alter user Username identified by password

To remove the 180-day password lifecycle restriction, use the following SQL statement to disable ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

The above SQL statement changes the default password validity period from 180 days to "unlimited ". For the sake of database security, we do not recommend that you set PASSWORD_LIFE_TIME to UNLIMITED. We recommend that you modify the password of a database user on a regular basis.

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

Oracle input error count modification, user unlock, password expiration

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

This article permanently updates the link address: