Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 11g client connecting to 11g database server

SOLVED
Go to solution
kumasudh
Advisor

Oracle 11g client connecting to 11g database server

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
2 REPLIES
Duncan Edmonstone
Honored Contributor
Solution

Re: Oracle 11g client connecting to 11g database server

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

HTH

Duncan
kumasudh
Advisor

Re: Oracle 11g client connecting to 11g database server

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