- 3,741,779 Users
- 2,248,475 Discussions
- 7,861,990 Comments
- 17.8K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 533.5K On-Premises Infrastructure
- 137.4K Analytics Software
- 38.5K Application Development Software
- 5.1K Cloud Platform
- 109K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.7K Infrastructure Software
- 105K Integration
- 41.5K Security Software
How to update the password hash version for SYS?
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 188.8.131.52.0 Production on Fri May 24 08:26:42 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Oracle Database 12c Enterprise Edition Release 184.108.40.206.0 - 64bit Production
SQL> select password_versions from dba_users where username = 'SYS';