remove expire for oracle database users

run export and find export ORACLE_SID connect by connect user/password@(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