select username,password_versions from dba_users; username password_versions ----- ----- jones 10g 11g adams 10g 11g clark 10g 11g preston 11g blake 10g The passwords for accounts jones , adams , and clark were originally created in Release 10 g and then reset in Release 11 g . select USERNAME from DBA_USERS where ( PASSWORD_VERSIONS = '10G ' or PASSWORD_VERSIONS = '10G HTTP ') and USERNAME <> 'ANONYMOUS'; Configure the system so that it is not running in Exclusive Mode by editing the setting of the SQLNET.ORA parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER to a level appropriate for affected accounts. The Oracle documentation notes that a setting of 8 permits most password versions, and allows any combination of the dba_users.password_versions values 10g, and 11g. Password versions for users are listed as “10G” from the dba_users view. Goal The password was listed as … which only have the 10G password version (see DBA_USERS.PASSWORD_VERSIONS) are no longer accessible. The account was open. One account expired. I pulled the values from spare4 column off the sys.user$ table, and updated accordingly with “identified by values”. If your system If your system has any account with only the 10G password version, Exclusive Mode must be switched off prior to the upgrade.

Applies to: Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this document applies to any platform. default, change password and switch user back to … 1.Database has been upgraded to 12.2 or a later version Applies to: Oracle Database - Enterprise Edition - Version 12.1.0.2 and later Information in this document applies to any platform. allowed_logon_version_server=8: A setting of 8 permits most password versions, and allows any combination of the dba_users.password_versions values 10g, 11g, and 12c.

sqlnet. PASSWORD_VERSIONS and Parameter sqlnet ALLOWED_LOGON_VERSION_SERVER For User with 10G in PASSWORD_VERSION (Doc ID 2410225.1) Last updated on AUGUST 04, 2018.

SQL> select username, 2 password, 3 password_versions 4 from dba_users 5 where username = 'U1' 6 / USERNAME PASSWORD PASSWORD ----- ----- ----- U1 NULL 10G 11G SQL> And, if user in question is assosiated with profile that has password verification function disallowing password reuse, OP will have to change user profile to, e.g. Symptoms. PASSWORD_VERSIONS in DBA_USERS for SYS user is 10G Even after Changing the Password (Doc ID 2644497.1) Last updated on MARCH 10, 2020.