Thursday, May 04, 2017

12.2c dbua complains 10G version password being used

since dbua complains, and I checked the 12.1 database to be upgraded.
"In exclusive mode, accounts which oly have the 10G password version (see DBA_USERS.PASSWORD_VERSIONS)"   ...


There is one account RMAN somehow is having 10G version password.

SQL> select username, password_versions from dba_users where username='RMAN';

USERNAME
--------------------------------------------------------------------------------
PASSWORD_VER
------------
RMAN
10G

although the parameter sensitive is already true, set the minimum allowed version in sqlnet.ora (SQLNET.ALLOWD_LOGON_VERSION_SERVER) to 10. but still not worked for me.

Finally, solution worked for me is to change its password manually.

SQL> password
Changing password for RMAN
Old password:
New password:
Retype new password:
Password changed
SQL> select username, password_versions from dba_users where username='RMAN';

USERNAME
--------------------------------------------------------------------------------
PASSWORD_VER
------------
RMAN
10G 11G 12C


SQL> password
Changing password for RMAN
Old password:
New password:
Retype new password:
Password changed
SQL> select username, password_versions from dba_users where username='RMAN';

USERNAME
--------------------------------------------------------------------------------
PASSWORD_VER
------------
RMAN
10G 11G 12C