My Oracle Support Banner

Why SYS user password version from (11g, 12c) to only 12c when SQLNET.ALLOWED_LOGON_VERSION_SERVER Set As 12a ? (Doc ID 2914322.1)

Last updated on APRIL 17, 2023

Applies to:

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

Goal

Why SYS user password version not changing from (11g, 12c) to only 12c ,when SQLNET.ALLOWED_LOGON_VERSION_SERVER Set As 12a ?

where as for other users it is changing from (11g, 12c) to only 12c when setting SQLNET.ALLOWED_LOGON_VERSION_SERVER Set As 12a

 

 SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS;

USERNAME                                                                                                                         PASSWORD_VERSIONS
-------------------------------------------------------------------------------------------------------------------------------- -----------------
SYS                                                                                                                              11G 12C ==> it is not showing only 12c for sys user.
SYSTEM                                                                                                                           12C

 

 

Solution

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
Goal
Solution
References


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