Oracle TIP error message ora-28001:the password has expired

First of all. The problem-solving method can be e.g by using the ALTER user username identified by password.

1 ALTER USER  by PBMs

Enter the following command:

1 Select *  from where profile='DEFAULT' and resource_name=  'password_life_time'

The results show that the password is valid for 180 days, due to the new features of Oracle 11G, the default password expiration limit for Oracle 11G when creating a user is 180 days, and if the user password is not modified for more than 180 days, the user cannot log on. Long-term correspondence can be achieved by:

1 ALTER DEFAULT LIMIT Password_life_time UNLIMITED;

Statement to change the password expiration value by 180 days to unlimited. For database security reasons, it is not recommended to set the Password_life_time value to unlimited, and it is recommended that customers periodically modify the database user password.

Oracle TIP error message ora-28001:the password has expired