Same user and password, PL/SQL can log in normally, C # program appears ORA-1017 username/password is invalid

Source: Internet
Author: User
Tags sql client

ORA-1017: Invalid username/password; Login is denied

First, the appearance of symptoms

1, using sqlplus and PL/SQL Client connection is OK

2, C # Use Oracle.DataAccess.Client connection, reported the above error

Second, the reason

1, oracle11g before the password is case-insensitive, starting from 11G default password case-sensitive

2, the use of 10G odp.net, will automatically convert the password into uppercase

Iii. Solutions

1. Enclose the password in the connection string with quotation marks so that the password does not turn into uppercase

2. Switch to 11G Client

3. Modify the database to disable case sensitive mode: ALTER SYSTEM SET Sec_case_sensitive_logon = FALSE

Because my connection string is written in an XML file, the "quotes" in the XML file need to be escaped and now provide the usual escape characters in the XML:

&lt; < Less than sign
&gt; > Greater than sign
&amp; & And
&apos; Single quotation marks
&quot; " Double quotes

Original

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.