ORACLE 11G PASSWORD EXPIRATION

Oracle 11g

In Oracle 11g release, schema password is expired periodically, by default this is 180 days. However, if required we can alter this setting and make the password permanent. This change needs to be done to the profile of the schema, all schemas under this profile is affected.

select PROFILE from dba_users where username = ‘TEST’;

ALTER PROFILE DEFAULT PASSWORD_LIFE_TIME UNLIMITED;

alter profile DEFAULT limit password_life_time UNLIMITED;


How to re-open expired oracle database account without change password

select USERNAME,ACCOUNT_STATUS from dba_users;

select password from user$ where name=’TEST’;

alter user SDTM_PROJECT identified by values ”;

select USERNAME,ACCOUNT_STATUS from dba_users;