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