Today's business colleagues reported a password expiration issue, the workaround is as follows:
The default password validity password_life_time default value is 180 days.
Set pagesize 9999
Set Linesize 132
SELECT * from Dba_profiles WHERE profile= ' DEFAULT ' and resource_name= ' password_life_time ';
Profile Resource_name RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT Password_life_time PASSWORD 180
Modify Password_life_time to unlimited;
ALTER profile DEFAULT LIMIT password_life_time UNLIMITED;
After modification:
SELECT * from Dba_profiles WHERE profile= ' DEFAULT ' and resource_name= ' password_life_time ';
Profile Resource_name RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT password_life_time PASSWORD UNLIMITED
Dba_profiles View:
This view provides information about the user's profile and is the best assistant for the DBA to manage user resource assignments, such as controlling the CPU that the session or SQL can use, controlling the user's password management policy, and so on.
After the database is created, the system has a default profile named defaults, which, if not specified, is the default
View Dba_profiles to find out which profiles are in the database
ORACLE11GR2 Default password retention days