Oracle account password expires and is modified to unlimited

1. See what the user's proifle is, which is usually default:

   Sql>select username,profile from Dba_users;

2. To view the password expiration settings for a 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;

   You do not need to restart the database after you modify it, it takes effect immediately.

4. After modification, the account that has not been prompted ORA-28002 warning will not encounter the same prompt again;

   The account that has been prompted must change the password again, for example:

   $sqlplus/as SYSDBA

   sql> alter user SMSC identified by < original password >----do not change the new password

Oracle account password expires and is modified to unlimited