Oracle 11g client connecting to 11g database server

[kumasudh]

Hi,

I am facing issues while connecting to my oracle 11g database from a system where oracle 11g client is running.it fails with following error..
sqlplus "sys/sys@SMP_SERVICE as sysdba"
ORA-01017: invalid username/password; logon denied
But when i tried with the connect string "SYS/SYS@SMP_SERVICE as sysdba" (username/passwd in uppercase) it worked.

then i cheked on my database , the initialization parameter
SQL> show parameter sec_case_sensitive_logon ;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean TRUE

and
SQL> show sqlcase;
sqlcase MIXED

Then i set it to "FALSE" . after that also i m not able to connect with the connect string "sys/sys@SMP_SERVICE as sysdba" (username/passwd in lowercase).

Please help me finding out how to enable the connect string having lower case username/passwd in it to the server.

Thanks,
Best Regards
Sudhir

[Duncan Edmonstone · Accepted solution]

Sudhir,

Do you have a password file for the database... the IGNORECASE parameter used when creating a password file overrides the settings you changed. See here for details:

http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authentication.htm#CHDJDCGI

HTH

Duncan

[kumasudh]

Hi Duncan,

Thanks a lot for the help. I recreated my orapw file with ignorecase=y .and after this my client is able to connect to the server.

Thanks a lot once again.

Best Regards
Sudhir