12.2 Upgrade : Pre-Upgrade message “exclusive_mode_auth Failed Manual fixup recommended”
Last updated on SEPTEMBER 26, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms