Change the Password Version of user in Oracle 12c
Password Version of users depends upon the SQLNET.ORA file parameter value. For generating different version of password in Oracle database need to edit/choose the following parameter:
---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
---For 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
Example show the 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