Change the Password Version of user in Oracle 12c

Change the Password Version of user in Oracle 12c

Password Version of users depends upon the SQLNET.ORA file parameter value:

For Generating all Password Versions 10G, 11G and 12c
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 or 11

For Generating the 11G and 12c password Versions
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12

Generate only 12c Password Versions
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a

Check the current password version of user

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';

USERNAME  PASSWORD_VERSIONS
--------- -----------------
C##SUNNY  11G 12C

Generate only 12c password version

--1. Modify the SQLNET.ora file with following parameter
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12a

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
SQL> alter user c##sunny identified by sunny;
User altered.

--3. Show the password version
SQL> conn c##sunny/sunny
Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';

USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 12C


Note: 12 or 12a value in sqlnet.ora keep SEC_CASE_SENSITIVE_LOGON parameter to “TRUE” value.

Generate 11g and 12c password version

--1. Modify the SQLNET.ora file with following parameter
SQLNET.ALLOWED_LOGON_VERSION_SERVER=12

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
SQL> alter user c##sunny identified by sunny;
User altered.

--3. Show the password version
SQL> conn c##sunny/sunny
Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';

USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 11g 12C

Generate 10g, 11g and 12c password version

--1. Modify the SQLNET.ora file with following parameter
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

--2. Connect with sys user and change the password to generate 12c password version only after save change in SQLNET.ORA file.
SQL> alter user c##sunny identified by sunny;
User altered.

--3. Show the password version
SQL> conn c##sunny/sunny
Connected.

SQL> SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS where username = 'C##SUNNY';

USERNAME PASSWORD_VERSIONS
-------- -----------------
C##SUNNY 10g 11g 12C

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.