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