"ORA-01017: invalid username/password; logon denied" issue after EBS database clone(refresh)

This document describes how to fix "ORA-01017: invalid username/password; logon denied" issue.

 

Got below issue as part of post clone steps after refresh of EBS cloned database.

 

Issue:

[oracle@server1 ]$ sqlplus apps

SQL*Plus: Release 12.1.0.2.0 Production on Sun Jan 5 7:10:45 2022

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

Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
[oracle@server1 ]$

 

SQL> conn apps/xxxxxx
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
SQL> 

 

Solution:

SEC_CASE_SENSITIVE_LOGON should set to FALSE to overcome this issue.

 

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     TRUE
SQL> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE
  2  ;

System altered.

SQL> show parameter SEC_CASE_SENSITIVE_LOGON

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE

SQL> conn apps/xxxxxx
Connected.
SQL>

 

 

Thanks for going through the post.............