My Oracle Support Banner

ORA-1017 Trying To Change Expired Password Through Programmatic Interface From 11.2.0.3 To Lower Database Version (Doc ID 1426233.1)

Last updated on FEBRUARY 03, 2022

Applies to:

Oracle ODBC Driver - Version 11.2.0.3 and later
Oracle Provider for OLE DB - Version 11.2.0.3 and later
Oracle SQL Developer - Version 4.0 and later
JDBC - Version 11.2.0.3.0 and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.Symptoms

Trying to change a password for an expired user via a password change feature of a programmatic interface, from an 11.2.0.3 client or higher to a database version lower than 11.2.0.3, fails with the following error:

   ORA-1017: invalid username/password; logon denied

This includes, but is not limited to:

  • SQLPlus sessions
  • OpenWithNewPassword provided by the Oracle Data Provider for .NET (ODP.NET)
  • Change Password dialogue provided by the Oracle OLEDB Provider (ORAOLEDB).
  • OCIPasswordChange provided by the Oracle Call Interface (OCI).
  • Oracle SQL Developer interface.

 

 

Changes

The behavior does not occur under the same situation using a 11.2.0.2 client

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
Changes
Cause
Solution

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