ORA-28001: the password has expired - 추천 실적용 실전

1. 오류 화면

ERROR [org.enhydra.jdbc.xapool] GenericPool:cleanUp Error Exception in GenericPool:cleanUp java.sql.SQLException: Cannot get connection for URL jdbc:oracle:thin:@ ~ : ORA-28001: the password has expired

2. 조회

SQL> SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT';

조회 결과

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180

RESOURCE_NAME LIMIT
-------------------------------- ----------------------------------------
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7

16 rows selected.

3. 'PASSWORD_LIFE_TIME'을 'UNLIMITED'로 변경

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. 비밀번호 만료된 계정으로 재접속

[oracle@gtck-gw ~]$ sqlplus neos

​

SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 7 15:58:50 2014

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

Enter password:
ERROR:
ORA-28001: the password has expired

Changing password for neos
New password:
Retype new password:
Password changed

※재접속하지 않으면 갱신되지 않음.