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.............
No comments:
Post a Comment