Potential Bug in 26ai with expired passwords

clock

Member²
We're running Oracle 26ai and PLSQL Dev 15.0.4.2064

We have profiles assigned to our users with PASSWORD_LIFE_TIME of 90 days and PASSWORD_GRACE_TIME of 5

Prior to our upgrade to 26ai, which was version 19c, whenever a password was in the Expired(Grace) period, PLSQL developer would recognize and then prompt for a reset. Now it simply displays the error message and disallows the login.

The error message is:
ORA-28098: Profile limits PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME are not unlimited, password will expire within 5 days.
 
In comparison, the error thrown against Oracle 19c that then prompts for a change is:

ORA-28002

So I'm wondering if it's simply an unhandled exception
 
This is indeed a known compatibility issue. We'll have a fix for this in the next release. At the moment the only workaround is to login with a tool like SQL*Plus and execute an "alter user identified by <password>" command from there, or remove the password lifetime limit from the profile.
 
Thanks for the information. Are there any other concerns/issues with our current version against Oracle 26 rdbms? Is a license only good for a single version or can we upgrade at any point using the same license?
 
Back
Top