11g密码过期问题
11g密码过期问题
开发反映，应用帐号即将过期，提示修改密码，登录数据库查看用户状态为LOCKED(TIMED)

sys@TYOLAP1(dtydb3)>select * from dba_profiles order by 1;

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
APP_PROFILE                    PASSWORD_GRACE_TIME              PASSWORD DEFAULT
APP_PROFILE                    PASSWORD_LIFE_TIME               PASSWORD DEFAULT
APP_PROFILE                    FAILED_LOGIN_ATTEMPTS            PASSWORD DEFAULT
APP_PROFILE                    PRIVATE_SGA                      KERNEL   DEFAULT
APP_PROFILE                    CPU_PER_SESSION                  KERNEL   DEFAULT
APP_PROFILE                    CONNECT_TIME                     KERNEL   DEFAULT
APP_PROFILE                    IDLE_TIME                        KERNEL   DEFAULT
APP_PROFILE                    COMPOSITE_LIMIT                  KERNEL   DEFAULT
APP_PROFILE                    LOGICAL_READS_PER_CALL           KERNEL   DEFAULT
APP_PROFILE                    PASSWORD_REUSE_TIME              PASSWORD UNLIMITED
APP_PROFILE                    PASSWORD_REUSE_MAX               PASSWORD UNLIMITED

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
APP_PROFILE       &nb