Modification of Oracle 11G Password after 180 Days Expiration

Due to the new features of Oracle11G, it is often encountered that "ORA-28002: Password will expire after 7 days" when logging in to oracle database with sqlplus. When creating a user in Oracle 11G, the default password expiration limit is 180 days. If the user password is not modified for more than 180 days, the user cannot log in, prompting "ORA-28001: the password has expired"

After the password expires, the business process connects to the database abnormally, which will inevitably affect the use and login.

Emancipation method:

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

1. View the expiration date setting of the user password (1. The default configuration file is DEFAULT)

SQL > SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME'

2. Change the password validity period from the default 180 days to "unlimited", and it will take effect immediately without restarting the database after modification

SQL > Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

3. Change your account password once more

SQL > alter user ink identified by < Original password > ----No need to change your password

4. Log in with the modified user. If you report "ORA-28000: User has been locked", unlock it

SQL > alter user db_user account unlock;

SQL > commit;