Archive for März 19th, 2009

Oracle Solution of ORA-28002: the password will expire within 10 days

Donnerstag, März 19th, 2009

In this case our interested resource is PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME.
The resource of Default profile PASSWORD_LIFE_TIME specify the number of days the same password can be used for authentication.The resource PASSWORD_GRACE_TIME specify the number of days after the grace period begins during which a warning is issued and login is allowed. If the password is not changed during the grace period, the password expires

To see what profile is assigned to a certain user, issue following select:

select profile from dba_users where username='<username>‘;

To see the limits set for the profile, issue following select:

select resource_name, resource, limit from dba_profiles where profile='<profile>‘;

RESOURCE_NAME RESOURCE LIMIT
——————————– ——– ———-
COMPOSITE_LIMIT KERNEL UNLIMITED
SESSIONS_PER_USER KERNEL UNLIMITED
CPU_PER_SESSION KERNEL UNLIMITED
CPU_PER_CALL KERNEL UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LOGICAL_READS_PER_CALL KERNEL UNLIMITED
IDLE_TIME KERNEL UNLIMITED
CONNECT_TIME KERNEL UNLIMITED
PRIVATE_SGA KERNEL UNLIMITED
FAILED_LOGIN_ATTEMPTS PASSWORD UNLIMITED
PASSWORD_LIFE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL
PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD UNLIMITED