ORA-1017 after DB upgrade to 12cR2


After db upgrade to 12cR2 user log in fails with ORA-1017.


This is due to sec_case_sensitive_logon set to false. sec_case_sensitive_logon parameter is set to true by default in release 12 and users with password version below 12 are unable to login


To fix this remove the deprecated instance initialization parameter sec_case_sensitive_logon  or set it to true. To support password version below 12 add the below parameter in sqlnet.ora of db home.


  • January 5, 2019 | 17 views
  • Comments