Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to update the password hash version for SYS?

charlesdschultzMay 24 2019 — edited Jun 7 2019

I filed an SR over 4 months ago, and Oracle Support has been UTTERLY useless in trying to tell us how to update the version of the password hash for the SYS user. I am actually amazed at how bad Oracle Support has been.

Currently, our SYS user shows a 10g password version. We wish to update/upgrade the version to 12c (and later versions once we deploy 19c). "alter user sys identified by ...." does not do the trick. orapwd does not do the trick. We have tried playing around with the sqlnet.ora .ALLOWED_LOGON_VERSION* parameters (both SERVER and CLIENT), as well as the the database sec_case_sensitive_logon and REMOTE_LOGIN_PASSWORDFILE parameters. What have we missed?

Database: OSEE 12.2

OS: Solaris 11

$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri May 24 08:26:42 2019

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select password_versions from dba_users where username = 'SYS';

PASSWORD_VERSIONS

-----------------

10G

Added on May 24 2019

#database, #database-security, #database-security-general, #security

3 comments

3,481 views