Search This Blog

Tuesday, November 9, 2010

Can not connect to Oracle 11g from TOAD but SQLPLUS is can

If you have set the SEC_CASE_SENSITIVE_LOGON parameter to true, then the database expects "case sensitive" passwords. TOAD somehow seems to convert the passwords to uppercase before logon.

Workarounds: 

1) Set your password in the database to UPPER case -- or --
2) Set SEC_CASE_SENSITIVE_LOGON parameter to false.

No comments:

Post a Comment

leave your message if you need help ...

Related Posts with Thumbnails