remove expire for oracle database users

run export and find export ORACLE_SID

connect by

connect user/[email protected](ORACLE_SID) as SYSDBA

find out which accounts are expired

select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';

find out which accounts are open

select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%OPEN%';

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

http://riaschissl.blogspot.com/2010/07/oracle-unexpire-and-unlock-accounts.html
https://forums.oracle.com/forums/thread.jspa?threadID=1007887

Leave a Reply