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?
 
There are no other known issues with Oracle Server 26.

Licenses are restricted to the purchased major version (e.g. 15.0.x). Upgrades are available by purchasing a version upgrade option.
 
Back
Top