Issue# 24:
After DB upgrade to 12c apps password is not working:
[ordpro@r12upgdb ~]$ sqlplus apps/apps
SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 22 21:07:57 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name: exit
Enter password:
ERROR:
ORA-01005: null password given; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[ordpro@r12upgdb ~]$
Solution:
- Check if sqlnet.ora contains the correct entry:
[ordpro@r12upgdb ~]$ cd $TNS_ADMIN
[ordpro@r12upgdb DPRO_r12upgdb]$ grep ALLOWED_LOGON_VERSION_SERVER sqlnet.ora
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
[ordpro@r12upgdb DPRO_r12upgdb]$
if
'SEC_CASE_SENSITIVE_LOGON' is FALSE:
SQLNET.ALLOWED_LOGON_VERSION_SERVER =
8
If it is TRUE,
then the parameter should be:
SQLNET.ALLOWED_LOGON_VERSION_SERVER =
10
[ordpro@r12upgdb DPRO_r12upgdb]$ sqlplus '/ as sysdba'
SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 22 21:12:02 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho parameter sec_case_sensitive_logon
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE
SQL> alter system set sec_case_sensitive_logon=false scope=both;
System altered.
SQL> conn apps/apps
Connected.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[ordpro@r12upgdb DPRO_r12upgdb]$
No comments:
Post a Comment