ORA-28001: the password has expired

Connect to database using sys users:

Execute the following query.

Sql>Select * from dba_profiles


Here PASSWORD_LIFE_TIME field is responsible for expiring of password after 180 days.

Execute following command to disable this feature:

Sql> alter profile default limit password_life_time unlimited;

Now crosscheck for disabling of this feature.

Sql > select * from dba_profiles;

The value in PASSWORD_LIFE_TIME has changed to unlimited. Now password will never expire.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: