How do I turn off Oracle password expiration

By | 08/03/2017

How do I turn off Oracle password expiration

How do I turn off Oracle password expiration

  • Login to Oracle database (Oracle 11g Express Edition) using SQL developer with system user id and password
  • Run below query’s

alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

  • Run below query’s : To reset password one more time

alter user <OMS DB User Name> identified by <OMS DB Password>; — give correct user name and old password

alter user system identified by system_password;

  • Verify the expiry date using below script

select username, account_status, EXPIRY_DATE from dba_users;

User Name Account Status Expiry date
SYSTEM OPEN null
SYS OPEN null
ANONYMOUS OPEN null
STERLING95 OPEN null

Password will never expire. Enjoy!!! Happy Learning

Register with us to get more OMS learning updates

OMS Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *