Oracle Set Password To Not Expire

When trying to login to database as schema user you might see this error and this might cause the application to stop working.

Error Seen:

Root Cause:

Run one of the following commands: To set the password of one user to never expire, run the following cmdlet by using the UPN or the user ID of the. To set the passwords of all the users in an organization to never expire, run the following. The following statement causes a user's password to expire: ALTER USER user PASSWORD EXPIRE; If you cause a database user's password to expire with PASSWORD EXPIRE, then the user (or the DBA) must change the password before attempting to log in to the database following the expiration. Tools such as SQL.Plus allow the user to change the password on the first attempted login following the expiration.

Oracle Set Password To Not Expire Expired

How to set Oracle password to never expire. Many times we face issue of user password expiry in the DB. For this problem you can assign UNLIMITED limit to the user. By 'touched' I mean, change the password, if the profile allows it you could change the password to itself alter user XXXXX identified by values 'YYYYYY' where YYYYY is the password from dbausers (10g or lower) or sys.user$ (11g or higher) note in 11g you might have to use the spare4 column instead of the password column.

This error comes due to the Oracle password policy for database users. All passwords are tend to expire after certain time period if the password expiry time is not set to unlimited.

Workaround/Solution:

Follow below steps to set the password expiry to unlimited and not to expire.

1. Login to Oracle database as oracle or admin user.

2. Execute below commands to extend the expiry to UNLIMITED.

In case the user is not part of default profile you can add the user to default profile using below command.

or create a brand new profile which will have no password expiry and assign the user to that profile.

You can check the changes done to profile using below command:

Oracle Set Password To Not Expire Online

Comments are closed.