My Oracle Support Banner

Upgrade : Pre-Upgrade message “exclusive_mode_auth Failed Manual fixup recommended” (Doc ID 2310808.1)

Last updated on OCTOBER 12, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


 When upgrading to 12.2,following message is shown when the Pre-Upgrade Utility is run

exclusive_mode_auth Failed Manual fixup recommended

 Pre-Upgrade.Log shows the following –

Your database system has at least one account with only the 10G password version (see the PASSWORD_VERSIONS column of DBA_USERS).

Starting with Oracle Database release 12.2, Exclusive Mode is the default password-based authentication mode. In Exclusive Mode, accounts
which only have the 10G password version (see DBA_USERS.PASSWORD_VERSIONS) are no longer accessible. If your system
has any account with only the 10G password version, Exclusive Mode must be switched off prior to the upgrade. See the Network Reference Manual
chapter about the SQLNET.ORA parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER for more details on Exclusive Mode.
Refer to the Oracle Database Readme 12c Release 2 (12.2) for further information regarding Bug 22031049.





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

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