In Oracle 10g and before we all know that passwords are not case sensitive, so PASSWORD, Password, password would let you in and everything would be okay.
If you upgrade to Oracle 11g (I know lot of you are waiting for 11gR2), you will find that passwords are case sensitive. Here is an example of case sensitive passwords.
c:\Software>sqlplus bddd/bddd@dosa SQL*Plus: Release 18.104.22.168.0 - Production on Wed May 6 15:17:43 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - Production With the Partitioning and OLAP options BDDD@dosa >
Lets try to connect with a upper case password
c:\Software>sqlplus bddd/BDDD@dosa SQL*Plus: Release 126.96.36.199.0 - Production on Wed May 6 15:19:25 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied Enter user-name:
So what does this mean to apps running with 10g, that get ported to run with 11g. Make sure that the password set in the properties files is of the correct case.
You can also revert to 10g behavior by changing sec_case_sensitive_logon parameter to FALSE, since its TRUE by default.
alter system set sec_case_sensitive_logon=FALSE;