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:
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