Can anyone tell me, how to extend an account whose password is expiring?
Thanks in advance
First, we'll need to double-check the database's password expiration policy.
Running a query against DBA PROFILES is the best approach to achieve this:
SQL> select * from dba_profiles where resource_name = 'PASSWORD_LIFE_TIME';
This verifies that the password expiry policy is set to 180 days by default. This value can be changed to infinite or any no. of days in the following way:
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
If you're using a different profile name like 'DEFAULT' or several profiles, be sure to modify the statement.
For more understanding of the Profile Management in Oracle, visit the link mentioned below:
Did you try connecting to SQLPLUS with it using old Password and reset? If it is locked you will need to unlock it using a separate account
I am looking for the steps to extend the user password expiring time.