Oracle password expires - cancel password 180 days limit

1. Enter sqlplus mode:

Sqlplus / as sysdba;

2. View the validity settings of user passwords (DEFAULT is the default configuration file).

SELECT * FROM dba_profiles WHERE profile='DEFAULT'and resource_name='PASSWORD_LIFE_TIME';

3. Change the password validity period from the default 180 days to "unlimited". After the modification, the database does not need to be restarted, and it will take effect immediately:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. Account password change again. Alter the user username identified by original password.

5. Log in with the modified user and unlock if the message 'ORA-28000: The user has been locked'

Alter user db_user account unlock;

Commit;