[Oracle11g] 사용자암호만료 / 사용자잠김 / ORA-28001: the password has expired / 만료기한 설정

** 1.암호 만료로 인한 접속불가
  => 콘솔에서 기존 암호를 입력하며, 암호가 만료됐다고 나오고, 암호를 변경하라고 나온다
  => 암호를 변경해도 되고, 기존암호를 한번더 입력해도 상관없다.

[root@na***db /]# su - oracle
[oracle@na**db ~]$ sql

SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 17 15:16:00 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> conn smarttourdb 
Enter password:
ERROR:
ORA-28001: the password has expired

Changing password for smarttourdb
New password:
Retype new password:
Password changed
Connected.

** 2.암호 변경주기 변경

[oracle@na***db ~]$ sql

SQL*Plus: Release 11.2.0.4.0 Production on Fri Aug 17 15:29:17 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

SQL> ALTER PROFILE DEFAULT LIMIT
  2  FAILED_LOGIN_ATTEMPTS 10
  3  PASSWORD_GRACE_TIME UNLIMITED
  4  PASSWORD_LIFE_TIME UNLIMITED
  5  PASSWORD_LOCK_TIME 1/1440;

Profile altered.

SQL> set pages 200 lines 200
SQL> col PROFILE for a20
SQL> col RESOURCE_NAME for a30
SQL> col RESOURCE_NAME for a30
SQL> select * from dba_profiles;

PROFILE              RESOURCE_NAME                  RESOURCE_TYPE            LIMIT
-------------------- ------------------------------ ------------------------ ------------------------------------------------------------------------------------------------------------------------
MONITORING_PROFILE   COMPOSITE_LIMIT                KERNEL                   DEFAULT
DEFAULT              COMPOSITE_LIMIT                KERNEL                   UNLIMITED
MONITORING_PROFILE   SESSIONS_PER_USER              KERNEL                   DEFAULT
DEFAULT              SESSIONS_PER_USER              KERNEL                   UNLIMITED
MONITORING_PROFILE   CPU_PER_SESSION                KERNEL                   DEFAULT
DEFAULT              CPU_PER_SESSION                KERNEL                   UNLIMITED
MONITORING_PROFILE   CPU_PER_CALL                   KERNEL                   DEFAULT
DEFAULT              CPU_PER_CALL                   KERNEL                   UNLIMITED
MONITORING_PROFILE   LOGICAL_READS_PER_SESSION      KERNEL                   DEFAULT
DEFAULT              LOGICAL_READS_PER_SESSION      KERNEL                   UNLIMITED
MONITORING_PROFILE   LOGICAL_READS_PER_CALL         KERNEL                   DEFAULT
DEFAULT              LOGICAL_READS_PER_CALL         KERNEL                   UNLIMITED
MONITORING_PROFILE   IDLE_TIME                      KERNEL                   DEFAULT
DEFAULT              IDLE_TIME                      KERNEL                   UNLIMITED
MONITORING_PROFILE   CONNECT_TIME                   KERNEL                   DEFAULT
DEFAULT              CONNECT_TIME                   KERNEL                   UNLIMITED
MONITORING_PROFILE   PRIVATE_SGA                    KERNEL                   DEFAULT
DEFAULT              PRIVATE_SGA                    KERNEL                   UNLIMITED
MONITORING_PROFILE   FAILED_LOGIN_ATTEMPTS          PASSWORD                 UNLIMITED
DEFAULT              FAILED_LOGIN_ATTEMPTS          PASSWORD                 10
MONITORING_PROFILE   PASSWORD_LIFE_TIME             PASSWORD                 DEFAULT
DEFAULT              PASSWORD_LIFE_TIME             PASSWORD                 UNLIMITED
MONITORING_PROFILE   PASSWORD_REUSE_TIME            PASSWORD                 DEFAULT
DEFAULT              PASSWORD_REUSE_TIME            PASSWORD                 UNLIMITED
MONITORING_PROFILE   PASSWORD_REUSE_MAX             PASSWORD                 DEFAULT
DEFAULT              PASSWORD_REUSE_MAX             PASSWORD                 UNLIMITED
MONITORING_PROFILE   PASSWORD_VERIFY_FUNCTION       PASSWORD                 DEFAULT
DEFAULT              PASSWORD_VERIFY_FUNCTION       PASSWORD                 NULL
MONITORING_PROFILE   PASSWORD_LOCK_TIME             PASSWORD                 DEFAULT
DEFAULT              PASSWORD_LOCK_TIME             PASSWORD                 .0006
MONITORING_PROFILE   PASSWORD_GRACE_TIME            PASSWORD                 DEFAULT
DEFAULT              PASSWORD_GRACE_TIME            PASSWORD                 UNLIMITED

32 rows selected.

SQL>