OC4J Connection Pool Error Message: java.sql.SQLException: ORA-01017: invalid username/password; logon denied


Error Description:
OC4J connection pool configuration testing to Oracle 11g database is giving following error.
OC4J Error message: Exception occurred testing connection. Exception: java.sql.SQLException: ORA-01017: invalid username/password; logon denied 

Problem Description:
By default the Oracle 11g passwords are case sensitive. Mainly if you are using any case sensitive passwords in your connection pool configuration, you will face this error. Somehow application is not sending the case sensitive password to the database and it throws this error.

The quick workaround for this error is to change your database to case insensitive using the following commands.

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 scope=spfile sid='*';

System altered.

The above command requires a db bounce. You can use scope=memory to make change without bounce.

SQL> alter system set sec_case_sensitive_logon=false scope=memory;

System altered.

SQL> show parameter sec_case_sensitive_logon

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon             boolean     FALSE
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google