3 Replies Latest reply on Jun 7, 2019 7:12 PM by charlesdschultz

    How to update the password hash version for SYS?

    charlesdschultz

      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

       

      Copyright (c) 1982, 2016, Oracle.  All rights reserved.

       

       

      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