Thursday, March 3, 2011

Oracle SEC_CASE_SENSITIVE_LOGON

Today i try to connect into my test oracle 11g server installed in windows 2008 virtual machine.

Login from client always face ORA-01017: invalid username/password; logon denied.

After examine what kind of error, i found that 11g defaulted using this parameter:

SQL> show parameter sec_case_sensitive_logon

NAME TYPE VALUE
------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE

So, i try to change the parameter to :

SQL> alter system set SEC_CASE_SENSITIVE_LOGON=false scope=both;

System altered.
Than i try to connect again and successful.