My Oracle Support Banner

PASSWORD_LOCK_TIME Is Not Setting Correctly (Doc ID 2923653.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Trying to set a the profile's PASSWORD_LOCK_TIME as follows:

      alter profile default limit PASSWORD_LOCK_TIME 0.0208;

      select * from dba_profiles where profile='DEFAULT' and RESOURCE_NAME='PASSWORD_LOCK_TIME';

      PROFILE RESOURCE_NAME RESOURCE LIMIT
      ---------------------------------------------------------------------------------------------------------------------
      DEFAULT PASSWORD_LOCK_TIME PASSWORD .0207 (It shows .0207 instead of .0208)

 

e.g Testing values from .0200 to .0218 We found 11 values were set rightly but .0202,.0205,.0207,.0208,.0210,.0211,.0213 and .0216 set an incorrect value (one decimal lower to the current one).

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.