Product: ChemBioOffice Enterprise
After upgrading Oracle to 11g, some ChemBioOffice Enterprise passwords may not work due to the case sensitivity being a default setting in Oracle 11g.
EXAMPLE of the problem.
A newly created user was unable to login, getting the error:
---------------------------
Error Connecting
---------------------------
Sorry, an error occurred while
opening a client connection: while setting up connection to central
database: the Oracle User "testuser1" is not enabled or the specified
password is incorrect
---------------------------
OK
---------------------------
SOLUTION-1 (if the new 11g database is not yet created):
The Database Configuration Assistant (DBCA) allows you reverting the
security settings back to the pre-11g state during a database creation:
http://www.oracle-base.com/articles/11g/CaseSensitivePasswords_11gR1.php
SOLUTION-2 (when the new 11g database is already created):
Turn the case sensitivity off:
alter system set sec_case_sensitive_logon=false;
http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authentication.htm#DBSEG3225