ORA-1017: invalid username/password; logon denied

Posted on November 20, 2007 by chanmingman

ORA-1017: invalid username/password; logon denied

 

The developer might hit the error above if they are using the follow configuration:

– Oracle Database 11g Release 1

– ODP.NET 10.2 (Oracle.DataAcess.dll 10.2)

– The code like below:

  string oradb = "Data Source=orcldemo;Persist Security Info=True;User ID=HR;Password=hr;";

 OracleConnection conn = new OracleConnection(oradb); // C#

 conn.Open();

 

Thanks to Mark William point me to the new feature of Oracle Database 11g “Oracle Database Built-in Password Protections?” (http://download.oracle.com/docs/cd/B28359_01/network.111/b28531/authentication.htm#CHDJDCGI)

 

After issued the follow command with the HR login to through Oracle SQL Developer the C# code runs with error.

 
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE

About chanmingman

Since March 2011 Microsoft Live Spaces migrated to Wordpress (http://www.pcworld.com/article/206455/Microsoft_Live_Spaces_Moves_to_WordPress_An_FAQ.html) till now, I have is over 1 million viewers. This blog is about more than 50% telling you how to resolve error messages, especial for Microsoft products. The blog also has a lot of guidance teaching you how to get stated certain Microsoft technologies. The blog also uses as a help to keep my memory. The blog is never meant to give people consulting services or silver bullet solutions. It is a contribution to the community. Thanks for your support over the years. Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 25 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000. He and the team have developed many projects using .NET platform such as SCM, and HR based applications. He is familiar with the N-Tier design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400.
This entry was posted in .Net. Bookmark the permalink.

2 Responses to ORA-1017: invalid username/password; logon denied

  1. Dhanasekaran says:
    November 29, 2011 at 9:42 pm

    Good Job….

    Reply
  2. mangal says:
    December 25, 2012 at 1:49 pm

    thank u

    Reply

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.