Thursday, June 30, 2011

Fun with ancient clients

User was reporting an error with ODBC after a recent upgrade to 11g:

Unable to connect
[Oracle][ODBC][Ora]ORA-01017: invalid username/password; login denied

The user reported, and the tech verified that on this machine they could login with sqlplus but not ODBC on this PC. Multiple accounts were tried.

Interesting test case illuminated the issue: Created user with ALL UPPERCASE PASSWORD. Using this, could connect through ODBC.

The ancient 9i ODBC connection will not send a case sensitive password.

Made the following change, problem solved, user is happy though we probably could use this as an opportunity to force upgrading ODBC clients:

alter system set sec_case_sensitive_logon=FALSE scope=both


Unknown said...

I would like to know how i can create a user and password to my database because i've forgotten the main one and i ain't got password of none of them and my SYSDBA ask me for a password.

Biswajit Das said...

Hello, Thank you for your article share with us. It's very helpful for me. If you want to generate strong password then check my Online Password Generator Tool.