Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-02377

invalid profile limit string

Cause

A value of 0 or lower was specified for the limit.


Action

Specify a limit greater than 0. For password profile parameters, some additional restrictions apply:

  • The specified limit of the PASSWORD_ROLLOVER_TIME profile parameter cannot exceed either 60 days, or the current value of the PASSWORD_GRACE_TIME limit of the profile, or the current value of the PASSWORD_LIFE_TIME limit of the profile; whichever value is lowest.
  • When the PASSWORD_ROLLOVER_TIME profile parameter is non-zero (the password rollover feature is enabled), the specified limit cannot be less than 1 hour, to give the application time to switch over to the new password.
  • The PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME limits cannot be less than the PASSWORD_ROLLOVER_TIME limit.
  • For the INACTIVE_ACCOUNT_TIME profile parameter, the specified limit cannot be less than 15 days.
  • For the PASSWORD_GRACE_TIME profile parameter, 0 is allowed as a permissible value.