Lockout of all database authenticated users getting error ORA-01017: invalid username/password; logon denied

(Doc ID 2040705.1)

Last updated on JULY 09, 2017

Applies to:

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

Symptoms

All database authenticated users are getting the error: ORA-01017: invalid username/password; logon denied, even if we are sure the password should be correct.

When you inspect the DBA_USERS.PASSWORD_VERSIONS you only see 11G and 12C values but not 10G.

Changes

This may happen after an upgrade to 12c version 12.1.0.2 or 12.2

In Oracle release 12.2, the default value for the SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter is "12", i.e. Exclusive Mode.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms