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