12.2 Upgrade : Pre-Upgrade message “exclusive_mode_auth Failed Manual fixup recommended”

(Doc ID 2310808.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

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

Symptoms

 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.

 

 

 

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