oracle11g报错ORA-28002:4天后口令将过期
出现此问题是由于oracle的default概要文件中默认的密码策略是180天密码过期“PASSWORD_LIFE_TIME=180天”。
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
PASSWORD_REUS