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