oracle11g账号过期

11g中，用户的账号对应的profile在180天后会过期，这个需要手工去修改下profile

SQL> SELECT username,PROFILE FROM dba_users;

USERNAME               PROFILE
------------------------------ ------------------------------------------------------------
SYS                DEFAULT
SYSTEM                 DEFAULT
OUTLN                  DEFAULT
MGMT_VIEW              DEFAULT
FLOWS_FILES            DEFAULT
MDSYS                  DEFAULT
ORDSYS                 DEFAULT
EXFSYS                 DEFAULT
DBSNMP                 MONITORING_PROFILE
WMSYS                  DEFAULT
APPQOSSYS              DEFAULT

USERNAME               PROFILE
------------------------------ ------------------------------------------------------------
APEX_030200            DEFAULT
OWBSYS_AUDIT               DEFAULT
ORDDATA                DEFAULT
CTXSYS                 DEFAULT
ANONYMOUS              DEFAULT
SYSMAN                 DEFAULT
XDB                DEFAULT
ORDPLUGINS             DEFAULT
OWBSYS                 DEFAULT
SI_INFORMTN_SCHEMA         DEFAULT
OLAPSYS                DEFAULT

USERNAME               PROFILE
------------------------------ ------------------------------------------------------------
SCOTT                  DEFAULT
ORACLE_OCM             DEFAULT
XS$NULL               DEFAULT
MDDATA                 DEFAULT
DIP                DEFAULT
APEX_PUBLIC_USER           DEFAULT
SPATIAL_CSW_ADMIN_USR          DEFAULT
SPATIAL_WFS_ADMIN_USR          DEFAULT

30 rows selected.

SQL> SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

PROFILE          RESOURCE_NAME    RESOURCE_TYPE    LIMIT
-------------------- -------------------- ---------------- ---------------------------------------------
DEFAULT          PASSWORD_LIFE_TIME   PASSWORD     180

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;