Modify the Oracle user password to never expire

Error tip: ora-28001:the password has expired (DBD Error:ocisessionbegin)

Workaround: Change the password to never expire

(1) Check the user's proifle is which, generally is default:sql>select username,profile from Dba_users;

(2) View password expiration settings for the specified profile (such as default): Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and Resource_name= ' Password_life_time ';

(3) Change the password validity period from the default of 180 days to "unlimited": ALTER profile default LIMIT password_life_time UNLIMITED; (Note: You do not need to restart the database after the modification, it takes effect immediately.) ）

(4) Test: Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

can see time as unlimited

Note: If the ORA-28001 error is also prompted after the modification, the user password can be modified again.

Modify the Oracle user password to never expire