ORA-28002 the password will expire within

비밀번호 만료 (ORA-28002: the password will expire within 7 days)

1. 기간확인 

SQL> select resource_name, resource_type, limit

         from dba_profiles ;

 

RESOURCE_NAME                  RESOURCE_TYPE    LIMIT

------------------------------ ----------------    -------

PASSWORD_LIFE_TIME             PASSWORD            180

 

 

2. password_life_time 값을 unlimited로 바꾸어 줌

 

SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited ;

          Profile altered.

 

RESOURCE_NAME                    RESOURCE_TYPE     LIMIT

------------------------------ ----------------      -------

PASSWORD_LIFE_TIME             PASSWORD              UNLIMITED

 

3. 해당 유저의 password 속성 변경

 

현재 상태 조회

      SQL> select username, account_status, lock_date, expiry_date

              from dba_users

              where username = 'SCOTT' ;

 

          USERNAME             ACCOUNT_STATUS             LOCK_DATE    EXPIRY_DATE

          -----------------   -------------------             ------------    -------------

          SCOTT                   EXPIRED(GRACE)                                      18-DEC-13

 

해당 유저의 password 속성 변경

 

       SQL> alter user scott identified by password ;

                User altered.